mibuso.com

Microsoft Business Solutions online community
It is currently Thu Oct 23, 2014 3:37 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: [Solved] Change Listener RTC Connection Error 26
PostPosted: Tue May 15, 2012 1:40 pm 
Offline

Joined: Fri Apr 29, 2005 12:55 pm
Posts: 47
Location: Germany
Country: Germany (de)
Hi,
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?


Last edited by Nokio on Wed May 23, 2012 8:30 am, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Tue May 15, 2012 2:06 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4602
Location: Hyderabad
Country: India (in)
did you try by adding Server IP in Host file of client?

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Tue May 15, 2012 3:45 pm 
Offline

Joined: Fri Apr 29, 2005 12:55 pm
Posts: 47
Location: Germany
Country: Germany (de)
For test purposes I installed the Client as well as the nav server on the sql server (3 tier on same server). Unfortunately I got the same error message.


Top
 Profile  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Tue May 15, 2012 3:53 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4602
Location: Hyderabad
Country: India (in)
Did you setup config file correctly?like server name,database name and instance name etc..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Tue May 15, 2012 4:02 pm 
Offline

Joined: Thu Jan 29, 2009 5:06 pm
Posts: 365
Location: Sofia
Country: Bulgaria (bg)
did you try this? http://msdn.microsoft.com/en-us/library/dd568739.aspx

_________________
-Mihail- [MCTS]


Top
 Profile E-mail  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Wed May 16, 2012 8:14 am 
Offline

Joined: Fri Apr 29, 2005 12:55 pm
Posts: 47
Location: Germany
Country: Germany (de)
mohana_cse06 wrote:
Did you setup config file correctly?like server name,database name and instance name etc..


Yes the I've setup as well the NAV server config, as well the client config with the correct server data. Before I had setup it, I got another error that he can't connect.


Top
 Profile  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Wed May 16, 2012 8:20 am 
Offline

Joined: Fri Apr 29, 2005 12:55 pm
Posts: 47
Location: Germany
Country: Germany (de)
mihail_kolev wrote:


Yes I did step by step the needed queries in the management studio. Additionally I checked the permissions for ghe object tracking table. The Windows Authentification "service_nav" which I've created has proper permissions (choose). :(..


Top
 Profile  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Wed May 16, 2012 9:40 am 
Offline

Joined: Thu Jan 29, 2009 5:06 pm
Posts: 365
Location: Sofia
Country: Bulgaria (bg)
did you try using the full domain names for the machines - in the config for the server and for connection url for the rtc client?

ex: in the config file for the service for DatabaseServer instead of YOURSQLSRV try YOURSQLSRV.yourcompany.com (the full domain name)

_________________
-Mihail- [MCTS]


Top
 Profile E-mail  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Wed May 23, 2012 8:29 am 
Offline

Joined: Fri Apr 29, 2005 12:55 pm
Posts: 47
Location: Germany
Country: Germany (de)
I found the problem..
It was indeed a false parameter in the DynamicsNAV Server config file.

I had the Databasename in the option "DatabaseInstance". After I changed it to Empty, it worked.

----
Name of the database instance to connect to.
-->
<add key="DatabaseInstance" value=""></add>
----

Thx.


Top
 Profile  
 
 Post subject: Re: Change Listener RTC Connection Error 26
PostPosted: Mon Apr 22, 2013 3:33 pm 
Offline

Joined: Mon Apr 22, 2013 3:26 pm
Posts: 1
Country: United Kingdom (uk)
Thank you Nokio. Your solution also resolved my issue. Cheers.


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: