This page provides a list of the common Service Principal Name (SPN) formats associated with SQL Server.

Note: Many products will create both SPN records for a single instance.

• Default / named instance: MSSQLSvc/server:1433
• Default / named instance: MSSQLSvc/server.domain.com:1433

Note: The TCP port isn't required. The SPN may not have a port for instances configured with Named Pipes or Shared Memory.

However, all formats are supported and may be used by vendors.

• Default instance: MSSQLSvc/server
• Default instance: MSSQLSvc/server.domain.com
• Named instance: MSSQLSvc/server:InstanceName
• Named instance: MSSQLSvc/server.domain.com:InstanceName
• Optional format: MSSQLSvc/server:1433
• Optional format: MSSQLSvc/server.domain.com:1433

setspn -s MSSQLSvc/server DOMAIN\SQLServiceAccount
setspn -s MSSQLSvc/server:1433 DOMAIN\SQLServiceAccount
setspn -s MSSQLSvc/server:InstanceName DOMAIN\SQLServiceAccount
setspn -s MSSQLSvc/server.domain.com DOMAIN\SQLServiceAccount
setspn -s MSSQLSvc/server.domain.com:1433 DOMAIN\SQLServiceAccount
setspn -s MSSQLSvc/server.domain.com:InstanceName DOMAIN\SQLServiceAccount

• https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/register-a-service-principal-name-for-kerberos-connections?view=sql-server-2017
• https://docs.microsoft.com/en-us/sql/relational-databases/native-client/features/service-principal-name-spn-support-in-client-connections?view=sql-server-ver16