“The target principal name is incorrect. Cannot generate SSPI context.”
To Fix this,
You need to register the service account in SPN.
MSSQLSvc/ Server1.domain.us.dom Domain\ServiceAccount
MSSQLSvc/ Server1.domain.us.dom:1433 Domain\ServiceAccount
After SPN is registered successful, the error is resolved. Thank you.