The server principal 'MyUser' is not able to access the database 'NotMyDB' under the current security context (Microsoft SQL Server, Error:916)

Problem

You get the following error messages when you try to access your Microsoft SQL Server database with SQL Server Management Studio. The database may not be yours if you host your database in a shared server.

        The server principal MyUser is not able to access the database NotMyDB 
        under the current security context (Microsoft SQL Server, Error:916)
    

Solution

The problem is caused by the auto close status of the databases. We need to turn off the auto close of the database. Please follow these steps.

1) Get a database list

Go to SQL Server Management Studio > Management > SQL Server Logs. Open the current logs and find Starting up database '/DBName'. Enter the DBName list.

2) Turn off Auto Close for the databases

Go to SQL Server Management Studio > Databases. Right click the database name and choose Properties. Click Options in the left side and change Auto Close from  True  to False.

Add Feedback