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:-
- 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
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