SQL Server Manager Studio 2008 bug expanding database list

There is a bug within SSMS 2008 where if you connect to a db server using an account that does not have any rights to some of the database you can get an error when trying to expand the database list preventing you from accessing those databases that you do have rights to.

The error you receive looks something like this:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server principal "CMSi-NATBN-Admin" is not able to access the database "CAMS-CCW-WCP2010" under the current security context. (Microsoft SQL Server, Error: 916)

The error is caused because SSMS fails when trying to read some of the information about the databases, in oder to fix the problem you have to configure that specific SSMS installation to not read that data about that database server. You do this as follows:

  • Run SSMS and connect to required db server as sa or admin user account.
  • Press F7 to open the "Object Explorer Details" window
  • In the object explorer details window expand double click on "Databases"
  • Right click on the header bar ("Name", "Recovery Model", etc) and deselect "Collation"
  • Disconnect from the db server
  • Reconnect to db server using desired account and test

Comments

MichaelNorman

re: SQL Server Manager Studio 2008 bug expanding database list

07 November 2016

Hello,

If you want to repair SQL database so, Download SQL Database Recovery Software to do this process because it comes with plethora of options to recover data from damaged or corrupt SQL databases.

The SQL Database Recovery Software can restores & extract SQL data from corrupt SQL databases, And it can also recover corrupt NDF and MDF database files of SQL Server. This software can restore all the database components, like views, indexes, tables, stored procedures, triggers, user-specified functions, rules, and etc.

 

Click for download this software :  http://www.tools4recovery.com/sql-database-recovery.html

 

Laptop Data Recovery Dubai

re: SQL Server Manager Studio 2008 bug expanding database list

04 December 2019

Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers. For more about Data Recovery.

kaci butler

Get The Appropriate Answers To Yahoo Related Queries At Yahoo Help

05 December 2019

To get the appropriate answers directly from the world class geeks, you should know the way to approach these engineers. However, by making use of Yahoo Help facility, you can easily get in touch with them and you will surely get the realistic technical aid within limited time frame. https://www.customersupport-phonenumber.com/yahoo-customer-care-number/

Employment Services

re: SQL Server Manager Studio 2008 bug expanding database list

05 December 2019

Microsoft distributes Microsoft SQL Server 2008 fixes as one downloadable file. Because the fixes are cumulative,  And each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. In case of, anyone looking for Employment Services. Visit my profile.

saleem

re: SQL Server Manager Studio 2008 bug expanding database list

06 December 2019

these information  about SQL Database Recovery Software can restores & extract SQL data from corrupt SQL databases, And it can also recover corrupt NDF and MDF database files of SQL Server.

Find out more