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

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...

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...

What tool do I use to manage SQL Server databases, and where do I get it?

The tools you need to develop MS SQL databases and to connect to our servers are available free...

How to create an MS SQL database.

You can create new blank MS SQL databases in your hosting control panel by following the...