SQL Server Reporting Services is installed on the data-tier server
The information in this article applies to:
Visual Studio 2005 Team Foundation Server
SQL Server 2005
Data-tier server
Health check
Preinstall check
The Best Practices Analyzer tool for Team Foundation Server checks the configuration of the SQL Server installation on the data-tier server. An error appears if SQL Server Reporting Services is installed. Reporting Services should be installed on the application-tier server instead. You must resolve this error condition before you install Team Foundation Server.
Note
This rule applies to deployments of Visual Studio 2005 Team Foundation Server only. (Visual Studio Team System 2008 Team Foundation Server supports deployment of Reporting Services on the data-tier server.)
To resolve this issue, you must uninstall Reporting Services from the data-tier server.
Required Permissions
To perform this procedure, you must be a member of the Administrators security group on the data-tier server.
To uninstall SQL Server 2005 Reporting Services
Log on to the data-tier server.
Open the Start menu, point to Control Panel, and then click Add or Remove Programs.
Click Microsoft SQL Server 2005, and then click Remove.
On the Component Selection page, under Select an instance, click MSSQLSERVER:Reporting Services, and then click Next.
On the Confirmation page, verify that Reporting Services: MSSQLSERVER appears, and then click Finish.
On the System Configuration Check page and the Setup Progress page, you can monitor progress.
On the Finish page, click Exit.
(optional) If you want to remove all the components installed that support SQL Server Reporting Services, remove each of the following programs by using Add or Remove Programs.
Microsoft SQL Server 2005 Backward compatibility
Microsoft SQL Server Native Client
Microsoft SQL Server Setup Support Files
For more information about prerequisite software and installation procedures, download the most recent version of the Team Foundation Installation Guide for Visual Studio 2005 Team Foundation Server from the Microsoft Download Center.