|
The server principal "userXYZ" is not able to access the database "DB_DNP" under the current security context. (Microsoft SQL Server, Error: 916)
The server principal "userXYZ" is not able to access the database
"DB_DNP" under the current security context. (Microsoft SQL Server,
Error: 916)
To fix this SQL Server Management Studio 2008 Bug, please follow the directions below:
-
Open SQL Server Management Studio 2008
-
Connect to the database server as normal
-
Press F7 to open the "Object Explorer Details" window
-
In the object explorer details window expand double click on "Databases"
-
Right click on the header bar ("Name", "Recovery Model", etc) and deselect "Collation"
-
From the object explorer, refresh the "Databases"
|