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.
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.