Symptoms

On a computer that is running Windows Vista, you install a default instance of Microsoft SQL Server 2005 Service Pack 2 or a later version of SQL Server 2005. On the same computer, you install a named instance of Microsoft SQL Server 2008. For example, you install an instance that is named "SQL2008." In this scenario, you may receive an error message that resembles the following when you start the SQL Server 2008 Reporting Services Configuration Manager:

No report servers were found. Details: Invalid namespace

Cause

This problem occurs if the SQL Server 2008 Reporting Services Configuration Manager points to the SQL Server 2005 Reporting Services instance, and it cannot find the SQL Server 2008 instance.

Resolution

To resolve this problem, use one of the following methods.

Method 1: Install the Cumulative update package 1 for SQL Server 2008

For more information about how to install the Cumulative update package 1 for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:

956717 Cumulative update package 1 for SQL Server 2008

Method 2: Add a WMI namespace

Add a WMI namespace that corresponds to the namespace that the SQL Server 2008 Reporting Services Configuration Manager tool is trying to use. To do this, follow these steps:Note This procedure refers to a sample instance that is named "SQL2008."

  1. Locate the Reportingservices.mof file for the SQL Reporting Services 2008 instance that is named "SQL2008." By default, this file is located in the following folder:

    C:\Progam Files\Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\ReportServer\bin

  2. Save or copy the Reportingservices.mof to a file that has a unique name, such as Reportingservicesalt.mof.

  3. Open Reportingservicealt.mof file by using a text editor, such as Notepad.

  4. On the Edit menu, click Replace.

  5. In the Find what area, type the changed instance name, such as RS_SQL2008.

  6. In the Replace with area, type the unmodified instance name, such as SQL2008.

  7. Click Replace All.

  8. Save the file, and then exit Notepad.

  9. Open a command prompt, and then move to the same folder that you used in step 1.

  10. Type mofcomp reportingservicesalt.mof, and then press ENTER. Note If the reporting services instance name contains an underscore (_), a dollar sign ($) or a number sign (#), you have to use method 1. Or you have to reinstall the instance.

Status

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.