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"
  • 10 Users Found This Useful
Was this answer helpful?

Related Articles

Connection Strings (MSSQL 2005, MSSQL 2008, MySQL5, MS Access Database)

MSSQL2005Set conn = Server.CreateObject("ADODB.Connection")conn.Open "Provider=SQLOLEDB; Data...

How do I use an Access database on my site?

Microsoft Access is part of the Microsoft Office suite of applications and is a database that is...

Import Export MySQL database using PhpMyAdmin

Do the following steps for import/export mysql database: Open phpMyAdmin.by going to...

What is MySQL?

MySQL is an open source database server, much like Microsoft SQL Server or Oracle. You can store...

What connection parameters do I use to connect to my database

Connection information : You can connect to your database either via a dns name ie...