06 September 2014

TFS not compatible with SQL collation during setup

Installing TFS in existing database and come across this issue.

The following SQL Server instance is not compatible with Team Foundation Server: TFS\tfs_db. 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 requirement

Solution is to run the following code in visual studio command prompt, the code can change the sql collation to support collation. Latin1_General_CI_AS

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=TFS /SQLSYSADMINACCOUNTS=sa /SAPWD=pass@word1 /SQLCOLLATION=Latin1_General_CI_AS