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 utilizatori au considerat informația utilă
Răspunsul a fost util?

Articole similare

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