Session Table only show own session

rkaufmann

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.

HalMdy

No solution ... but I have the same problem in the same conditions ...


Any idea ?

kine

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... :-)

rkaufmann

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

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.

kine

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...

rkaufmann

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

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