Linux & Windows Web Hosting VPS - The server principal "user-ABC" is not able to access the database "DB-ABC" under the current security context. (Microsoft SQL Server, Error: 916)

	Home \| Support \| Contact us \| +61 3 8683 9782

Support Center » Knowledgebase » The server principal "user-ABC" is not able to access the database "DB-ABC" under the current security context. (Microsoft SQL Server, Error: 916)

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

Solution

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"

Article Details

Article ID:

342

Created On:

16 Aug 2009 11:57 PM