Problem: Sql Server Management Studio gives the error message "Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)"
In order to resolve this do the following:
-Click "View" -> "Object Explorer Details".
-Double click on the Databases folder.
-Right-click on the column headings area and un-check the "Collation" option.
In order for this to have an effect you must then refresh the database list by right-clicking on the "Databases" list in Object Explorer on the left and selecting refresh. You should now be able to browse the database list successfully.