Navision Database Server connection error

shillu

Need help!!!

I have installed navision server (native version) in one machine.Installed navision client also. I can work in that system as opening the database directly from the path and also by giving server name and password. Both are working fine.

I have installed navision client in an another machine. When i am trying to connect the server, I am getting the following error. I am assure as both systems are in network, under same domain. I have checked by using Ping also. Still I am getting the error and could not connect the server. The error is as follows.

"There was a time-out in an attempt to establish connetion with the server
(TCP/IP error ETIMEDOUT) see the network documentation for additional
information. Contact your system manager if you need assistance".

FYI - I have used net type as TCP/IP only. My Operating System is XP.

Any suggestion on this?

kriki

Maybe some firewall rule that blocks the communication on the client or the server.

gvolkov

You need to set permissions for the folder containing the database, or the database itself.

bbrown

gvolkov wrote:

You need to set permissions for the folder containing the database, or the database itself.

What permissions? The only "user" that needs permissions to the database files is the user account that is running the database service. No users should ever be granted permissions to the data files of a multi-user system

gvolkov

What permissions? The only "user" that needs permissions to the database files is the user account that is running the database service. No users should ever be granted permissions to the data files of a multi-user system

Well, then i will rephrase. Make sure the permissions are set correctly.

shillu

What permissions i need to check? I have given full control to all users (database properties->security->full control yes to all user). and who ever is accessing navision database..for them also i hv given super rights.

What else i need to check?

jordi79

did u try to access by ip and not by the server name? i have always had this problem, and accessing by ip have worked for me before. just enter the ip address in the "server name" field.

it has been a long time since i dealt with nav server. have been doing sql since a long time ago. i remember that if you really must access a nav server by server you have to change a system file in the client to map the server name to an ip. but u normally will only be required to do this if the server name of the nav server is different from the computer name. else, your network should be able to identify the server to connect to via the computer name.


i just cannot seem to recall the name of the file now....

shillu

Yes. I have even tried with IP address of my system but in vain .
you mean, changes in host file n services file?

I did that also..but its not working.

jordi79

i assume u can ping the ip right? and also, can u try to access the nav server from other clients. Also, try accessing the nav server from the server itself via a client installed on the nav server. that will help isolate the problem.

and yes, it is the host and services file.

shillu

jordi79 wrote:

i assume u can ping the ip right? and also, can u try to access the nav server from other clients. Also, try accessing the nav server from the server itself via a client installed on the nav server. that will help isolate the problem.

and yes, it is the host and services file.

I have already mentioned the same that i am able ping my ip from other machine which are connected under same network. and i also tried by entering ip address of my machine in place of server name while opening database.
adn i got the issue when i was trying to access it from other clients only. when i am accessing it from my machine..where server is installed..i am able to open without issues.

jordi79

check the filrewall installed on the nav server. disable all anti-virus and firewalls. check that the port no. that the nav server service is using is not blocked.

bbrown

shillu wrote:

What permissions i need to check? I have given full control to all users (database properties->security->full control yes to all user). and who ever is accessing navision database..for them also i hv given super rights.

What else i need to check?

My point was that you do not need (and should not) to do this. Users should have no access to these files. Anyways your issue is one of establishing a server connection. Which is well before any sort of "permisssions issue" would come into play.

gvolkov

Try this:

steps may vary based on the OS you use.
open Database Manager snap-in. Click Start>Run, type in mmc, hit OK.
click File>Add/Remove snap-in.
scroll thru the list and add the Navision Database Server.
add the server to the list by right clicking the node and selecting NEW.
provide your server parameters and you will be able to see the database server settings.
make sure the Net Type is set to TCPIP, Path to the database is correct and service is started.

let me know if this helps

shillu

Hey i got it.

I have disabled all anti-virus and firewalls in the both the server system and client as well.
Its working now.

Thanks all!!!!..

jordi79

shillu wrote:

Hey i got it.

I have disabled all anti-virus and firewalls in the both the server system and client as well.
Its working now.

Thanks all!!!!..

hi. that does not mean u should leave ur server running without firewall and antivirus. find out the port no. that is being blocked, and open that port no. i dun want ur server to be infected by viruses and malicious software on my account.

shillu

jordi79 wrote:

hi. that does not mean u should leave ur server running without firewall and antivirus. find out the port no. that is being blocked, and open that port no. i dun want ur server to be infected by viruses and malicious software on my account.

he he he...thanks a alot. will check with my admin about port no. otherwise..If u can, pls tell me how to find out the port no.

manger

What is the port number to access the classic database server (native) ?
In older documents I found that port number is 2407 für TCP Access.
Did this change with NAV 2009 SP1 or is it still the same ? I found nothing for this topic in the installation guides.