Sql-server – SQL Server 2005 collation issue during installation

collationinstallationsql-server-2005

Every time I try to install SQL Server 2005 on to a Windows 7 machine it installs properly but the collation installed is sql_latin1_general_as instead of sql_latin1_general_cp1_ci_as. I have read somewhere that this might be due to the fact that the regional setting for that machine is set to English - United Kingdom, so I double checked it to make sure that regional settings is set to English - United States. Still, after the installation I checked the server properties from Management Studio and saw the collation installed is sql_latin1_general_ci_as instead of sql_latin1_general_cp1_ci_as.

What am I doing wrong here? Are there any other diagnostics steps to find out why this is happening?

Best Answer

  1. there is no collation "sql_latin1_general_as"
  2. there is no collation "sql_latin1_general_ci_as"
  3. collation chosen during install does depend on the control panel settings
  4. The default collation for a clean install would be "SQL_Latin1_General_CP1_CI_AS" for US English:
  5. The default for UK English is "Latin1_General_CI_AS"
  6. SQL collations are legacy and should only be chosen for in-situ upgrades (IIRC)

Basically, choose "Latin1_General_CI_AS" (you have a choice) and make sure you read correctly before posting

Related Question