Database in use !

jesnetjesnet Member Posts: 3
Hope someone can help - I will try to make the problem description short.
1. have license for 2 users
2. client can open 2 copies - no problem (running tcp)
3. server can start 2 copies - no problem
4. if one copy started on client - can't start a copy on server (database in use message)
5. if one copy started on server - can't start a copy on client (database in use message)

Regards and thanks
Bent in Denmark

Comments

  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    What do you mean by 'server can start 2 copies?' Are you talking about native NAV server or about databases hosted on a SQL Server?

    Also - what do you mean by the 'copy started on client'. Is it again a NAV database service started on the client, or the database is hosted on client's local SQL Server, or you are trying to open the fdb files in the client directly?


    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • jesnetjesnet Member Posts: 3
    Hi Slawek
    The database is hosted on a sql server. The program is always started on the server, either directly or via tcp (Intranet). Hope this makes it more clear.
  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    edited 2018-03-12
    The databases (two copies) are on the SQL server. That's clear now.

    But "The program is always started on the server, either directly or via tcp (Intranet). " is not, frankly speaking..

    Anyway - since your databases are hosted on the SQL Server NAV checks licenses bases on number of sessions on the SQL Server openened form NAV clients. If you have 2 users in your license you can have 2 concurrent connections per server (or more precisley per SQL Server instance) - no matter what database clients are connected to, and where the client is running.

    Could it be that one client is connected to one database and you try to connect 2 more to another database?


    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • jesnetjesnet Member Posts: 3
    The problem is solved - turned out that the NAVserver was not running !
  • RemkoDRemkoD Member Posts: 100
    -is puzzled- That doesn't explain the 'database in use message' yet. Well, I'm glad for you it's solved! :)
  • SavatageSavatage Member Posts: 7,142
    If the Navserver was not running then the client was opening the database directly. If that's the case you can only open it once.
Sign In or Register to comment.