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.
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