Install Service Manager and Orchestrator on same SQL Instance

Limiw 81 Reputation points
2022-06-09T09:31:33.21+00:00

In the past I installed SCSM 2016 and SCOR 2016 databases on the same SQL instance with collation Latin1_General_100_CI_AS. For future installations I have 2 questions:

1) Wich collation is recommended for scsm 2019? The ms docs gives a hint for not using the default one "...A warning message appears if you are using the default collation (SQL_Latin1_General_CP1_CI_AS). Support for multiple languages in Service Manager is not possible when you are using the default collation...".

2) Installation guids for SCOR 2019 also related to SQL_Latin1_General_CP1_CI_AS. Do I have to install SCOR in a different SQL instance with a different collation?

thx in advanced :)

System Center Orchestrator
System Center Orchestrator
A family of System Center products that provide an automation platform for orchestrating and integrating both Microsoft and non-Microsoft IT tools.
215 questions
Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
210 questions
Accepted answer
  1. Andreas Baumgarten 97,401 Reputation points MVP
    2022-06-18T06:36:11.867+00:00

    Hi @Limiw ,

    I am aware of the difference of SCOR (SCORCH) and SCOM ;-)

    If you don't use SCOM at the moment and no plans for using SCOM in the future together with SCOM there is no reason to think that much about the SQL server collation in my opinion.

    You can bypass this warning message and continue to install using the SQL_Latin1_General_CP1_CI_AS. Further, the SQL_Latin1_General_CP1_CI_AS collation was not listed as a supported collation on the Language Support for System Center 2012 - Service Manager page on the TechNet Library. The required collation for SCSM per the documentation currently is Latin1_General_100_CI_AS (note the 100).

    Source: https://techcommunity.microsoft.com/t5/system-center-blog/clarification-on-sql-server-collation-requirements-for-system/ba-p/346198#

    The information for SCOR and SQL collation you will find here:

    Orchestrator supports SQL_Latin1_General_CP1_CI_AS for collation. The installation wizard uses SQL_Latin1_General_CP1_CI_AS as the default collation to create the orchestration database.

    Source: https://learn.microsoft.com/en-us/system-center/orchestrator/system-requirements-orch?view=sc-orch-2016#software

    For SCSM the SQL collation SQL_Latin1_General_CP1_CI_AS is supported as well.
    Source: https://learn.microsoft.com/en-us/system-center/scsm/sm-languages?view=sc-sm-2016

    I am aware of some System Center environments running different SC components in the same SQL instance with the same SQL collation without any problem.

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards
    Andreas Baumgarten

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Baumgarten 97,401 Reputation points MVP
    2022-06-10T22:50:11.453+00:00

    Hi @Limiw ,

    here you can find some details related to the SQL collation and SCSM: https://techcommunity.microsoft.com/t5/system-center-blog/clarification-on-sql-server-collation-requirements-for-system/ba-p/346198

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards
    Andreas Baumgarten