Fast2Host Logo

Databases

The server principal is not able to access the database under the current security context

The server principal 'xxx' is not able to access the database 'yyy' under the current security context (Microsoft SQL Server, Error:916)

The issue:

This issue occurs with SQL Server 2008 Management Studio. Can connect to database engine but cannot expand the "Databases" node. It would result in the error above. The issue is with SQL Server Management Studio itself, not the database engine or any other aspect of SQL Server.

There are several work-a-rounds to correct this issue.

Work around #1:

1. Within SQL Server Management Studio, view Object Explorer Details window by selecting View, Object Explorer Details in menu (or hitting F7)
2. Right-click on the column header 'Collation.', and deselect it.
3. Refresh the server in Object Explorer and enumerate the databases

Work around #2:

1. Within SQL Server Management Studio, view Object Explorer Details window by selecting View, Object Explorer Details in menu (or hitting F7)
2. In Object Explorer window click at Databases folder
3. In Object Explorer Details window right-click at the column header and select "Reset view".
4. Refresh Databases folder

Work around #3:

1. Check the database options for the "Auto Close"



Maintain peace of mind with 24/7 UK based support

Email any time or call 01480 26 00 00 014 80 26 00 00