Hi all,
I'm trying to install SQL2K8 R2. I've gone through it once, and at no point did I see (or at least don't remember seeing) where I could set the default server collation.
Any advice? I need SQL_Latin1_General_CP1_CI_AI, while the default appears to be SQL_Latin1_General_CP1_CI_AS.
I tried to rebuild the master db using the following (as outlined in one of Tibor's posts), but it failed:
setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=STRIFE /SQLSYSADMINACCOUNTS=CIPS\Programmers_Global /SAPWD=pwd /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI
Thanks,
Paul