Object browser in SSMS 2008 doesn't work if I don't have access to all databases.

views:

208

answers:

+3 Q:

Object browser in SSMS 2008 doesn't work if I don't have access to all databases.

In SQL Server Management Studio 2008, if I log into a shared hosting provider with many databases on one server, I cannot use the Object Explorer. This worked fine in 2005. Anyway to change this behavior?

It throws this exception:

The server principal "myusername" is not able to access the database "first-database-alphabetically-on-shared-server" under the current security context.

+5 A:

click View, Object Explorer Details. Then, open Databases. Finally, click the header columns and uncheck Collation.

Source: http://sqlblog.com/blogs/aaron_bertrand/archive/2008/07/07/a-little-management-studio-oops.aspx

I solved this for my own machine a while ago and had to look the issue back up. Hopefully this link and the links from there will help you find the answer if this doesn't. It seems familiar to what i had to do.

Jeff Martin 2009-01-12 23:25:06

awesome ill try this tomorrow

Shawn Simon 2009-01-13 04:37:03

I ran into this as well - THANK YOU - I never would have dug that deep to figure it out on my own! +10000

Sam Schutte 2009-01-30 01:36:27

This solves the initial problem however have you tried right clicking the database -> tasks -> script database fails with the same error trying to script a database you have access to.

PeteT 2009-02-15 23:06:09

perhaps you should ask another question regarding that issue @petebob796

Jeff Martin 2009-02-17 16:05:57

ansaurus

tags:

views:

answers:

Object browser in SSMS 2008 doesn't work if I don't have access to all databases.

related questions