Pages

Wednesday, May 2, 2012

VIEW SERVER STATE permission on SQL Server?

Hi all,

Sometime While trying to Login into a database we face an error message as shown below.

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server.

Contact your system administrator.

---------------------------
OK   
---------------------------



Cause of Error -

This error normally occurs due to issues that occur while creating Login ID in SQL Server.

Resoultion -

1) Open SQL Server Managment Studio.
2) Click on New Query.
3) Copy & Paste Query given Below.
4) Replace USERID with the User ID for which the error is coming.
5) Select the Whole Query.
6) Press F5.

QUERY -

USE [master]
GO
GRANT VIEW SERVER STATE TO [USERID]
GO

Now try to Login, the issue is resolved.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/