SQL Server 2005 collation issue during installation
there is no collation "sql_latin1_general_as"
there is no collation "sql_latin1_general_ci_as"
collation chosen during install does depend on the control panel settings
The default collation for a clean install would be "SQL_Latin1_General_CP1_CI_AS" for US English:
The default for UK English is "Latin1_General_CI_AS"
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