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/

8 comments:

  1. That made the trick!!! Thank you

    ReplyDelete
  2. Thank You Saurav! That solve my problem

    ReplyDelete
  3. Hi Saurav,
    thank you, this helped when we needed a fast solution.
    You may solve this issue more general using the traceflag 4616 when starting SQL Server.

    Compare http://www.mibuso.com/forum/viewtopic.php?t=42882

    ReplyDelete
    Replies
    1. Hi Andre,

      Thanks for the update. Your comment will help others who will be visiting this post.

      Thanks Man.

      Regards,
      Saurav

      Delete