MS SQL

Fix the server principal ( ) is not able to access the database ( ) Error In Microsoft SQL Server Management Studio

Step. 1 Connect to the remote database via Microsoft SQL Server 2008 Management Studio Express by using your user name, password and database name. Click "View" and then "Object Explorer Details". You could also hit the F7 key on your keyboard.




Step. 2 Double click on the "Databases" folder.




Step. 3 Right-click on the column header "Policy Health State".




Step. 4 Deselect the option "Collation".




Step. 5 Click "Refresh".




Step. 6 Now you can see all the databases in detail

Related articles
  1. Install Microsoft SQL Server 2008 Management Studio Express
  2. Connect MS SQL database via Microsoft SQL Server 2008 Management Studio Express
  3. FAQ on MS SQL