Users unable to login on some computers

fufikk
fufikk Member Posts: 104
edited 2010-09-23 in SQL General
Hi,

our customer has nav 4 with 4 sp3 client and SQL 2005 database. Recently one of the new computers arrived with win7. Sp3 client with rollup were installed. When navision@win7 was trying to connect to SQL an error message about setting trace flag T4616 appeared. Trace flag was set and nav@win7 worked fine. However, some other users (winXP) started to complain that they cannot login to Navision, for example: user can't login with his user/password from his computer but can login from another computer with his user/password or user can't login from any computer. Either way an error message said, that there weren't enough sessions left in license (even though there were).

Any ideas what's happening?

regards,

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    A NAV-license permits only a certain NAV-client connections to the DB at the same time and if it superates, it gives that error.

    In SQL2005 something changed and that traceflag was necessary to be able to test the number of sessions.

    In NAV 4.0SP3 there was a bug that didn't test if the traceflag was set, and thus that the client could test the no. of sessions. So it let everyone even if you had 100 users at the same time and your license only permitted 10.

    In short: you need to buy more users in your license to not have the error. Or avoid that users open too many sessions.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • fufikk
    fufikk Member Posts: 104
    Thanks for your answer,

    I'm aware of this "feature" of earlier versions of navision 4. The problem is that, there were enough sessions left for users to login but still useres were rejected. I watched no. of nav sessions in SQL MGMS and there were not more than license permitted. To temporarily solve the problem users who couldn't login with thier own credentials used userid/password of users who could - no. of sessions was still within license.

    I'm wondering if the older nav4sp3 client (without requirement for 4616 flag) works ok with the flag set...
  • rhpnt
    rhpnt Member Posts: 688
    fufikk wrote:
    Hi,

    our customer has nav 4 with 4 sp3 client and SQL 2005 database. Recently one of the new computers arrived with win7. Sp3 client with rollup were installed. When navision@win7 was trying to connect to SQL an error message about setting trace flag T4616 appeared. Trace flag was set and nav@win7 worked fine. However, some other users (winXP) started to complain that they cannot login to Navision, for example: user can't login with his user/password from his computer but can login from another computer with his user/password or user can't login from any computer. Either way an error message said, that there weren't enough sessions left in license (even though there were).

    Any ideas what's happening?

    regards,

    If you are using DB Authentication check the logins at SQL Server level and synchronize all logins in NAV otherwise it's a domain account problem.
  • fufikk
    fufikk Member Posts: 104
    It's DB auth. - I'll do that and get back to you.

Categories