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
What am I doing wrong here? Are there any other diagnostics steps to find out why this is happening?