Navision server cannot be found

TomekJot

I’ve noticed strange thing in my NAV installation. Occasionally, different users can’t get an access to Navision server. There is a warning message like:
The Navision server cannot be found. Try again later or contact your system administrator.
Or
The 192.168.XX.XX server cannot be found. Try again later or contact your system administrator.

When there is a message about “Navision” server problem – solution is to enter IP addres i.e. 192.168.XX;
When there is a message about “192.168.XX server problem – I can use “Navision” name instead.

I thought it was a local network problem, but in both scenarios I’m able to “ping”.
There is also other solution: if I don’t change server name, after some time (several minutes or hours) everything works OK.

Do you have any suggestions, what should be checked and where. Thanks in advance!

NAV info:
Dynamics 2009 R2 Classic Client
SQL Database

abhinav0408

just Check your firewall Settings. Make sure it is Off.

If its Off then check the permissions of your Database.
Just allowed it to Everyone.

TomekJot

Yes, the firewall is Off actually. The strange thing is that the connection might be established when you select IP address 192.168.XX or "navision" server name.

abhinav0408

Go to database properties and set the permissions to everyone......
this might work....

air_wolf

this occurs in the following situations:
1. DNS problems - check if they can reach DNS and if it serves correctly the name of the SQL server
2. network issue - check for damaged equipment
3. if you have active directory environment and AD authentication - check if AD is working properly
4. if you have SQL installed as instance (nav\navinstance)- check if SQL is listening on all interfaces and if you can reach the SQL instance from SSMS.

in some cases I have gotten authentication errors against SQL server. usually a logoff ant then logon back again solves the issue.

william_marcelinus

Dear,

Have you check the CustomSettings.config in your installation directory in Nav Server?
you could define your server instance to be called in RTC by custom or database server connection.
hope this answer could help you

jlandeen

One point highlighted here is that you may be trying to connect to a database on a SQL Server with a named instance <server>\<instance>.

This was the issue that I was having and there are a few MSDN articles I worked through to resolve it. But basically I enabled TCP/IP communication and turned on the SQL Browsing Service.

See: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/df095aee-fff1-4b11-ae7c-7be6fa66e37a/no-connection-to-sql-2008-enterprise-with-nav2009-classic?forum=sqlgetstarted

and: http://msdn.microsoft.com/en-us/library/ms165718.aspx