Team Foundation Server is not compatible with SQL Server Collation

[ Configuration Database ] TF255374: The following SQL Server instance is not compatible with Team Foundation Server: VBXW2008\SQLSVR08. The default collation is set to Latin1_General_CI_AI. Team Foundation Server requires that the default collation be case insensitive and accent sensitive. You must choose a SQL Server instance whose default collation settings match these requirements

Run the following statement to fix:
Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=SQLSVR08 /SQLSYSADMINACCOUNTS=vbxw2008\administrator /SAPWD=password /SQLCOLLATION=Latin1_General_CI_AS

Advertisements

5 Responses to Team Foundation Server is not compatible with SQL Server Collation

  1. sathsih says:

    our side not woking

  2. Ashok says:

    useful, saved our time. thanks

  3. Uninstall existing SQL server instance and run the TFS configuration wizard again, it will resolve the problem.

    TFS configuration wizard will install SQL 2008 Express the way it requires.

  4. Ayaan Kapoor says:

    Can you explain the process?

    • guozspace says:

      Option 1: Using SQL Server 2008 Express Edition
      Make sure you uninstall existing SQL instance and run TFS configuration wizard, by default SQL Server 2008 Express Edition will be installed with compatible SQL Server Collation
      Option 2: Using SQL Server 2008 / R2
      Install SQL Server as new instance with compatible SQL Server Collation
      Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=SQLSVR08 /SQLSYSADMINACCOUNTS=vbxw2008\administrator /SAPWD=password /SQLCOLLATION=Latin1_General_CI_AS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s