Error connecting Change Lister to SQL Server

Asked By kingruiz 0 points N/A Posted on - 03/06/2012

Hi guys,

When trying to connect Change Lister to SQL server using the Microsoft Dynamic server, I get the following error message.

What should I do? Please help me.

Thanks.

Error:

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 AUTHORITYNETWORK SERVICE'.

• Status: Open
• Question Views: 2253
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Tunacao_Caaron1 20 points N/A #94323

Error connecting Change Lister to SQL Server

Hey Kingruiz!

If you are facing this problem you just have to update your Custom Settings.config file with some new database name.

To update the Custom Setting.config, follow these steps:

• <?Xml Version="1.0" encoding="UTF-8"?>
• <appsetting>
• <!–
• The network protocol used to access the database.
• Valid options: Default, Namedpipes, Sockets
• –>
• <Add key="NetType" value="Default"></add>
• <!–
• Name of the database server to connect to.
• –>
• <Add key="DatabaseServer" Value="TOMASZNC6320"></add>
• <!–
• Name of the database instance to connect to.
• –>
• <Add Key="DatabaseInstance" Value=""><add>
• <!–
• Name of database to connect to.
• –>
• <Add key="DatabaseName" value="Extended Demo Database {Rs} |"><add>
• <!–

After doing all this, just restart your program and say goodbye to the error.

Thanks.

About Tunacao_Caaron1

Questions
1

Answers
399

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 03/17/2012
• Question Category: MS SQL Server