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.

kaci butler

How To Take Amazon Help To Avoid The Problems Of Login Credentials?

10 December 2019

Login credential of Amazon is very crucial and must be kept safe and secured all the time. If you are one of those who have problems with their Amazon account, you can use Amazon Help and take the one stop solution by just approaching the technical support professionals and engineers. 

kaci butler

Amazon Number: Seamlessly Update Delivery Information

10 December 2019

Sometimes users are unable to update their delivery information but due to some technical glitches, they have to face some sorts of trouble in doing the same. To get the optimum solution, you should use Amazon Number which would help to fetch the right troubleshooting aid from the experts. 

kaci butler

Solve Shipping Address Related Problems Using Amazon Customer Service

10 December 2019

Do you want to change shipping address of the Amazon you have previously mentioned? Are you facing some mishaps while going for the same? In order to correct guidance regarding the same, you can get Amazon Customer Service and ask for the detail information with the aid of technical professionals in no time. 

Find out more