MS SQL Server Management Studio 2008 connecting to 2005 hosted SQL

If you are using SSMS 2008 to connectr to a 2005 database you may get the error “Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”.   SQL 2008 has features that 2005 doesn’t have.  Some of those features are displayed as columns in the database browser. This will cause the error to occur.   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

Advertisements