The collation of the site database does not match the collation of the parent site's database

I had SQL error at the Prerequisite Check page regarding the required SQL Server Collation:

"The collation of the site database does not match the collation of the parent site's database.  All sites in a hierarchy must use the same database collation.in SCCM 2012"

Configuration Manager required that you configure your SQL Server instance and Configuration Manager Site database (if already present) to use the SQL_Latin1_General_CP1_CI_AScollation,

The server collation is specified during SQL Server installation.  So this means that you need to 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.

It is highly recommend to do this only on a SQL which is not in use by any other application!

Navigate to your SQL setup folder or DVD 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

List of errors code during the client installation

2 – The system cannot find the file specified.

5 – Access denied.

52 – You were not connected because a duplicate name exists on the network. Make sure there is not a duplicate name in DNS and that 2 machines don’t have the same IP in DNS.

53 – Unable to locate, cannot connect to admin$ – Computer Browser not started 

58 – The specified server cannot perform The requested operation

64 – The specified network name is no longer available. Source: Windows

67 – network name cannot be found.

86 – network password is not correct? Machine Name <> resolved name.

112 – Not enough disk space

120– Mobile client on the target machine has the same version, and ‘forced’ flag is not turned on. Not processing this CCR ,target machine already have cm client and no force install selected(always install).

1003 – Cannot complete this function.

1053 – The service did not respond to the start or control request in a timely fashion.

1068 – The dependency service or group failed to start

1130 – Not enough server storage is available to process this command. Source: Windows

1203 – The network path was either typed incorrectly, does not exist, or the network provider is not currently available. Please try retyping the path or contact your network administrator.

1208 – An extended error has occurred. Source: Windows

1305 – The revision level is unknown.

1396 – Logon Failure: The target account name is incorrect. (NBTSTAT -a reverse lookup, duplicate IP address)

1450 – Insufficient system resources exist to complete the requested service. Source: Windows

1789 – The trust relationship between this workstation and the primary domain failed.

2147749889 – Generic WMI failure (Broken WMI)

2147749890 – not found – Source: Windows Management (WMI) – try repair WMI

2147749904 – Invalid class – Source: Windows Management (WMI)

2147749908 – Initialization failure – Source: Windows Management (WMI)

2147942405 – Access is Denied (Firewall rule? / MacAfee-HIPS?)

2147944122 – The RPC server is unavailable. 

2148007941 – Server Execution Failed