Unable to see the total sessions in SQL

amankakar

hi,
One of our clients is not able to see total sessions in the database information window. It always shows as 1.

they are on sql server 2005

kine

Than you need to set correct permissions on the SQL... already discussed.... ;-)

amankakar

Thanks but user already has the following

Server Roles Securityadmin + Public
User Mapping (NavisionDB) DB_Owner + Public

rhpnt

I don't think that the Securityadmin role is enough for viewing sessions. Try Processadmin.

kriki

Search the forum for this problem.
BTW Processadmin is NOT needed!

rmpatel22

"sysadmin" role is required. You can check following posts for more information.

http://www.mibuso.com/forum/viewtopic.php?f=23&t=41508

http://www.mibuso.com/forum/viewtopic.php?f=23&t=33811

kine

rmpatel22 wrote:

"sysadmin" role is required. You can check following posts for more information.

http://www.mibuso.com/forum/viewtopic.php?f=23&t=41508

http://www.mibuso.com/forum/viewtopic.php?f=23&t=33811

That's not true! It is NOT REQUIRED!

rmpatel22

Dear Kamil,

Than you need to set correct permissions on the SQL... already discussed....

I found following topic in forum. You are referring to this topic?
http://www.mibuso.com/forum/viewtopic.php?f=33&t=27367

In the navision role "All Users" you have to add tabledata 2000000009 session with read permission and after that synchronize all users.

We solved it with workarround SQL cmd: GRANT VIEW SERVER STATE TO PUBLIC enabling server wide permission just to view system tables without constraint on currently logged user