sql-serversql-server-2008sccmwindows-server-2016

SCCM Required SQL Server Collation already set


I have two questions.

  1. I am installing SCCM 2016 on a Windows Server 2016, but I am stuck at the prerequisite screen. It keeps asking me to change the Required SQL Server Collation to SQL_Latin1_General_CP1_AS. But when I look on the SQL Server it is already on that collation.

  2. My SCCM Server reports the above problem. Why isn't my SQL Server reporting that problem?

Thanks in advance for helping me!


Screenshot with the error: Screenshot with the error

Current SQL-collation Current SQL-collation


Solution

  • As SqlACID mentioned, you need to reinstall SQL with "SQL_Latin1_General_CP1_CI_AS"enter image description here

    SQL Server security mode

    On the SQL Server, Right click SQL instance go to properties and then Security. Make sure you have selected Windows Authentication Mode only, and run check to verify warning is gone.

    enter image description here

    Configuration for SQL Server memory usage

    On properties of SQL server, under Memory set minimum and maximum memory to 8192.

    enter image description here

    SQL Server process memory allocation

    Configuration Manager requires SQL Server to reserve a minimum of 8 gigabytes (GB) of memory for the central administration site and primary site and a minimum of 4 gigabytes (GB) for the secondary site. This memory is reserved by using the Minimum server memory setting under Server Memory Options and is configured by using SQL Server Management Studio. For more information about how to set a fixed amount of memory, see Here.