I am trying to access my hosting server’s database through SQL Server Management Studio, everything till login is fine but when I use the command
use myDatabase it gives me this error:
The server principal "****" is not able to access the database "****" under the current security context.
I searched over and the hosting service providers has listed this fix for the problem.
But this is not working for me probably because it's for SQL Server Management Studio 2008 however I am using SQL Server Management Studio 2012.
Can this be a problem? And if yes than can anyone tell me its alternative in SSMS 2012?
Check to see if your user is mapped to the DB you are trying to log into.