The versions of SQL Server and SQL Server Reporting Services do not match
The information in this article applies to:
Visual Studio 2005 Team Foundation Server
Visual Studio Team System 2008 Team Foundation Server
SQL Server 2005
Dual-server deployment
Application-tier server
Data-tier server
Health check
The Best Practices Analyzer tool for Team Foundation Server checks the registry for the version of SQL Server (MSSQL.n\Setup\Version) that is installed on the data-tier server and the version of SQL Server Reporting Services that is installed on the application-tier server.
Note
This rule is checked and applies only when SQL Server 2005 is installed in a dual-server deployment.
An error appears if the version numbers for the SQL Server database engine and the SQL Server Reporting Services do not match. The most likely cause for this error is that you have installed one or more service packs for SQL Server 2005 on the data-tier server but you did not install the same set of service packs on the application-tier server.
To resolve this error, you must install Service Pack 1 for SQL Server 2005 on the server whose version number is the lower of the two as indicated in the error message. If you have installed Service Pack 2 for SQL Server 2005 on one server but not the other, you must install the service pack on the server that the error indicates.
Required Permissions
To perform this procedure, you must be a member of the Administrators security group on the server that the error indicates.
To install Service Pack 1 for SQL Server 2005 (Visual Studio 2005 Team Foundation Server)
Log on to the server whose version number is the lower of the two reported in the error message.
Click Start, point to Administrative Tools, and then click Services.
The Services manager opens.
In the results pane, right-click SQL Server Browser, and then click Stop.
On the installation media for Team Foundation Server, locate the SQLServerKB folder.
Locate the executable file (.exe) for your operating system and language (such as AS2005-KBnnnnnn-x86-ENU.exe), and then double-click the file to start the installation.
In the Hotfix Installer wizard, accept the End User License Agreement, complete the pages to install the update, and then click Finish.
Click Start, point to Administrative Tools, and then click Services.
In the Services manager, right-click SQL Server Browser, and click Properties.
On the General tab, locate Start Mode, and click Automatic.
Click Start, and then click OK.
To install Service Pack 1 for SQL Server 2005 (Visual Studio Team System 2008 Team Foundation Server)
Read the preparation steps and installation instructions for Service Pack 1 for SQL Server 2005 on the Microsoft Web site.
Download and install the service pack from the Microsoft Download Center.
Visit Windows Update, and install all critical updates and service packs.
To install Service Pack 2 for SQL Server 2005
- Follow the instructions provided at "SQL Server 2005 Service Pack 2" on the Microsoft Web site.