Role Tailored Connection to MSSQL

Business Central/NAV Technical Forum
1

Please any one can help me on how to connect role tailored to our MSSQL server.

" The Microsoft Dynamics NAV Server Cannot connect the change Listener to SQL Server

because of the following Error: A network - related or instance - Specific error occurred while

establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance

name is correct and that SQL server is configured to allow remote connections(provider: SQL Network Interface;

error:26-error locating Server/Instance Specified)

SQL data is located in my native PC as well as my role tailored.

please help!

Anthony

2

Is your login added in windows authentication of database?

3

Perform http://msdn.microsoft.com/en-us/library/dd568739.aspx

4

actually we are database authenticated.

5

RTC works only with Windows Authentication [N]