i try to setup Dynamics NAV 2009 R2 and get the following error message when connect through RTC.
"The Microsoft Dynamics NAV Server cannot connect the Change Lisener to SQL Server because of the following error: A network-related or instance-specific error occured while establishing a connection to SQL Server". The server was not found or was not accessible. Verify that the instance name is correct that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
A windows connection with the classic client works withoud any problems.
The NAV Server starts without any errors.
I've created as well for the user as well for the nav server a windows login with super rights.
Firewall ist off.
I also tried to install the nav server directly on the sql server, but got the same error message.
On the SQL Server there is also a 4.00 SP3 Live DB.
I tried to start the "Best performance analyzer" on the nav server, but i get the error message, that the nav server is not installed. Although the server is installed properly..
Does anyone have any suggestions?