Invalid namespace - Running SSRS against a named instance

I recently went to check the configuration of my SQL Server 2008 Reporting Services instance (which is a named instance called "SQL08") and it came up with a "connect" dialog and when I clicked on the "find" button I got an "invalid namespace" error.

I found a few threads on the MSDN forums about this and eventually a Microsoft guy came up with a solution.

The post at the end of this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3741006&SiteID=1 had the solution which worked for me, so I have copied it out below.

1. Locate the existing MOF file (example: %ProgamFiles%\Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\ReportServer\bin\reportingservices.mof would be the default location for a Reporting Services instance named SQL2008).

2. Copy this reportingservices.mof to reportingservicesalt.mof (or some other unique name).

3. Notepad reportingservicealt.mof

4. Choose edit->replace…

5. In the dialog, in the Find What: text box enter the modified instance name (for an RS instance named SQL2008, the modified instance name is RS_SQL2008), in the Replace with: text box enter the instance name unmodified (so for an RS instance named SQL2008, just enter SQL2008).

6. Press the Replace All button.

7. Save and close notepad.

8. From a command window at the same location as the results of step 1, type MOFCOMP REPORTINSERVICESALT.MOF (or whatever the name from step 2 was).

Now the configuration tool should work with the following exception, if the RS instance name contains an underscore (_), a dollar sign ($) or a hash (#), then step 8 will fail and the user will need to re-install the Reporting Services instance with a name that does not include any of these three characters.

From this it looks like may be the setup messed up somewhere. The above script appears to re-register the Reporting Services WMI namespaces. Apparently there will be a knowledge base article published on this soon.

Print | posted on Thursday, September 4, 2008 8:21 AM

Comments on this post

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
Thank you so much for this. I've been having major issues with SSRS 2008 with my named instance and could not connect to it any way except through the Web Site. I want to configure it and am looking forward to being able to configure SSRS 2008 on my box again.
Left by Peter on Sep 09, 2008 4:39 AM

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
Thanks for posting this, Darren. It was a big help.
Left by Aaron Alton on Feb 27, 2009 2:48 PM

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
The addition of the "RS_" on the instance name was a critical piece of data that Microsoft left out of the Custom Security Extension for Sql Server Reporting services. Thanks
Left by Marc on Mar 18, 2009 11:57 AM

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
Works like a champ
Left by Leonard Mwangi on Jul 08, 2009 3:58 AM

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
Big thank you! This made my day!
Left by Mårten on Aug 19, 2009 7:10 PM

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
Hi, i tried to follow the above mentioned steps. my ssrs mof includes the instance name without RS. i tried to replace the instance name with RS_instance name as well keeping only instance name. but it does not work. I'm getting same error. "invalid namespaces".
Anyhelp to overcome this error will be really appricated.

Stack Trace:
[ManagementException: Invalid namespace ]
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) +210
System.Management.ManagementScope.InitializeGuts(Object o) +530
System.Management.ManagementScope.Initialize() +213
Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationUtilities.GetReportServerUrl(String machineName, String instanceName) +505

[Exception: An error occurred while attempting to get the ReportServer Url. Invalid namespace ]
Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationUtilities.GetReportServerUrl(String machineName, String instanceName) +2198
Microsoft.Samples.ReportingServices.CustomSecurity.UILogon.authenticateAndCreateTicket(String userId, String forwardedHost) +483
Microsoft.Samples.ReportingServices.CustomSecurity.UILogon.Page_Load(Object sender, EventArgs e) +3327
System.Web.UI.Control.OnLoad(EventArgs e) +124
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2513
Left by Malik on Jul 27, 2016 6:20 AM

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
@Malik - if you don't have the RS_ prefix in the .mof file then you are hitting a different issue. This issue was specific to the installer for SQL 2008. I don't even have access to any servers running that anymore. Is upgrading to a newer version an option? I have not seen this issue in versions after SQL 2008. And I believe that 2008 is out of mainstream support so you are even going to have trouble getting help from Microsoft.
Left by Darren Gosbell on Jul 27, 2016 7:24 AM

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
@ Darren.. thanks for your reply. Actully im working on windows 2012 with sql server 2014. and im trying to deploy SSO configurations with Forms authentication method. Problem was same invalid namesspaces so i thought to ask here.

We do have primere support with MS. but MS says we dont provide support in customised envorinment. I tried to revert back my changes and start doing step by step and found invalid namespaces errors comes when i add key values which include server name and instance name in report manger webconfig file.
Left by Malik on Jul 29, 2016 5:56 AM

# re: Invalid namespace - Running SSRS against a named instance

Requesting Gravatar...
Thank you very much. It worked pretty good
Left by Hector Agudelo on Jul 13, 2017 1:16 AM

Your comment:

 (will show your gravatar)