Error message when you try to run a query in SQL Server 2008 or in SQL Server 2008 R2: "Msg 916, Level 14, State 1, Line 1"

Article translations Article translations
Article ID: 955826 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

In Microsoft SQL Server 2008 or in SQL Server 2008 R2, you may receive the following error message:
Msg 916, Level 14, State 1, Line 1
The server principal "dm_db_script_level_Perms_LOGIN" is not able to access the database "model" under the current security context.
This problem occurs when you try to run the following query to view the records in the sys.dm_db_script_level view:
SELECT * FROM sys.dm_db_script_level

CAUSE

This problem occurs when you have the View Server State permission. This permission does not enable you to view the records in the sys.dm_db_script_level view.

WORKAROUND

To work around this problem, run the query by using the System Administrator permission.

Properties

Article ID: 955826 - Last Review: March 19, 2009 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Workgroup
Keywords: 
sql2008relnotedatabaseengine sql2008relnote kbtshoot kberrmsg kbprb KB955826

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com