Microsoft SQL Server Management Studio shows error

Asked By 10 points N/A Posted on -
qa-featured

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)

SHARE
Answered By 0 points N/A #168938

Microsoft SQL Server Management Studio shows error

qa-featured

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.

Related Questions