Nav couldn't connect to the database when I am on certain network

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

When I am on the company's network, the Nav couldn't find the database server via the ip address, the message is "the xx.xx.xx.xxx server cannot be found. Try again later or contact your system administrator'.

But if I switch the wifi to other network (the mobile hotspot wifi, or an idle network we are going to cancel) the connection can be established within seconds.

Is anyone encounter the same situation and could be able to help?

I am using Nav 2009 classic.

Thanks!

Dennis

*This post is locked for comments

All responses (16)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi,

You should check the connectivity between client to server and try to check the required port.
Suggested answer

4BzSoftware 6,071 on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi Dennis,

Does it happen with your PC only? How about other PCs?

Is there any firewall or anti-virus program blocks your out going data? Temporarily turn them off for checking may help.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi Khoa,

Thanks for the reply. The Database Server is not in our company's network. It is hosted by a cloud solution company. The Nav is installed in our local pc within our company's network. I am trying to connect but not successful.

Thanks!

Dennis
Community Member Microsoft Employee on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi Alex,

Tried to change the configuration file, but it still doesn't work.

I may need to lower the security level of the current network.

Thanks!

Dennis
Suggested answer

4BzSoftware 6,071 on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi Dennis,

Some suggestions for you:

1. Try to use LAN IP or Computer Name of Database Server.

2. Make sure your laptop and Database Server are in same company's network (check LAN IP Address/Subnet Mask and test with ping cmd).
Suggested answer

Alex A 2,348 on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi,

Open the NAV Configuration file located on your local computer:

The config file may be located at the following directory:

C:\ProgramData\Microsoft\Microsoft Dynamics NAV\70

(if not then try C:\Users\<username>\AppData\Local\Microsoft\Microsoft Dynamics NAV)

Look for settings similar to these near the top:

<add key="Server" value="ServerName.domain.name"/>

<add key="ClientServicesPort" value="7046"/>

<add key="ServerInstance" value="PROD"/>

Make sure these settings are correct.

Check the "Server" value. If you cannot connect to the server by servername then try using the IP address instead. If this is the case then you are having a DNS related problem.

Check the "ClientServicesPort" value. This port must be opened on the wifi router you are connecting through. To check the port settings on the router you will need an admin to login to the router via a web browser and make sure the port is open.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi Alex,

With the current setting on my computer, I can link to the remote server using other network (for example, my mobile internet hotspot). Can I narrow down the problem to the router configuration?

Thanks!

Dennis
Suggested answer

Alex A 2,348 on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi Dennis,

Yes it means that you are able to connect to the server. It means you sent out a request from your machine and you got a response from the server machine. So this means that you have eliminated the hardware connection as a problem. You are physically connected through the network.

Now the problem must lie in software configuration... this could be the NAV settings in the config file on your local computer, or it could mean that the port needs to be opened on the router to let NAV connect through it.

The config file may be located at the following directory:

C:\ProgramData\Microsoft\Microsoft Dynamics NAV\70
(if not then try C:\Users\<username>\AppData\Local\Microsoft\Microsoft Dynamics NAV)
Community Member Microsoft Employee on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hi Alex,

Thanks for the reply.

I tried and have the 4 connection responses. 'bytes = 32 time = 40ms TTL = 116'.

Does it mean, under the current network, my computer is able to talk to the remote server?

If so, it's weird I cannot link the Nav to the remote server using the ip address.

Dennis
Suggested answer

Alex A 2,348 on at

Like (0)

Report

RE: Nav couldn't connect to the database when I am on certain network

Hello,

The first step to determine this is to open the command prompt:
=>Click start button and type cmd in the search box.

You will see a black window open up. Then type the following in the command window:
ping xx.xx.xx.xxx (use the IP address of the server to replace the xx.xx.xx.xxx - or you could use the computer name of the server: ping server_name)

After you press enter you should see some messages like the following:
Pinging xx.xx.xx.xxx with 32 bytes of data:
Reply from xx.xx.xx.xxx: bytes=32 time<1ms TTL=64
Reply from xx.xx.xx.xxx: bytes=32 time<1ms TTL=64
Reply from xx.xx.xx.xxx: bytes=32 time<1ms TTL=64
Reply from xx.xx.xx.xxx: bytes=32 time<1ms TTL=64

You should get four replies. If you get four replies then you are Physically connected to the server, which means the network is working between your computer and the server.

If you get a different response, such as:
Pinging xx.xx.xx.xxx with 32 bytes of data:
Reply from xx.xx.xx.xxx: Destination host unreachable
Reply from xx.xx.xx.xxx: Destination host unreachable
Reply from xx.xx.xx.xxx: Destination host unreachable
Reply from xx.xx.xx.xxx: Destination host unreachable

Or if you get no response... then it could mean the network is not working between your computer and the server. Some network administrators disable the ping command but it's a very valuable tool to determine if you can connect to another machine on the same network. If you do get a reply then the problem is not with the physical network (hardware connection).

If you're network has been configured to block your computer it would be a setting at the router level or at the server level so you wouldn't be able to access that without a password. If you can't reach the server with a ping command, then I wonder if you are you able to access the Internet from your computer? The troubleshooting takes networking experience to go from here. I wish you luck.