SPN registration for SQL AOAG
Question
Hi guys,
I’m configuring an SCCM infrastructure with one Primary Server Active and one Passive. To achieve this I need to set up the SCCM DB on an SQL Always On Availability Group.
I’m going to run my SQL service by using a domain service account.
Under normal circumstances, I would create on my domain an SPN for my service account by using the SQL server NETBIOS name and another with the FQDN. See below:
setspn –A MSSQLSvc/<SQL Server NETBIOS name>:1433<DomainAccount>
setspn –A MSSQLSvc/<SQL Server FQDN>:1433 <DomainAccount>
But as in this case my SQL server is going to be a cluster, I don’t know how to register the SPN. Do I use the name of the cluster? One per server participating in the cluster?
I’m pretty confused about this…… 🙁
thanks and best regards,
Guillermo Vélez
Answers ( 2 )
You need to register the spn for always on availability group listener.
Check the section SPN for Always-On SQL Listener in the below blog
https://www.sqlshack.com/overview-of-service-principal-name-and-kerberos-authentication-sql-server/#:~:text=SPN%20for%20Always-On%20SQL,for%20all%20Availability%20group%20replicas.
Thank you so much for the answer Rajul.