Sql-server – No Reporting Server connect option in SQL Server Management Studio 2008 Express

I just discovered it this evening, so let me share my joy: Registered Servers are still available in SQL Server Management Studio!

In the View menu, choose Registered Servers. That will open the window for them. Then, drag that window to the side to dock it.

Along the top of the window you'll see icons for the types of servers (SQL, SSAS, SSIS, SSRS). Choose the type you're registering.

Add your instances to the Local Server Groups by right-clicking and selecting New Server Registration, then complete configuration for the connection.

Once that's done, you can double-click on a server to open the Object Explorer for that server.

Most likely you need to re-register the SSRS WMI Namespace and/or the WMI Provider. You can troubleshoot and fix the problem using the following steps.

Troubleshoot the problem using the WMI Tester

1. Close all instances of Reporting Services Configuration Manager or SQL Server Management Studio.
2. Open a command prompt and type wbemtest, and then click OK.
3. Click Connect in the WBEM tester dialog box
4. In the Namespace field, type the following string, and then click Connect. root\microsoft\sqlserver\reportserver \v9
5. The namespace you specify should appear in the WMI Tester dialog box. If you see an error message instead, the WMI namespace for Reporting Services is not registered correctly. To resolve this issue, follow the procedures later in this article for registering the WMI namespace for Reporting Services.
6. Click Enum Classes, and click OK in the Superclass Info window.
7. In Top-level classes list of the Query Result window, double-click the MSReportServer_Instance class.
8. Click the Instances button. You should see a Query Result window that shows all the instances of Report Server on your computer. If not, the Reporting Services WMI provider is not communicating with Reporting Services Configuration Manager or SQL Server Management Studio. To resolve this issue, follow the procedures later in this article for registering the Reporting Services WMI provider.
9. If you successfully resolved the issues in the WMI Tester dialog box, restart Reporting Services Configuration Manager or SQL Server Management Studio to determine whether that the error is resolved.

Repairing Report Services WMI Provider

1. Close all instances of Reporting Services Configuration Manager or SQL Server Management Studio.
2. Open a command prompt.
3. Add the class instance of the Reporting Services WMI provider to the WMI repository. In the command prompt, run the following command:
   mofcomp "%ProgramFiles%\Microsoft SQL Server\90\Shared\reportingservices.mof"
4. Run the WMI Tester again to see whether you can now connect to the namespace for the Reporting Services WMI provider and continue with the debugging process.

Register the Reporting Services WMI provider

1. Close all instances of Reporting Services Configuration Manager or SQL Server Management Studio.
2. Open a command prompt.
3. Register the Reporting Services WMI provider. In the command prompt, run the following command:
   regsvr32 "C:\Program Files\Microsoft SQL Server\90\Shared\reportingserviceswmi.dll
4. Run the WMI Tester again to see whether you can now connect to the namespace for the Reporting Services WMI provider and continue with the debugging process.

Here is the source for this information, Microsoft's How-To on troubleshooting WMI Provider errors in SSRS.