Share via

Team Foundation Server does not support collation setting

  • 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 and SQL Server 2008

  • Data-tier server

  • Health check

  • Preinstall check

The Best Practices Analyzer tool for Team Foundation Server checks the configuration of the data-tier server. An error appears if Team Foundation Server does not support the collation settings for SQL Server.

To resolve this issue, you must uninstall and then reinstall SQL Server. You cannot change the collation setting after you have installed SQL Server. You must resolve this error condition before you install Team Foundation Server.

To work with Team Foundation Server, the collation settings for SQL Server must be case insensitive (clear the Case - sensitive check box), accent sensitive, and not binary.

If you are installing SQL Server 2005 on a computer whose Windows system locale is set to U.S. English, the default setting is an option under SQL collations. This setting meets the requirements for Team Foundation Server. However, that setting might not support all of the data that your organization must store in Team Foundation Server. In that case, you must find a setting that not only meets the requirements for Team Foundation Server but also supports your data. You might specify an option under Collation designator and sort order. For example, you can specify Latin1_General if you need support for additional characters.

For most other locales, the default setting is an option under Collation designator and sort order. Make sure the settings match the requirements for Team Foundation Server. If you must change this setting, you should specify the option that is named for your locale with "_90" after it, where possible. For example, you can use Japanese_90 collation if you use Unicode CJK Extension A characters or Unicode Surrogates in the following ways:

  • Names of objects, such as queries or projects, in Team Foundation Server.

  • Files or paths that are checked into the version control system.

  • Any field of the work items that is used for searches.

To avoid problems with double width or hiragana/katakana equivalent characters, you should select the check boxes to enable Kana and width-sensitivity when you install SQL Server.

For more information, see "Collation Settings in Setup" in the SQL Server 2005 Books Online on the Microsoft Web site.

For more information about prerequisite software and installation procedures, see the Team Foundation installation guide:

See Also

Other Resources

Issues That Relate to SQL Server and the Team Foundation Database