Dear All,
I am currently facing a problem to set navision database server that can be accessed by client in other computer.
I am using navision 4. sp2. I have many users about 5-8 persons.
I have set up but not work.
Any help or answer are really appreciated. tku
Rgds,
Andreas
Hi Andreas,
I assume the service is installed and configured properly so you maybe forgot the hosts and services files. Please check both files on the server and on all clients (the services file is just necessary if you don’t use DNS). Here you can find the files:
If there is a problem with the service itself, please describe it more precisely.
Best Regards
feri
Andreas,
Did you use the install wizard of use the command line to install it?
Can you access the database from the physical server you installed on?
Does the server show in the Services option from Control Panel, Administrative tools?
Tony
Dear Tony,
I have used the install wizard, but I am not still able to access the database using client application from other computer. When I install Navision database server, I use server name IBM then the database name is database.fdb.
I don’t do anything else especially about how to publish the datbase server to the network, because I can’t understand a lot the manual explanation.
I also can’t see the server showing in the services option.
Could you tell me how to publish the database server in the network or how to make the database can be accessed by client…tku.
Rgds,
Andreas
Dear Feri,
Tks for your ans. If I have done what you said, should the database information connection tab option will be checked as server and server name is filled IBM if when I install navision database server at the first with installshieldwizard…? I can’t still access the datbase from client’s computer until now
Rgds,
Andreas
Hi Andreas,
please make sure to refresh the services window and then look for “Microsoft Business Solutions-Navision Database Server IBM”. Is it still not there?
If you have found and started it, please try to access the database from a client that is installed on the same server, as Tony mentioned. Just try to connect from another computer, if that’s working.
Best Regards
feri
Dear Feri,
Tku for your reply. I would like to ask you about how to remove “Microsoft Business Solutions-Navision Database Server IBM” in the service (local) then after I have created navision database server…?
I also have problem, when I reinstall navision database server, after uninstall it, I can make server name as same as beforehand, for example, before uninstall the server name is SERVER1, uninstall, then I install again the navision database server with the same name, but the pop up message said the server name is already exists, meanwhile I have deleted the database and uninstall the server. For example, I skip the problem and set the server name to be SERVER2, and then I go on installation and complete. I set the host to be x.x.x.x SERVER2, x.x.x.x SERVER1. when I run cmd, enter server.exe, the cmd windows show that starting database server : SERVER1, the database detected is old database, that it means although I have delete it, the system in command (cmd windows) still use it. How can I replace SERVER1 to be SERVER2…? That makes me really don’t understand is that although I have uninstall navision database server, the server name : SERVER1, still exists in services (local) of administrative tools from control panel. I use windows XP. All servers relate to IP/TCP, I have deleted from services and host of D:\WINDOWS\system32\drivers\etc.
Anyhelp from you are really awaited. tku
Rgds,
Andreas
And very important:
When connecting to the server from a client, Nettype must be TCP (standard it is TCPS, but it doesn’t work).
Hi,
I never used that install wizard, so I can’t help you there. Maybe you want to try to install / remove Navision services with the console anyway, so I enclose you 2 examples. Please rename the txt files to .bat in order to run them, but first adapt the paths and names.
Best Regards
feri
servon.bat.txt (363 Bytes)
I was not able to post the 2nd. attachment in the first message, so I enclose it here.
Best Regards
feri
servoff.bat.txt (374 Bytes)
Check also this for installing servers (or also for installing 1 server):
http://www.mibuso.com/forum/viewtopic.php?t=7479
Dear kriki,
tku for the link, actually I have created navision database server and client can access it, however if I unplug network cable the client can’t access the server, of course, isn’t it. If I open database server with name SERVER1, without connected network cable to server computer, it works if I select [client only] in the server name when open database, but it will not if I select database, but indeed i still have run server.exe in the command windows (run cmd), I don’t know if now my database server name can be changed or not and if yes, how to change it to be new name, I have uninstall and reinstall with different name and it works but the SERVER1 name still exists when I run server.exe in the command button. if you have any answers let me know. tku
Rgds,
Andreas
Dear Feri,
Tku for your answer. I will try to use it, then I’ll write if there arestill any problem
Rgds,
Andreas
To be honest, I haven’t understood all what you have written.
Lets do this step by step.
-remove the service from the services. So the server is like it was before installing the Navision DB-server
-put the necessary lines in the hosts and the services files (IMPORTANT : your server should have a fixed TCP/IP address and not take one from a DHCP-server).
-install the DB-service with the installer or by a batch-file and run the service
-install a client on the server and try to connect to the DB by using the service. If this doesn’t work, something is already wrong.
-go to another PC and fix the services and hosts files.
-try to connect from the client-PC to the server by using the service.
a fast way to do it, without changing the hosts/services files:in the servername on the client to connect to the DB, put the TCP/IP address and port (if not the default-port).
e.g. 10.1.1.30
or 10.1.1.30:3000
AND : ALWAYS USE NETTYPE=TCP!!! Never use TCPS that is the default but it doesn’t work.
Andreas
In command prompt, and where the Navision Database server is try - (I can’t remember off the top of my head if it is Servicename or servername try both_
server servicename=Server1, uninstallasservice
server servicename=newservicename, installasservice
That should change the name for you.
Then follow as Kriki has suggested.
Tony
Dear Feri,
tku for the attachment. [:D], it relaly works good…stress is relieved now…
ha…ha…ha…ha…, I am very stressful beforehand but now, everything is ok…
Rgds,
Andreas
Dear Tony,
tku for your reply and asnwer. yours and feri are worked good. this topic is closed now.
Rgds,