Error message when you click the Databases node in SQL Server Management Studio in SQL Server 2008: "Failed to retrieve data for this request"


Symptoms


In Microsoft SQL Server 2008, you receive the following error message when you click the Databases node in SQL Server Management Studio:
Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)

Cause


This problem occurs when one of the following conditions is true:
  • One or more databases are in an "offline" mode.
  • SQL Server Management Studio cannot correctly read one or more databases. Therefore, certain properties of a database cannot be retrieved.
In these situations, the collection of objects does not appear in the Object Explorer pane or in the Object Explorer Details pane. Therefore, certain properties of the database are not computed as a group in the collection of objects.

Note This problem also occurs if you are not a member of the Sysadmins group.

Workaround


To work around this problem, follow these steps:
  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.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.