Only one session in session table

rofl
rofl Member Posts: 22
edited 2009-04-24 in NAV/Navision Classic Client
Hello,

[Using Nav4 SP3] a couple of days ago I faced one very confusing problem. When I try to view DB information (using system tools as well as my own session form) the only thing I always see is my own connection/session (although there are at least two active [SQL server shows all of them, but NAV (session table) - not]). I searched for similar problems in the forum, but no answers. Moreover, all permissions are granted to each user and everything is suppose to be just fine (SQL admin assured me that everything (as he thinks) must be ok), but obviously it is not. Please somebody help me to solve this "bug"... ](*,)

Thanks a lot.

Comments

  • kine
    kine Member Posts: 12,562
    1) I think it depends on exact NAV client version (build no.)
    2) Check that traceflag 4616 is set on the MS SQL (I am sure that you are using SQL 2005 or 2008)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Deep
    Deep Member Posts: 569
    You must also be a Super user of SQL database server (not only NAV) to view the sessions.
    Regards,

    Deep
    India
  • rofl
    rofl Member Posts: 22
    traceflag is ok (forgot to mention). When it comes to all permissions, it seems that everything is just fine. Got no clue what the problem is...

Categories