SPN registration for SQL AOAG
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,
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
Thank you so much for the answer Rajul.