Microsoft SQL Server Management Studio shows error

Asked By John C Woodruff 10 points N/A Posted on - 09/15/2013

Hello,

I got this error message using SQL Server Management Studio and connecting to SQL Server. You can get the full error image detail below. Please guide me properly resolving the problem. Any help would be greatly appreciated. Thanks in advance.

Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer. management.Sdk.Sfc)

Additional Information:

An exception occurred while executing a Transact-SQL statement Or batch.

(Microsoftft.SqlServer.ConnectionInfo)

The server principal “sqldbpool” is not able to access the database “db1” under the current security context. (Microsoft SQL Server, Error:916)

• Status: Open
• Question Views: 772
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Merry Hock 0 points N/A #168938

Microsoft SQL Server Management Studio shows error

Hi John,

Try the below workaround to resolve your problem.

1. Go to SQL Server Management Studio > Object Explorer Details > Object Explorer Details in menu (or hitting F7) >'Databases' node, then right-click on the column header and uncheck 'Collation.' Then proceed to Refresh the server in Object Explorer and enumerate databases
2. Go to SQL Server Management Studio > Object Explorer Details > Databases folder. In Explorer Details window right-click column header and select ‘Reset view’. Refresh the Databases folder.
3. Check the database options for the “Auto Close” setting. verify that it is set to “False” and test again.

About Merry Hock

Questions
0

Answers
99

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 11/12/2013
• Question Category: MS SQL Server