大网数据广告活动
数据库与应用安全

Error when you click the Databases node

· 52CE 我爱测

This article describes an error message that typically occurs in SSMS when there is a problem retrieving information about one or more databases of a SQL Server instance.

This article describes an error message that typically occurs in SSMS when there is a problem retrieving information about one or more databases of a SQL Server instance.

Original product version:   SQL Server
Original KB number:   956179

Symptoms

You might receive an error message similar to the following one when using SQL Server Management Studio (SSMS):

Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)

Troubleshooting

There can be multiple symptoms that can contribute to this problem. The following items may help you understand and troubleshoot the issue:

  • Symptom 1

    You might run into known issues in the following articles:

    Resolution

    To solve the known issues, see the resolutions documented in the corresponding articles listed earlier.

  • Symptom 2

    You can run into this issue if using an older version of SSMS and when one of the following conditions is true:

    • SQL Server Management Studio can't correctly read one or more databases. Therefore, certain properties of a database can't be retrieved.

    • One or more databases is in an offline mode and you're using an older version of SSMS to connect to that SQL instance hosting this offline database.

    In these situations, the collection of objects doesn't appear in the Object Explorer pane or the Object Explorer Details pane. Therefore, certain properties of the database aren't computed as a group in the collection of objects.

    [!NOTE] This problem also occurs if you're not a member of the Sysadmins group.

    Resolution

    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 select Refresh.

    Alternatively, you can download and install SSMS from Download SQL Server Management Studio (SSMS) and see if the issue goes away. If the issue still occurs with the new version of SSMS, see SQL Server help and feedback for additional ways to get assistance with your issue.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 03/21/2025
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。