"The server principal 'A' is not able to access the database 'B' under the current security context" when connecting with Microsoft SQL Server Management Studio Issue:
When connecting to your database with Microsoft SQL Server Management Studio, you receive the error in the subject. 

 

Cause
This problem is caused by a bug in Microsoft SQL Server Management Studio where every time you connect to a server it attempts to connect to the first Database on the server.  If you do not have permission to access this database the above error is thrown and Microsoft SQL Server Management Studio refuses to display the list of databases on the server.


Resolution

  1. Log in with Microsoft SQL Server Management Studio and click OK when the error appears.
  2. Press F7 to open Object Explorer Details.
  3. Right click on the column header at the top of the new window and uncheck Collation
  4. In the left column, right-click Databases and click Refresh
  5. Find your database and click the + sign to expand it.

 

?האם התשובה שקיבלתם הייתה מועילה 78 משתמשים שמצאו מאמר זה מועיל (79 הצבעות)

המאמרים הנפוצים ביותר

Managing MySQL Databases With PHPMyAdmin

Let's learn how to Manage MySQL Databases with phpMyAdmin. This tutorial will assume that you...
? MySQL איך ליצור מסד נתונים

מדריך זה מסביר כיצד ליצור מסד נתונים MySQL. מסד נתונים MySQL מאפשר לך לאחסן המון מידע...
Importing databases and tables with phpMyAdmin

This tutorial is to teach you how to import databases and tables with phpMyAdmin. We will assume...
Inserting fields into database tables with phpMyAdmin

This tutorial is going to teach about the program phpMyAdmin, and how to Insert fields into...
Deleting tables in a database with phpMyAdmin

This tutorial is to teach you about specific operations in phpMyAdmin. We are going to learn how...