Options

Database Server sometimes connects to wrong database

afarrafarr Member Posts: 287
We have a client with two databases, Live and Test. These are .fdb files, not SQL.
The objects are version 4.00 W1, but the client used in NAV 2009 R2 (build 32012).
There is a database server for each database, ABC-LIVE (which is working fine) and ABC-TEST.

When I login by Remote Desktop to ABC-Server, the machine that hosts the services and database files, I can open ABC-TEST without problem.
For what it’s worth, ABC-Server is Win 2008 R2, 64-bit with 24 GB RAM.
The folder containing the Test database is shared with everyone, and users have full control on that folder.

However, when connecting from a PC, after opening ABC-TEST, we are actually connected to the Live database. This happens on two different PCs.
If we go to File – Database – Information, we can see the server name ABC-TEST, but the name of the database file is that of Live. The companies listed, and the data, are that of Live, so we are actually connecting to Live.

The hosts and services files have the same settings as on ABC-Server.
I also renamed the zup file (on ABC-Server and on the PC), and re-installed the service, but the problem still occurred on the PC, while on ABC-Server we connect without problem.

Have you ever encountered this?
Any suggestions are welcome.
Alastair Farrugia

Answers

  • Options
    bbrownbbrown Member Posts: 3,268
    I don't see it as causing your issue, but you should not share the folder containing the database files. The users don't need any rights to those files. Only the account runnign the services does. As a general practice a DB server (native or SQL) should be effectively "locked down". Meaning that no non-admin users have direct access.

    In terms of your problem, I've not seen this behavior. So not really sure.
    There are no bugs - only undocumented features.
  • Options
    afarrafarr Member Posts: 287
    We found a solution for this, by connecting with the explicit IP and port number e.g. 111.111.111.111:2409 instead of ABC-TEST as the server name
    Alastair Farrugia
Sign In or Register to comment.