29
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!
Hi, This seems to be a SQL problem, I found some information, I hope some of them can help you.
https://navnotes.wordpress.com/2017/07/25/could-not-register-the-service-principal-name-spn/
Thanks.
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, 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--sql-server-connection-problems
Hope this will help.
Thanks.
ZHU
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.
That can have a lot of causes.
Maybe you have a network / DNS issue ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (