SBX - Search With Button

SBX - Forum Post Title

A connection to SQL server is no longer usable.

Microsoft Dynamics NAV Forum

VarunB asked a question on 14 Mar 2018 3:19 AM

Question Status

Suggested Answer

We're getting the following error: 

A connection to SQL server is no longer usable. This could be caused by one of the following reasons: 

* The server has been shut down manually or because of an error. 

* The SQL server connection settings are not correct. 

* A network failure has occurred. 

* A hardware failure has occurred on the server or on your computer. Try to connect again later or contact your system administrator.

We tried doing the following: 

You can do following

1. Open SQL Studio

2. Double clicked on the "NT AUTHORITY\NETWORK SERVICE" user under "Security / Logins"

3. Selected "User Mapping"

4. Check marked the database which neeed access to

5. Copy in "$ndo$navlistener" into "Default Schema" for selected database

6. check marked following

db_datareader

db_datawriter

db_ddadmin

We had to recreate the "NT AUTHORITY\NETWORK SERVICE" user under "Security / Logins" as it wasn't there. Inspite of doing the above steps, we're still getting the same error. How do we go about this?

Reply

Is your SQL Server service running? Check the services on your server machine.

If the problem is related when using NAV web client, check here:

docs.microsoft.com/.../troubleshooting--a-fatal-error-occurred.-the-connection-to-sql-server-cannot-be-established

Reply
Andrey Baludin responded on 14 Mar 2018 4:03 AM
My Badges
Suggested Answer

Check that it started. I suppose it's stopped.

Reply
VarunB responded on 14 Mar 2018 4:05 AM

Yup, it has started. Still not working.

Reply
VarunB responded on 14 Mar 2018 4:06 AM

Yup, it is working. Changers aren't happening on the client as well as on the browser.

Reply
amkdmk responded on 14 Apr 2019 9:46 PM

We you able to figure out the issue?  We've had the exact same issue on one Job Queue job.

Sorry, just realized this is from last year and I'm not able to delete my post.

Reply
Andrey Baludin responded on 14 Mar 2018 4:03 AM
My Badges
Suggested Answer

Check that it started. I suppose it's stopped.

Reply

SBX - Two Col Forum

SBX - Migrated JS