Issue

While installing Team Foundation Server 2008 SP1 it fails with following error

Configuring Report Manager virtual directory Reports to use application pool ReportServer...

Error: IllformedAccountString.

Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesWmiException: Exception of type 'Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesWmiException' was thrown.

Also when we tried to configure “Web Service Identity” thru SQL Reporting Service Configuration Manager manually, we got following error

______________________________________________________________________________________________

ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

______________________________________________________________________________________________

Environment

Team Foundation Server 2008 (RTM) With SQL 2005

Applies only to SQL Reporting Service 2005, we should not see similar issue with SQL Reporting Service 2008

Cause

From MSI  Log

DDSet_Status: Commandline: "c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\TFRSConfig.exe" /setup /repair /s "TFS2008" /u "NT Authority\NetworkService" /buildInIdentity /l "1033" /verify /ignoreExistingIISArtifacts /instancename "MSSQLSERVER" /appPoolName "ReportServer" /reportServerUri "http://<Servername>:80/ReportServer" /reportManagerUri "http://< Servername>:80/Reports" /h "<Servername>"

03/16/09 12:11:21 DDSet_Status: IgnoreExitCode: 0

03/16/09 12:11:21 DDSet_Status: Silent: 0

03/16/09 12:11:21 DDSet_Status: ActionStart: 0

03/16/09 12:11:21 DDSet_Status: Cost: 0

03/16/09 12:11:21 DDSet_Status: WorkingDirectory:

03/16/09 12:11:21 DDSet_Status: HideCmdLine: 0

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://<Servername>/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=152936315 Comment=SharePoint Central Administration v3.

The Web site with ID=152936315 contains the following binding: IP Address=  TCP Port=17012 Host header value=.

The binding for the following Web site does not match the expected port: IP Address=  TCP Port=17012 Host header value=. The port value for the site does not match the given parameter.

Inspecting the following Web site: ID=1849097886 Comment=Team Foundation Server.

The Web site with ID=1849097886 contains the following binding: IP Address=  TCP Port=8080 Host header value=.

The binding for the following Web site does not match the expected port: IP Address=  TCP Port=8080 Host header value=. The port value for the site does not match the given parameter.

Inspecting the following Web site: ID=1849097887 Comment=Team System Web Access.

The Web site with ID=1849097887 contains the following binding: IP Address=  TCP Port=8090 Host header value=.

The binding for the following Web site does not match the expected port: IP Address=  TCP Port=8090 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 for Report Manager...

Deleting virtual directory ReportServer for Report Server...

Deleting application pool ReportServer...

Creating application pool ReportServer...

Creating virtual directory Reports for Report Manager...

Configuring Report Manager virtual directory Reports to use application pool ReportServer...

Error: IllformedAccountString.

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.SetReportManagerIdentity(String applicationPool)

   at Microsoft.TeamFoundation.Admin.ReportingServices.ReportServerWmi.SetReportManagerIdentity(String appPoolName)

   at Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesConfigurator.ConfigureWebServiceArtifacts()

   at Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesConfigurator.Run()

   at Microsoft.TeamFoundation.Admin.ReportingServices.Program.Main(String args)

__________________________________________________________________________________________

The Reports & ReportServer web applications are hosted under the default web site.

The application pool for the defuult web site had an identity account which was not in [domain\computer]\UserName format.

The problem is when RS Configuration Manger or TFRSConfig.exe is used to configure the web apps & app pool for report, the sequence goes like this:

1. Create the ReportServer Web application.

2. Create the Reports Web applications.

3. These web applications default to the application pool for the physical site which will host the web apps, in this case the web site is default web site & its application pool is Default AppPool (In my case it was SharePoint - 80).

4. We now create a new app pool called ReportServer with desired [domain]\user account.

5. Next, RS Config manager/TFRSConfig.exe throw an expection when it tries to bind the ReportServer web app to the ReportServer application pool. It gives you an exception stating that the user name format should be in domain\user format.

In this case the DefaultAppPool was set to a user called "Administrator" (no computer name prefixed).

RS Configurations manager & TFRSConfig.exe does not seem to like the fact that the current app pool user account does not have the right user format.

Resolution

To resolve this problem:

1. Either change the user name for DefaultAppPool to [computer]\[username] format.

2. Or change the app pool for the default web site to one that has the user account in the right format. However this is a more expensive change.

 

Content by: Romitg

Reviewed by: lucky