Yet again i have failed a prerequisite check for the required SQL server collation, though i would post the quick fix for me to remember what i did but might help someone else.
Quick back story, i’m installing Microsoft System Centre Configuration Manager 2012, already installed all the prerequisites…
The server collation gets specified at the SQL Server installation. Few options to fix, re-install the SQL server or rebuild your database. The server collation acts as the default collation for all system databases that are installed with the instance of SQL Server, and also any newly created user databases.
Only do this on a SQL which is not in use by any other application!
Assuming you have default instance name, otherwise just change the /INSTANCENAME=
Open up command prompt, navigate to the SQL setup folder where the setup.exe is located and execute the underneath command:
Setup.exe /QUIET /ACTION=REBUILDDATABASE /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=BUILTIN\Administrators