The report Adjust Cost - Item Entries gives me a fatal error during the report runs.
A fatal error occurred. The connection to SQL server cannot be established or is no longer usable. This can 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 again later or contact your system administrator.
This error message shows up for one company and not in other companies in same database.
I looked on internet to find an answer for this topic but couldn't find it.
Does anyone has an experience in this error?
It happens in Dynamics NAV version 7.1.3 build 7.10.45478
Have you imported Items (or any other data used in this process) from external source?
I remember some similar case long time ago, and it took me over 2 days to solve the problem... I tried a lot of thinks, but finally the problem was an special character (in email field), that was not visible in Dynamics NAV Client, but when I Copied from Dynamics NAV Client to Notepad++, the character appeared magically.
Once I deleted this character, all worked as expected.
It can also be a code page issue where you have special characters in one database then restore to a new database with a new codepage or collation.Also copy pasting from Excel to SQL via SSMS can cause major issues like this.