All the above suggestions are assuming you've already installed SQL Server with the wrong collation.

If you haven't installed it yet, you can change the collation during the install process (assuming you're not using unattended install packages). It actually comes up with a box during install that asks you for all sorts of details, including collation, but you have to watch carefully and not inadvertantly click past it before you've had a chance to change the collation.