SQL Server

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 thoughts on “Team Foundation Server is not compatible with SQL Server Collation

    1. 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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s