SQL Server Collation Settings

To ensure the collation order of a new SQL server install is "Latin1_General_Ci_AS"
You must follow these steps;
1. Set your regional settings to be "English (United States)"
2. Choose custom in SQL server setup.
3. Choose "Dictionary Order, Case Insensitive for use with 1252 Character Set"