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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (16)

Answers (0)

Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

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

Hi,

Just to clarify, do you use any VPN to access from outside your company?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Hi Nareshwar,

Thanks for reply.

No, I just sit in the office and use office's wifi.

I am not a network expert and the current network was not set up by me. I am thinking any chance the current network configuration blocks the database connection?

I can connect to the database even use my mobile phone network.

Thanks!

Dennis

Was this reply helpful? Yes No
Suggested answer

IshwarSharma 729 on at

Like (0)

Report

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

You need to check with your network/system admin. There may be specific setting on your system which might be blocking your access to navision.

Was this reply helpful? Yes No
Suggested answer

Alex A 2,801 on at

Like (0)

Report

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

You'll want to ping the server using the IP address to see if there is a connectivity issue. If you get a reply then it is not a hardware related connectivity issue but rather a software configuration related issue. When you get connectivity issues like this you have to isolate the problem by elimination. Start at the hardware layer and make sure you're connected to the server with that wifi network. Then, start looking at any firewall settings that are blocking this wifi network on server and client side. Make sure the proper ports are opened on this wifi network's router.... and you just keep going until you find the issue - one layer at a time.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

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

I guess it might be because you are trying to connect to your NAV server from your local network to the external address, published for the same network. You will face difficulties to access the external address from inside of the same network. But, from the other networks it works fine.

What you need to do is to connect to your server using internal IP address of your local network, not external.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Hi Alex,

Is any way I can detect if the current network setting blocks the connection from my computer. Or I have to log in the network configuration console to check. I am not a network expert but want to try to see if I can find something before we let the external network guys to get involved.

Thanks!

Dennis

Was this reply helpful? Yes No
Suggested answer

Alex A 2,801 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.

Was this reply helpful? Yes No
Community Member 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

Was this reply helpful? Yes No
Suggested answer

Alex A 2,801 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)

Was this reply helpful? Yes No
Community Member 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

Was this reply helpful? Yes No