Error trying to login to SQL Server Management Studio - The server principal ...

If you get the following error when trying to login to Microsoft SQL Server Management Studio then please see the fix below:

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

  • Open SQL Server Management Studio.
  • Connect to the server.
  • In Object Explorer, click Databases.
  • Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”.
  • Right click the column headers and deselect “collation”.
  • Refresh Databases.

 

  • ms sql, The server principal
  • 338 Users Found This Useful
Was this answer helpful?

Related Articles

What are the connection details for my MS SQL database?

To find the server hostname of your MS SQL database please follow the guide below: Login to...

How to change your default MS SQL language / locale.

By default all MS SQL database users you create in our control panel are set to British - English...

How to restore your MS SQL database (DACPAC or BACPAC).

If you can only retrieve a BACPAC MS SQL backup file then please open a support ticket and ask...

SQL Server Management Studio error: Saving changes is not permitted ....

If you receive the following error in SQL Server Management Studio please see the link below:...

Upgrade your database to new MS SQL Server version

If you would like to have your MS SQL database upgraded to a new MS SQL Server version please...