TFS installation and Error 28805
Here is a list of possible 28805 errors and fixes that worked wonders for us. This particular exception is thrown while configuring reporting services for use with Team Foundation Server. Please keep visiting this page for updates.
Exception / Log snippet |
Solution |
Error 28805.The setup program cannot complete the request to the server that is running SQL Server Reporting Services. Verify that SQL Server Reporting Services is installed and running on the Team Foundation app tier and that you have sufficient permissions to access it. For more information, see the setup log. The MSI log: 01/30/09 12:30:53 DDSet_Status: Commandline: "c:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\createds.exe" /setup /install "https://<serverName>/ReportServer/ReportService.asmx" TfsReportDS "Data source=TFS2008;initial catalog=TfsWarehouse" "TFSServer\TFSSERVICE" "01000000d08c9ddf0115d1118c7a00c04fc297eb" 0 1 01/30/09 12:30:53 DDSet_Status: IgnoreExitCode: 0 01/30/09 12:30:53 DDSet_Status: Silent: 0 01/30/09 12:30:53 DDSet_Status: ActionStart: 0 01/30/09 12:30:53 DDSet_Status: Cost: 0 01/30/09 12:30:53 DDSet_Status: WorkingDirectory: 01/30/09 12:30:53 DDSet_Status: HideCmdLine: 0 Cannot finish the request on Microsoft SQL Server Reporting Server. Please check that Microsoft SQL Server Reporting Services and Windows service are running and you have sufficient privileges on the data tier: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: This operation is not supported on a report server that is configured to run in SharePoint integrated mode. ---> Microsoft.ReportingServices.Diagnostics.Utilities. OperationNotSupportedSharePointModeException: This operation is not supported on a report server that is configured to run in SharePoint integrated mode. at Microsoft.ReportingServices.WebServer.WebServiceHelper.EnsureRSNativeMode() at Microsoft.ReportingServices.WebServer.ReportingService2005..ctor() at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object parameters) at Microsoft.TeamFoundation.Proxy.Reporting.ReportingService.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property Properties) at Microsoft.TeamFoundation.Client.Tools.createds.Program.Run(String args) Data source creation failed. |
This issue is exhibited if Reporting services is configured to run with SharePoint integrated mode. Resolution To reconfigure Reporting services to run on "native" mode: 1) Do not cancel the TFS installation, let the error prompt stay 2) Delete the Reporting services databases (Reportserver and Reportservertemp) from SQL 3) Open reporting services configuration manager and navigate to "Database" section 4) create a new set of database and select "Native" 5) Complete the Database creation wizard 6) Delete the Encryption key inside Reporting services configuration manager 7) Stop and Start Reporting services within Reporting services configuration manager 8) Click "Retry" on the TFS 2008 installation error window. |
Installing TFS with SSL enabled on Default web site. Error 28805.The setup program cannot complete the request to the server that is running SQL Server Reporting Services. Verify that SQL Server Reporting Services is installed and running on the Team Foundation app tier and that you have sufficient permissions to accept it. For more information, see the setup log. Reference: https://ozgrant.com/2007/05/13/tfs-installation-error-28805 |
There was a SSL certificate associated with the Default Web Site in IIS. This meant that SQL Reporting Services automatically configured itself to require SSL connections. When TFS Setup tries to connect to Report Server to create the data sources, it fails because it is connecting over HTTP. Solution: 1) Open rsreportserver.config from C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\ 2) Set SecureConnectionLevel = 0 3) Continue Setup as normal |
Error 28805.The setup program cannot complete the request to the server that is running SQL Server Reporting Services. Verify that SQL Server Reporting Serivces is installed and running on the Team Foundation app tier and that you have sufficient permissions to accept it. For more information, see the setup log. |
The account that is configured to run SQL reporting services will be creating the application pool in IIS. If the account does not have enough permissions to create a Application pool, the installation would fail with this error.Enable modify permissions on "<sysdrive>:\inetpub\WWWroot" folder for the account that runs the Reporing services windows services. |
Content by: Arunrama
Reviewed by: Lucky