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

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

  • digg
  • 0
     
    Share
This post will give you step by step instructions on how to fix the server principal error in Microsoft SQL Server Management Studio. The error you are getting is a bug/security issue in the latest Microsoft SQL Management program. You can find a tutorial on how to set up a database here and you can find a tutorial on how to use Microsoft SQL Server 2008 here. After logging in with the proper user name, password and database name (which you specified in the DotNetPanel), you will need to follow these instructions:
1) Click “View” and then “Object Explorer Details”. You could also hit the F7 key on your keyboard.
2) Double click on the “Databases” folder.
3) Right-click on the column header “Policy Health State”.
4) Deselect the option “Collation”.
5) Click “Refresh”.
6) Your window should now look like this.
This concludes how to fix the server principal error in Microsoft SQL Server Management Studio.
- See more at: http://blog.arvixe.com/how-to-fix-the-the-server-principal-is-not-able-to-access-the-database-error-in-microsoft-sql-server-management-studio/#sthash.83t3etYs.dpuf

Popular posts from this blog

How to Delete WHM Mail Queue through SSH sent from a particular sender

how to change witribe wlan password? how to secure your witribe router

SOLVED: WHM/CPANEL Your server does not support the connection encryption type you have specified. Try changing the encryption method