SQL Server not starting

Question

issue - SQL Network Interface library could not deregister my Service Principal Name (SPN). causing an issue where my SQL server is not starting.

Logs show -

The SQL Server Network Interface library could not deregister the Service Principal Name (SPN) [ MSSQLSvc/IDL-A12197-VM.domainde.com ] for the SQL Server service. Error: 0x2af9, state: 61. Administrator should deregister this SPN manually to avoid client authentication errors.

The SQL Server Network Interface library could not deregister the Service Principal Name (SPN) [ MSSQLSvc/IDL-A12197-VM.domainde.com:1433 ] for the SQL Server service. Error: 0x2af9, state: 61. Administrator should deregister this SPN manually to avoid client authentication errors.

What I did -

I did the deregister it mentions for IDL-A12197-VM.domainde.com; deregister PowerShell code on the screenshot shows me Unregistering and completing. But then, when I try to restart the SQL server, I have the same issue.

I researched and tried to fix the issue but couldn't find a solution. Could you help me start my SQL server?

What do I need to do

sql-server

Answer 1

Hi,

you can use temporary local SYSTEM account to startup your MSSQL Service ----> very bad idea in terms of security setup (so do this temporarily).

execute the following in CMD session:

setspn -L MSSQLServiceAccount

what are the results....does it return/list your VM ?

Regards,

Emad