Database in use !

jesnetjesnet Posts: 3Member
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 Posts: 1,390Member
    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
    Poszukuje programistow znajacych Microsoft Dynamics NAV
  • jesnetjesnet Posts: 3Member
    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 Posts: 1,390Member
    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
    Poszukuje programistow znajacych Microsoft Dynamics NAV
  • jesnetjesnet Posts: 3Member
    The problem is solved - turned out that the NAVserver was not running !
  • RemkoDRemkoD Posts: 55Member
    -is puzzled- That doesn't explain the 'database in use message' yet. Well, I'm glad for you it's solved! :)
  • SavatageSavatage Posts: 7,140Member
    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.