Resolving authentication issues
To resolve this problem, go to KB-1311 in the Centrify Knowledge Base, select Attachments, and click View > Open > Run to run the checkspn.vbs
script on a computer that is joined to Active Directory.
Note: The user who is running this command must have permission to register the SPN on the service account.
By default, this script runs in report-only mode. It checks whether the required SPNs are present on the service account in question and issues a prompt to fix it, if not. This script registers the SPN in the service account servicePrincipalName
attribute in the format:
MSSQLSvc/<FQDN>:<tcpport>