question

Sacred Jewel avatar image
Sacred Jewel asked

Error while collapsing the Databases node of SQL Server 2005 in SSMS 2008

Hi, In our environment, there are both SQL Server 2005 and SQL Server 2008 instances. I am able to connect to SQL Server 2005 intance from SQL 2008 SSMS. But when I try to collapse the Databases node, it gives me the following error **The server principal "USER" is not able to access the database "AdventureWorks" under the current security context** But when I use SQL 2005 SSMS, it works properly. Please note that the user does not have the rights to connect to some databases including AdventureWorks. Any help is much appreciated.
sql-server-2008sql-server-2005ssms
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
Please try this 1.Open SQL Management Studio 2008 2.In Object Explorer, click "Databases" 3.Select View -> Object Explorer Details 4.Right click the column headers 5.Uncheck these columns if checked: - Collation - Size (MB) - Database Space Used (KB) - Index Space Used (KB) - Space Available (KB) - Default File Group - Mail Host 6.Right click on Databases and select Refresh Hope this helps.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sacred Jewel avatar image Sacred Jewel commented ·
Thanks a lot. It is working now. Just FYI, only the "collation" column has to be unchecked in my case.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.