In SQL Server Configuration Manager on the Advanced tab in TCP/IP Protocol properties box there is an option Accepted NTLM SPNs. What is the use of that option and how it can be used?


1 Answer 1

  • Accepted NTLM SPNs

The Accepted NTLM SPNs variable is needed when a server is known by more than one SPN. When a client attempts to connect to the server by using a valid SPN that the server does not know, service binding will fail. To avoid this problem, users can specify several SPNs that represent the server by using Accepted NTLM SPNs. Accepted NTLM SPNs is a series of SPNs separated my semicolons. For example, to allow the SPNs MSSQLSvc/ HostName1.Contoso.com and MSSQLSvc/ HostName2.Contoso.com, type MSSQLSvc/HostName1.Contoso.com;MSSQLSvc/HostName2.Contoso.com in the Accepted NTLM SPNs box. The variable has a maximum length of 2,048 characters. Accepted NTLM SPNs is on the Protocols for MSSQLSERVER Properties (Advanced Tab) in SQL Server Configuration Manager.

Microsoft Documentation

  • I've already read the documentation. I've server named EC80A5000SQL1 and I want users to be able to connect using name SQL, So I made dns record named SQL and in Accepted NTLM spns I entered MSSQLSvc/EC80A5000SQL1.mydomain.com;MSSQLSvc/SQL.mydomain.com . Now SQL Server service is not starting.
    – admin
    Nov 24, 2019 at 8:00
  • Have you tried to change SQL instead of MSSQLSvc/EC80A5000SQL1.mydomain.com;MSSQLSvc/SQL.mydomain.com. Check this out - subscription.packtpub.com/book/networking_and_servers/… Nov 27, 2019 at 13:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.