Error: The Microsoft Dynamics NAV Server cannot connect to the Change Listener to SQL Server because of the following error

—————————
Microsoft Dynamics NAV
—————————
The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: Cannot open database “Demo Database NAV (6-0)” requested by the login. The login failed.

Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
—————————
OK
—————————

According to Murphy’s Tech Law – New systems generate new problems. And that’s exactly how you feel when you encounter new error messages. I wanted to open my RoleTailored client, and instead, I got this error message:
Error - The Microsoft Dynamics NAV NAV Server cannot connect to the Change Listener to SQL Server

Whaaaat? And then (rereading the error message third time) I realized, that yesterday I have been playing around with latest “extended demo database” and I have renamed my database to “Demo – Database NAV (6-0)” to “Extended Demo Database (R2)”:
Database Name - Extended Demo Database (R2)

So, what’s the solution? Renaming the database back to original name? Well… that would work. But a better idea would be to update “CustomSettings.config” with new database name:
Update CustomSettings config

Then, restart “Microsoft Dynamics NAV Server” windows service, and try running RoleTailored client again.
Connected to RTC

Result!

Related Links

Technorati Tags: , , , ,

This entry was posted in Dynamics NAV / Navision, errors and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *