Share via

Required SQL Server Collation

Kaosins Demar 20 Reputation points
2023-12-13T09:10:15.7933333+00:00

I am running prerequisite check during SCCM setup process and faild the step "Required SQL Server Collation", but I have configured my SQL Server collation correctly, how to fix this issue?

Microsoft Configuration Manager
0 comments
Accepted answer
  1. Garth Jones 1,666 Reputation points MVP
    2023-12-13T12:56:16.4733333+00:00

    The Log will tell you which server and SQL instance is having problem. Make sure that the whole SQL instance is using the right collation.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenLiu-MSFT 49,306 Reputation points Microsoft External Staff
    2023-12-14T06:11:02.21+00:00

    Hi, @Kaosins Demar

    Thank you for posting in Microsoft Q&A forum.

    We have to verify that the collation settings for all databases in all instances of SQL Server used by your SCCM deployment are the same and meet the requirements for SCCM, the recommended collation setting is SQL_Latin1_General_CP1_CI_AS.

    If the collation settings are correct, try restarting the SQL Server service and then run the prerequisite check again to see if it helps.

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

    0 comments
  2. Kaosins Demar 20 Reputation points
    2023-12-14T09:07:50.8633333+00:00

    Thanks for the answers, the error disappeared after re-run the prerequisite check.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.