Session Table only show own session

rkaufmann
rkaufmann Member Posts: 71
edited 2007-06-06 in SQL General
Hi,

we are running Nav 4.0 SP3 on SQL-Server 2005.

We have a strange behaviour here.

When reading the session table, only my own session shows up.
It doesn't matter if I have super-rights or restricted user rights.

Same if I go to "File => Database => Information".
On the Sessions-Tab the field "Current Sessions" always shows "1".
An when using the drill down on this field, I only see my onw session.

Does anybody have a solution for that?

Regards,
Rolf

p.s. I'm a "Pro" Navision Developer, but an absolute newbie to SQL-Server.

Comments

  • HalMdy
    HalMdy Member Posts: 429
    No solution ... but I have the same problem in the same conditions ...


    Any idea ?
  • kine
    kine Member Posts: 12,562
    There IS solution... the name is "traceflag 4616". If you turn it on, the problem will be solved. The latest versions of NAV fore you to enable it.

    Another solution is to assign sys admin roles to the user, but as you know, this is not good solution... :-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • rkaufmann
    rkaufmann Member Posts: 71
    Thanks,

    but what changes will happen to the SQL Server if I activate the pre 2005 behaviour?

    Is there no other way to give the users full read-rights to the session table. It would be OK to set those rights directly on the SQL-Server.

    We need this to prevent users to login to the Navision DB multiple times.

    Rolf
  • kine
    kine Member Posts: 12,562
    I found the answer from my support incident when I was solving that (in september 2006) and the solution through permissions is to grant permissions for "VIEW SERVER STATE" for the users. For more info how to grant the permissions you can find on http://msdn2.microsoft.com/en-us/library/ms186717.aspx.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kine
    kine Member Posts: 12,562
    And about the behaviour - I think that it is just part of the "minimal rights rule" - users do not need to see other sessions and system-wide things. It is why this is disabled by default. This trace flag just enable it again...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • rkaufmann
    rkaufmann Member Posts: 71
    Thanks for the quick information.

    But the link leads me to a "Content not found" site on MSDN.

    Can you send me a copy of the article somehow?
  • kine
    kine Member Posts: 12,562
    Interesting - when I google it by entering "grant VIEW SERVER STATE", it is the first URL and when I open it from google, it is working... :-)

    Or you can use the example from page http://msdn2.microsoft.com/en-us/library/ms187797.aspx
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories