Contents
Why is MY SQL Server service principal name not registered?
The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/servername ] for the SQL Server service. Windows return code: 0x2098, state: 15. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message.
Can a service Principal Name ( SPN ) be registered?
But when we change the account this is what we get. SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
Is it possible to register a SPN for SQL Server?
SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
Why is my SPN not registered in Windows?
Windows return code: 0x21c7, state: 15. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
How to register a service in SQL Server?
The SQL Server Service essentially regsisters the SPN on service start automatically. If you cannot start the SQL Server Service then you will have to perform this task manually. Ensure the service account that start the SQL Server Service is allowed to read and write SPNs.
How to fix the SQL Server network interface library?
Right click on start and go to Computer Management >> Services and Applications >> SQL Server Configuration Manager >> SQL Server Services >> right click on all the servers and hit on start. This fixed my issue and was back on track. I am still looking for a better answer on why or what can cause that but for now, here’s the fix!
What is the error ” I could not start SQL Server “?
I could not start SQL Server Service . I get error 1067 and this from the error log* The SQL Server Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x13, state: 2.