Thursday, September 25, 2008

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)

Thursday, September 25, 2008 4:53:28 PM (Eastern Standard Time, UTC-05:00)  #     |  Comments [0]  |