Is there a way to change the sorting of the main database on the MsSql 2008 server to a different sort rather than reinstalling it?
You need to rebuild / recreate the main database as described here.
(Although this article also lists the steps for changing all user databases to a new sort, you probably just need to follow these steps here )