Tag: SCCM Prerequisite

SCCM – SQL Server Collation PreRequisites

Installing System Center Configuration Manger (SCCM) into my HomeLab environment to ensure that my Windows Servers are patched up to date.

During the SCCM installation, the prerequisite failed due to the wrong SQL Server Collation.

Screenshot #1 shows the failure. Because the prerequisite failed, you will noticed that the Begin Install button is greyed out.

SCCMCollation#1
Screenshot #1 – SCCM SQL Collation Issue

SQL Collation needs to be SQL_Latin1_General_CP1_CI_AS.

Mine was set to Latin1_General_CI_AS_KS as seen in Screenshot #2.

SCCMCollation#2
Screenshot #2 – SCCM SQL Collation Issue

Solution:

Change the SQL Server Collation via a rebuild.

Prerequsities:

  1. The sa account within SQL Server is enabled and password is known;
  2. Member of SysAdmins group within SQL Server.

SCCMCollation#3

Screenshot #3 – SCCM SQL Collation Issue

  1. Open Command Prompt as an Administrator;
  2. Navigate to setup.exe where your binaries are installed;
  3. Run the following command:
    .\Setup.exe /q /action=rebuilddatabase /instancename=MSSQLServer /sapwd=Password1 /SQLCollation=SQL_Latin1_General_CP1_CI_AS /SQLSYSADMINACCOUNTS=DEV\user1
  4. This will change the collation to SQL_Latin1_General_CP1_CI_AS.
SCCMCollation#4
Screenshot #4 – SCCM SQL Collation Issue