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

 

 

 

solved 0
Guillermo Vélez 4 months 2 Answers 77 views Beginner 0

Answers ( 2 )

  1. 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.

    Best answer

Leave an answer

Sorry, you do not have a permission to answer to this question .