I recently had some trouble selecting the proper Collation/Sort order when setting up a new SQL 2005 installation. There was a small number of Collations/Sort Orders but not the one I needed.
The official webpage for that didn’t give much but I managed to find a command line syntax that fixed the problem, and I was able to specify Collation that wasn’t available during installation.
The syntax goes like this:
start /wait D:\SQLInstall\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=mysapassword SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
If you want to perform the rebuild without any output, run it with /qn instead of /qb