If you attempt to install TFS 2008 on SQL Server 2008, TFS will report incompatible SQL Server version:
The System Health Check has detected a problem that will cause Setup to fail.
Description
A compatible version of SQL Server is not installed.
Workaround / Remedy
SQL Server installation is a prerequisite for Visual Studio Team Foundation Server 2008. Install a supported version of SQL Server and then install any required service packs. For more information about supported versions of SQL Server, download the most recent version of the Team Foundation Installation Guide, which is available from the Microsoft Web site.
More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=79226
Solution: integrate Team Foundation Server 2008 Service Pack 1
From MSDN:
You must integrate the installation of Visual Studio Team System 2008 Team Foundation Server and Service Pack 1 under the following circumstances:
- Your data-tier server is running Microsoft SQL Server 2008. In this environment, installation will fail if you try to install Team Foundation Server without SP1.
- Your application-tier server is running Windows Server 2008 and you want to automatically install and configure Windows SharePoint Services 3.0 when you install Team Foundation Server. In this environment, the option to automatically configure Windows SharePoint Services 3.0 will be unavailable if you install Team Foundation Server without SP1.
- You want to update a build server that has more than 1,000 build cases that were migrated from Visual Studio 2005 Team Foundation Server.
To resolve this issue:
You can integrate the installation files of Service Pack 1 and Visual Studio Team System 2008 Team Foundation Server. For more information, see “How to: Integrate the Installation of Team Foundation Server and Service Pack 1″ in the installation guide for Team Foundation. You can download the most recent version of this guide from the http://go.microsoft.com/fwlink/?linkid=79226.
From installation guide:
To integrate the installation of Team Foundation Server and Service Pack 1
Download SP1 from the Microsoft Web site, and save the update to a folder on the local computer.
For example, you can save the file to C:\SP1Download.
From the files that originated on the DVD for Team Foundation Server, copy the AT folder to a location on the local computer.
For example, you can copy the folder to C:\InstallMedia.
Open a Command Prompt window, and type the following command, replacing C:\SP1Download with the location that you chose in step 1 and C:\SP1Extract with a separate location on the local computer:
C:\SP1Download\TFS90SP1-KB949786-ENU /extract:C:\SP1Extract
Create a folder where you can merge files from SP1 and the DVD.
Type the following command, replacing C:\InstallMedia with the location that you chose in step 2, C:\SP1Extract with the location that you chose in step 3, and C:\MergeFolder with the absolute path of the location that you chose in step 4:
msiexec /a C:\InstallMedia\vs_setup.msi /p C:\SP1Extract\TFS90sp1-KB949786.msp TARGETDIR=C:\MergeFolder
Note:
You must replace C:\MergeFolder with an absolute path, but you can replace C:\InstallMedia and C:\SP1Extract with absolute or relative paths.
From C:\MergeFolder (which you created in step 4), run setup.exe to install Team Foundation Server with SP1.
IF SERVICE PACK INTEGRATION DOESN’T WORK
you need to hack hcpackage.xml. Just remove any issue sections that check SQL Server version. Or, you can download it here: hcpackage.xml.
Разделы: программирование, софт | Нет комментариев »