Not very often, you will get the following error:
Error:
The server principal “” is not able to access the database “” under the current security context.
This is because the MS SQL Server is attempting to execute a SQL query to retrieve a list of databases along with some other formation about those databases. Some of that information is “Collation”, which, ofcourse you don’t have permission to view for all databases, since you’re in a shared hosting environment and you can only have access to your database..
Solution is pretty straight forward :
1. In Object Explorer, click on Databases
2. Display Object Explorer Details (F7) or View > Object Explorer Details
3. Right click the column headers and de-select “Collation”
4. Refresh Databases or reconnect to ste machine.
Thats it
Bye bye
