Share via

The version of SQL Server on the data-tier server is not compatible

  • Article

The information in this article applies to:

  • Visual Studio 2005 Team Foundation Server

  • Visual Studio Team System 2008 Team Foundation Server

  • SQL Server 2005 or Microsoft SQL Server 2008

  • Data-tier server

  • Preinstall check

The Best Practices Analyzer tool for Team Foundation Server queries Windows Installer functions (MsiGetProductInfo, MsiEnumProducts, and MsiEnumRelatedProducts) to determine the version of SQL Server that is installed on the data-tier server. 

An error appears if the installed version of SQL Server is not compatible with the version of Team Foundation Server to be deployed. Specifically, an error appears if either of the following conditions is true:

  • You run the preinstall check for Visual Studio 2005 Team Foundation Server, and the version of SQL Server is not equal to 9.00.2047, which is the most recent version of SQL Server 2005.

  • You run the preinstall check for Visual Studio Team System 2008 Team Foundation Server, and the version of SQL Server is not equal to 9.00.2047, which is the most recent version of SQL Server 2005, or 10.0.0000, which is the most recent version of SQL Server 2008.

    Note

    You can perform this check only by running the tool on the server that is hosting SQL Server. Windows Installer functions support queries of local computer information only. 

To resolve this issue, you must uninstall the version of SQL Server that is currently installed or upgrade it to SQL Server 2005. For information about how to install SQL Server, download the most recent version of the Team Foundation installation guide for your deployment, and see the appropriate topic:

  • For Visual Studio 2005 Team Foundation Server, go to the Microsoft Download Center:

    • How to: Install Microsoft SQL Server 2005 for Team Foundation Server (Single-Server Deployment)

    • How to: Install Microsoft SQL Server 2005 for Team Foundation Server (Dual-Server Deployment)

  • For Visual Studio Team System 2008 Team Foundation Server, go to the Microsoft Download Center:

    • How to: Install Microsoft SQL Server 2005 (Single-Server Deployment) on Windows Server 2003 

    • How to: Install Microsoft SQL Server 2005 (Single-Server Deployment) on Windows Server 2008

    • How to: Install Microsoft SQL Server 2005 (Dual-Server Deployment) on Windows Server 2003 

    • How to: Install Microsoft SQL Server 2005 (Dual-Server Deployment) on Windows Server 2008

    • How to: Install Microsoft SQL Server 2008 (Single-Server Deployment) on Windows Server 2003

    • How to: Install Microsoft SQL Server 2008 (Dual-Server Deployment) on Windows Server 2003

See Also

Concepts

Rule Checking Performed by the Best Practices Analyzer Tool

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database