SQL Server 2008 Managment Studio - Cannot enlist databases in the Object Explorer
Oct 18th, 2009 by ocvirek.com
When trying to connect to SQL Server instance using SQL Server Management Studio 2008 (Express), you might stumble upon this error: Failed to retrieve data for this request. (Microsoft.sqlserver.management.sdk.sfc). Databases will not be enlisted in the Object Explorer and that’s really bad. Luckly there’s a solution for that.
- Close the error message
- Press F7 to open the Object Explorer Details pane. Right-click the column headers, and make sure that only the following columns are selected: Name, Date Created, Owner
- Right-click the Databases node, and then click Refresh. Voila!
More info: http://support.microsoft.com/default.aspx?scid=kb;EN-US;956179