Web Hosting Resource

When connecting to an MS Sql 2005 Server using MS SQL Server Management Studio 2008 you may come across an error “Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”. This in turn will prevent you from being able to connect to your database. This is a known issue with Microsoft and occurs when either a database is in offline mode or when SQL Server Management Studio cannot correctly read one or more databases. Therefore, certain properties of a database cannot be retrieved. However there is a work around for this if you follow the instructions below:

1. Close the error message.
2. Press F7 to open the Object Explorer Details pane.
3. Right-click the column headers, and make sure that only the following columns are selected:
   *Name
   *Date Created
   *Policy Health
   *Owner
4. Right click the Databases node, and then click Refresh.

For more information the please view the Microsoft knowledge base.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;956179

This entry was posted on Wednesday, May 20th, 2009 at 2:43 pm and is filed under Databases, MS SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.