/* ------------------------ My Meta Content Here SEO ------------------------ */

Pages

Main Menu




Thursday, January 19, 2012

SQL SERVER: The server principal is not able to access the database

SQL Databases not showing up . . .

If you accessing MSSQL 2005 with MSSQL 2008 management studio, you might getting error of The server principal is not able to access the database when log into the database server.

 

To fix it,
1. Connect to SQL Server Management Studio.
2. Connect to the SQL server.
3. Click “View” and then select on the “Object Explorer Details”. (This step could be done from shortcut F7)
4. Double click on the “Databases” folder.
5. Right click on the column header “Policy Health State”.
6. Untick the option “Collation”.
7. Refresh it and you have done.

No comments:

Post a Comment

Recent Posts

My Blog List