SSMS 2008 stops showing 2005 dbs
I started getting this error out of the blue when trying to access a hosted 2005 db through SSMS 2008.
The server principal “db1” is not able to access the database “db2” under the current security context. (Microsoft SQL Server, Error: 916)
No databases would display under the databases tab and every refresh would result in the same error. I could see the dbs in SSMS 2005.
The fix is pretty weird. Click on the Databases folder, then View / Object Explorer Details. Then right click in the column headings and un-select Collation. Refresh the folder and the dbs should be there.
Trackback URI |