Thursday, December 2, 2010

The server principal "xyz" is not able to access the database "CMS" under the current security context. (Microsoft SQL Server, Error: 916)


Error:- 





TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server principal "nwisuser" is not able to access the database "CMS" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

------------------------------

BUTTONS:

OK

------------------------------


 

Solution:-

  1. Display "Object Explorer Details" (F7) or "View –> Object Explorer Details




































    CLICK on Databases in left Pane.Right click the column headers and deselect "collation"








DONE .... Refresh Databases and start working

1 comment:

  1. Thanks Hemant for sharing this information with us. I have found another helpful article that describes the cause of SQL Server Error 916 and methods to fix it. Read from here: http://www.sqlserverlogexplorer.com/fix-error-code-916/

    ReplyDelete

FEEDJIT Live Traffic Map