SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,129 questions
SQL Server not starting
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 63%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ3%3C/text%3E%3C/svg%3E)
ZM-3283
40
Reputation points
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
{count} votes
-
Erland Sommarskog 113.3K Reputation points MVP2024-11-26T22:37:09.58+00:00 Where do you have this SQL Server instance? On your private machine? At work? In some cloud environment? It is easier to help, if we have the context.
It seems that you try to link to an image, but the link did not work for me.
-
ZM-3283 40 Reputation points
2024-11-27T11:09:46.1+00:00 Azure Windows VM
and here is the image
-
Erland Sommarskog 113.3K Reputation points MVP
2024-11-27T22:43:47.6333333+00:00 Those errors are out of my league, but I hope someone else can fill in, now that you have clarified the environment.
Sign in to comment
Sign in to answer