Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

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

Posted on by 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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    4BzSoftware 6,071 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    4BzSoftware 6,071 on at
    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 Profile Picture
    Alex A 2,348 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Alex A 2,348 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Alex A 2,348 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans