Browsing hosted databases with SQL Server 2008 Mgmt Studio

I have a database hosted at ORCSWeb. As soon as I started using SQL Server 2008, I couldn't get at it from the Object Browser of SS Management Studio. I could access the database and work with it. I was just having a particular security problem with the Object Browser. When I tried to expand the list of the databases so that I could see mine and work with my db objects, I kept getting an error message that my login was invalid for someone else's database - even though I wasn't trying to access it.

Luckily, Desiree, a DBA at ORCSWeb, encountered and got to the bottom of this problem already.

Check out her very aptly titled blog post:

The server principal 'A' is not able to access the database 'B' under the current security context (Microsoft SQL Server, Error:916)

No comments (yet...)

Leave a Comment