A bug in SQL Server Management Studio

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

I rarely use SQL Server 2008 at ordinary times, and occasionally use it once. I have encountered some problems. After several twists and turns, I found a solution on the official website:

Problem description: After logging on to the database, click "Database". The server subject "xxxcom" cannot access the database "db_xxx_com" in the current security context ".

Cause: SQL Server 2008 bug

Solution (non-original, refer to the official website ):

1. log on to the server using SQL Server Management studio.
2. In the object Resource Manager, click the database folder.
3. Right-click the column title in "Object Resource Manager Details" and click "Reset View ". If the "Object Resource Manager Details" page is not visible, click "Object Resource Manager Details" on the "View" menu ".
4. In object Resource Manager, right-click the database folder and click Refresh ".
5. Click the database folder.
6. Right-click the column title of "Object explorer details" and click to clear the "sorting rules" check box.
7. In object Resource Manager, right-click the database folder and click Refresh ".

In this case, OK.

I have passed the test.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.