“Invalid namespace” error connecting to SQL reporting Services

  • Article

While installing Team Foundation Server you might see the following error:

The Commandline '"C:\Program Files\Microsoft Visual Studio 2008 Team Foundation
Server\Tools\TFRSConfig.exe" /setup /install /s "servername" /u "NT
Authority\NetworkService" /buildInIdentity /l "1041" /verify
/ignoreExistingIISArtifacts /instancename "MSSQLSERVER" /appPoolName "ReportServer"
/reportServerUri "https://<servername>/ReportServer" /reportManagerUri
"https://<servername>/Reports" /h "servername"' returned non-zero value:
-2147220956.

Applies To: TFS 2005, TFS 2008

MSI log:

TFRSConfig - Team Foundation Server Reporting Services Configuration Tool
Copyright (c) Microsoft Corporation. All rights reserved.

Connecting to SQL Server Reporting Services. Please wait...
Invalid namespace
Querying the following Windows Management Instrumentation (WMI) path: IIS://<MACHINENAME>/W3SVC.
Inspecting the following Web site: ID=1 Comment=Default Web Site.
The Web site with ID=1 contains the following binding: IP Address= TCP Port=80 Host header value=.
No host header was set, but a potential Web site match was found: 1.
Inspecting the following Web site: ID=2 Comment=Administration Web Site.
The Web site with ID=2 contains the following binding: IP Address= TCP Port=5870 Host header value=.
The binding for the following Web site does not match the expected port: IP Address= TCP Port=5870 Host header value=. The port value for the site does not match the given parameter.
Skipping scan of non-Web-site child: AppPools.
Skipping scan of non-Web-site child: Filters.
Skipping scan of non-Web-site child: Info.
Web site id 1 is chosen since it had a matching binding with no host header set
Found web site identifier to use: 1
Deleting virtual directory Reports_<INSTANCE> for Report Manager...
Deleting virtual directory ReportServer_<INSTANCE> for Report Server...
Deleting application pool ReportServer$<INSTANCE>...

Creating application pool ReportServer$DEVSQLTFS...
Error: OsNotSupported.
Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesWmiException: Exception of type 'Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesWmiException' was thrown.
at Microsoft.TeamFoundation.Admin.ReportingServices.WMIManagementObjectWrapper.PostProcessResult(ManagementBaseObject resultObject)
at Microsoft.TeamFoundation.Admin.ReportingServices.WMIManagementObjectWrapper.InvokeWmiMethod(String methodName, Dictionary`2 parameters, String resultKey)
at Microsoft.TeamFoundation.Admin.ReportingServices.ReportManagerAdmin.CreateApplicationPool(String applicationPool, Boolean useBuiltin, String account, String password)
at Microsoft.TeamFoundation.Admin.ReportingServices.ReportServerWmi.CreateManagerApplicationPool(String appPoolName, Boolean useBuiltInAccount, String identity, String password)
at Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesConfigurator.ConfigureWebServiceArtifacts()
at Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesConfigurator.Run()
at Microsoft.TeamFoundation.Admin.ReportingServices.Program.Main(String args)

Configuring SQL Server Reporting Services failed.
08/20/08 15:10:41 DDSet_Status: Process returned -2147220956

Resolution:

Disable IIS 5.0 Isolation mode.

To disable IIS 5.0 Isolation Mode

1. Click Start, click Control Panel, click Administrative Tools, and then click Internet Information Services (IIS) Manager.

2. Right-click the Web Sites folder and then click Properties.

3. On the Service tab. Clear Run WWW service in IIS 5.0 isolation mode.

4. Click OK.

Content by: Vimal

Reviewed by: Lucky