Database/Information-Current Sessions field is wrong for
DBOs

When logged into Navision (client 4.0sp3)(sql2005) with an account with SQL 
DBO permissions, the current sessions field under database/information only 
shows the current session and not all sessions.
Note: none DBO accounts AND the SA account show the correct value.

Any ideas as to how to confirm the sessions via Navision when logged in with 
dbo permissions or is this a known bug?
TIA
Neil.

"Neil" wrote:

> When logged into Navision (client 4.0sp3)(sql2005) with an account with SQL

> DBO permissions, the current sessions field under database/information only

> shows the current session and not all sessions.
> Note: none DBO accounts AND the SA account show the correct value.
> 
> Any ideas as to how to confirm the sessions via Navision when logged in
with 
> dbo permissions or is this a known bug?

This is a known bug which can be solved in 2 ways:

A.             Run the following query in SQL Query analyzer for that user 
who has this issue
                GRANT VIEW SERVER STATE TO login_name

B.            Using SQL management studio
1.             Start SQL Server Management Studio.             
2.             Expand Databases, right-click the Microsoft Navision 
database, and then click Properties.            
3.             Click Permissions, and then click “View server permissions” 
(link provided there in top  area).     
4.             In the Logins or Roles list, click the user to whom you want 
to grant the permission.         
5.             In the Explicit permissions for user list, click to select 
the Grant check box next to View server state permission.     
6.             Repeat step 4 through step 5 for each user to whom you want 
to grant the permission.    

Regards,
Luc Van Dyck
webmaster http://mibuso.com
"Your favourite knowledge base"

Hi Luc,

Thanks for this, much appreciated, it's resolved an annoying bug for us.

Neil.

"Luc Van Dyck" wrote:

> "Neil" wrote:
> 
> > When logged into Navision (client 4.0sp3)(sql2005) with an account
with SQL 
> > DBO permissions, the current sessions field under database/information
only 
> > shows the current session and not all sessions.
> > Note: none DBO accounts AND the SA account show the correct value.
> > 
> > Any ideas as to how to confirm the sessions via Navision when logged
in with 
> > dbo permissions or is this a known bug?
> 
> This is a known bug which can be solved in 2 ways:
> 
> A.             Run the following query in SQL Query analyzer for that user

> who has this issue
>                 GRANT VIEW SERVER STATE TO login_name
> 
> B.            Using SQL management studio
> 1.             Start SQL Server Management Studio.             
> 2.             Expand Databases, right-click the Microsoft Navision 
> database, and then click Properties.            
> 3.             Click Permissions, and then click “View server
permissions” 
> (link provided there in top  area).     
> 4.             In the Logins or Roles list, click the user to whom you want

> to grant the permission.         
> 5.             In the Explicit permissions for user list, click to select 
> the Grant check box next to View server state permission.     
> 6.             Repeat step 4 through step 5 for each user to whom you want

> to grant the permission.    
> 
> Regards,
> Luc Van Dyck
> webmaster http://mibuso.com
> "Your favourite knowledge base"