Notifications
Announcements
No record found.
Hi Everyone,
I'm facing issue with SQL Server connection is hanged for all clients which are using AD user while SQL and NAV services are running normally.
Unless I restarted DB server, It will work fine.
Somebody help me please!
That can have a lot of causes.
Maybe you have a network / DNS issue ?
Hi Daravuth ,
Please try to restart your SQL service and NAV Service using local account and then choose Admin credentails, restart the services and then please try again.
Also please try to check Event Log.
Thanks.
Hi, As Inge and Nitin said, there are many causes for this, and if restarting the server doesn't fix it, it is recommended to check the logs in the Event when the problem occurs.
More details:
https://docs.microsoft.com/en-us/dynamics-nav/troubleshooting--a-fatal-error-occurred.-the-connection-to-sql-server-cannot-be-established
https://docs.microsoft.com/en-us/dynamics-nav/troubleshooting--sql-server-connection-problems
https://www.myerrorsandmysolutions.com/import-navencryptionkey-cannot-establish-a-connection-to-the-sql-server-database/
Hope this will help.
ZHU
Hi All,
This is event log in SQL Server before restarting DB Server:
Source spid45s
Message
The SQL Server Network Interface library could not deregister the Service Principal Name (SPN) [ MSSQLSvc/DB-SRV01.vattanacgroup.com:1433 ] for the SQL Server service. Error: 0xffffffff, state: 63. Administrator should deregister this SPN manually to avoid client authentication errors.
What is the root cause?
Hi, This seems to be a SQL problem, I found some information, I hope some of them can help you.
https://blog.sqlauthority.com/2015/12/03/sql-server-could-not-register-service-principal-name-persists-notes-from-the-field-105/
https://dba.stackexchange.com/questions/145821/the-sql-server-network-interface-library-could-not-register-the-service-principa
https://navnotes.wordpress.com/2017/07/25/could-not-register-the-service-principal-name-spn/
https://social.msdn.microsoft.com/Forums/aspnet/en-US/a638ff70-ecd6-458b-ab92-f6a99b3da48a/the-sql-server-network-interface-library-could-not-deregister-the-service-principal-name?forum=sqlsetupandupgrade
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,990
Jainam M. Kothari 1,576 Super User 2025 Season 2
YUN ZHU 1,028 Super User 2025 Season 2
