[Aydan Golaszewski]

Dear valuable Community Members – Happy New Year! Your contributions are very much appreciated. 

This is happening when Adjust Cost runs on the Job Queue – on occasion. 
Also when I run Adjust Cost manually for one Item – After 45-60 min. 
We using NAV 2016 with SQL Server version 2016 Service Pack 2. 

Has anyone seen this error and what can be done to fix it? Any ideas are welcome. 
Logs apparently do not show anything useful according to out infrastructure expert. 
Here is the complete text of the 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. 

——————————
Aydan Golaszewski
Lead ERP Analyst
Jason Pharmaceuticals (Medifast)
Owings Mills MD
——————————

[Meenakshi Singh]

Hi Ayden,

Not sure if you already figured it out or not. I have seen this error in the past. In our case, it was caused by the expiration of the password for the login that runs the adjust cost. Some times it would run as I would restart the service but then it would run under my login but as soon as I switched it to NAV service account, it would stop running. Even if that account is set to not expire, just re-enter the password and restart the service.

Good luck!
Meenakshi

——————————
Meenakshi Singh
Senior Manager, Business Applications
Home Market Foods, Inc.
NAVUG Programming Committee
——————————
——————————————-