I have a question about how to manually set SPN for using Kerberos authentication on a SQL cluster.
I also have a default named instance, do i specify the name of the instance?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
To create a SPN for a SQL FCI, use the FQDN of the FCI instance. For example, if the FCI name is "SQLFCI1" on the contoso domain and it listens on port 22000 with domain account SQLSvcAcct then the spn would be:
setspn -s MSSQLSvc/SQLFCI1.contoso.com:22000 Contoso\SQLSvcAcct
If you don't want to deal with doing this by hand there is a great tool provided by Microsoft for this.