System requirements for System Center Service Manager

This article details the system requirements for System Center 2022 - Service Manager (SM).

Note

Unlike the earlier releases, for SM 2022, you don't need to manually install Report Viewer tools /Microsoft CLR Types for SQL Server 2014 as a prerequisite.

System requirements for System Center 2022 - Service Manager

The following sections describe the general performance and scalability guidance for SM 2022, and recommend the hardware configurations for various workloads. Because System Center 2022 is built to be flexible and scalable, the hardware requirements for specific scenarios may differ from the guidelines that are presented here.

Capacity limits for Service Manager

Read Configurations for deployment scenarios to learn about the tested capacity limits of Service Manager.

Supported coexistence

To help simplify upgrades, you can use Service Manager 2022 connectors with the following System Center components.

  • System Center 2019/2022 Virtual Machine manager
  • System Center 2019/2022 Orchestrator
  • System Center 2019/2022 Operations Manager
  • System Center 2019/2022 Configuration Manager (only during migration scenario)
  • System Center Configuration Manager CB releases
    • 1511, 1602, 1606, 1710, 1802, 1806 to 2103, 2107

Hardware

Servers Processor (min) Processor (rec) RAM (min) RAM (rec) Hard drive space (min) Hard drive space (rec)
Service Manager Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 8 GB 10 GB 10 GB
Service Manager Database 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 80 GB 80 GB
Service Manager Data Warehouse Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 16 GB 10 GB 10 GB
Service Manager Data Warehouse Databases 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 400 GB 400 GB
Service Manager Console 2-Core 2 GHz CPU 2-Core 2 GHz CPU 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (standalone) 4-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Secondary Management Server (Recommended) 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 16 GB 32 GB 80 GB 80 GB

Software requirements

Component Requirement
Service Manager management server The management server needs: ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Native client

The management server must be installed on a 64-bit edition of Windows.
Data warehouse management server The warehouse management server requires: SQL Server Native client

The data warehouse management server must be installed on a 64-bit edition of Windows.
Service Manager/data warehouse databases The Service Manager or data warehouse databases require: SQL Server Reporting Services (SSRS); SQL Server Analysis Management Objects.

The SQL Server and Analysis Services collation settings must be the same for the computers hosting the Service Manager database, data warehouse database, analysis services database, and Reporting Services database.
Service Manager console The console requires: Microsoft Excel in order to view OLAP data cubes on the console computer; ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Analysis Management Objects.

The console can be installed on 64-bit edition of Windows.
Self-Service portal The Self-Service Portal server requires: Windows 2016 server or later; the IIS role and ASP.NET 4.5 enabled; SQL Server Analysis Management Objects.

Join the server machine to the same domain where the Service Manager SDK Service is running. Ideally, on the primary or secondary server.
Machines using self-service The Self Service portal needs a screen resolution above 1024 X 768.

Supported browsers: Microsoft Edge; Microsoft Internet Explorer 10 and 11; Mozilla Firefox 42 and later; Google Chrome 46 and later.
SQL Server Reporting Services In a deployment topology where the computer hosting SSRS isn't on the same computer that hosts the data warehouse management server, you've to add Microsoft.EnterpriseManagement.Reporting.Code to the global assembly cache. Learn about the manual steps.

Additional notes

  • Operations Manager - Service Manager has the capability to import alerts and configuration items from an Operations Manager environment. Read about installing both Service Manager and Operations Manager in the same environment. You can create a data mart for Operations Manager.

  • Configuration Manager - Service Manager can import configuration items from a Configuration Manager environment.

  • Network requirements - To view external content from within knowledge articles, computers that host the Service Manager console must have Internet access, either directly or through a proxy server.

  • SMTP server- You must have access to a Simple Mail Transfer Protocol (SMTP) server to use the Notification feature and for incident creation through email.

  • Windows safe mode- Service Manager doesn't operate and the services used by Service Manager don't start if Windows Server is running in safe mode. If you attempt to start the Service Manager services manually while in safe mode, the services fail to start and an error is written into the event log.

SQL Server requirements

Microsoft SQL Server hosts the databases that System Center - Service Manager creates. In addition, System Center 2022 - Service Manager requires SQL Server Analysis Services (SSAS) to work with Microsoft Online Analytical Processing (OLAP) cubes. SQL Server Reporting Services (SSRS) is required to support System Center 2022 - Service Manager reporting.

Use this information to evaluate if your SQL Server environment is ready to support the installation of or upgrade to System Center 2022. Use this information whether you're deploying one or multiple components of System Center.

Note

During installation, select SQL Server full-text search on the computers running SQL Server that will host the Service Manager and data warehouse databases.

SQL Server version support

Note

  • SM doesn’t support SSAS mode Tabular. Select the SSAS mode as Multi-dimensional during the installation of SQL Server.
  • For the supported versions of SQL, use the service packs that are currently in support by Microsoft.
  • Service Manager 2022 supports SQL 2019 with CU8 or later; however, it doesn't support SQL 2019 RTM.
  • With SQL 2019 (CU8 or later), use ODBC 17.3 to 17.10.4.1, and MSOLEDBSQL 18.2 to 18.6.6.
Service Manager SQL Server 2017 SQL Server 2019 with Cumulative Update 8
Service Manager/Data Warehouse database

Note

System Center 2022 - Service Manager doesn't support the MultiSubnetFailover parameter. This parameter isn't used in System Center 2022 - Service Manager connection strings.

Allow updates

To either install or upgrade to System Center 2022 - Service Manager, computers running SQL Server that host databases must be configured to allow updates. If updates aren't allowed, System Center 2022 - Service Manager Setup won't complete and the following error message appears at the Create database stage of the installation:

An error occurred while executing a customer action: _ExecuteSqlScripts. This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the corrections are made, you can retry the upgrade for this role.

You can check the status of allow updates on SQL Server by executing the following stored procedure from within SQL Server Management Studio:

sp_configure 'allow updates'

In the results table, examine the value for run_value. If the value of run value is 1, set it back to 0 with the following stored procedure, and then run Setup again.

sp_configure 'allow updates',0 reconfigure with override

AlwaysOn Availability Groups considerations for Service Manager databases

SQL Server AlwaysOn Availability Groups functionality is supported by System Center 2022 - Service Manager.

For more information about installing Service Manager with AlwaysOn availability groups, refer here.

Upgrade to SQL 2017

The following steps provide information about upgrading to SQL 2017.

Note

Upgrade process to SQL 2017 uninstalls the reporting services; ensure to migrate required reports such as backup reporting DB and encryption keys.

Use the following steps to upgrade from SQL 2016 to 2017:

  1. Upgrade to SQL 2017.
  2. Install SQL 2017 reporting services (SSRS), launch the reporting services configuration manager to use the existing reporting DB, and restore encryption keys. Configure the Web service URL and Web portal URL.
  3. Use the same values for reporting server Web service virtual directory and Web portal URL that you had before initiating the upgrade process for SQL 2017.
  4. Configure the SSRS as per the details shared here.
  5. [Optional] To enable CLR strict security, run the following script on each of the Service Manager databases. By default, CLR strict security is disabled after you upgrade to SQL 2017.

Upgrade to SQL 2019

The following steps provide information about upgrading to SQL 2019.

Note

  • You must use Cumulative Update 8 (CU8) or later with SQL 2019.
  • Use ODBC 17.3 to 17.10.4.1, and MSOLEDBSQL 18.2 to 18.6.6.
  • Upgrade process to SQL 2019 uninstalls the reporting services; ensure to migrate required reports such as backup reporting DB and encryption keys.

Use the following steps to upgrade from SQL 2017 to 2019:

  1. Upgrade to SQL 2019.
  2. Install SQL 2019 reporting services (SSRS), launch the reporting services configuration manager to use the existing reporting DB, and restore encryption keys. Configure the Web service URL and Web portal URL.
  3. Use the same values for reporting server Web service virtual directory and Web portal URL that you had before initiating the upgrade process for SQL 2019.
  4. Configure the SSRS as per the details shared here.
  5. [Optional] To enable CLR strict security, run the following script on each of the Service Manager databases. By default, CLR strict security is disabled after you upgrade to SQL 2019.

Enable CLR strict security

Optional. Use the following script to enable CLR strict security.

-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash1 BINARY(64), @ClrName1 NVARCHAR(4000);
set @Hash1 = HASHBYTES(N'SHA2_512', 0x4d5a90000300000004000000ffff0000b800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000e1fba0e00b409cd21b8014ccd21546869732070726f6772616d2063616e6e6f742062652072756e20696e20444f53206d6f64652e0d0d0a2400000000000000504500004c010300cdef7c440000000000000000e0000e210b010800000c000000080000000000005e2b000000200000004000000000ec560020000000020000040000000000000004000000000000000080000000020000f2f10000030000040000100000100000000010000010000000000000100000000000000000000000042b000057000000004000001005000000000000000000000000000000000000006000000c0000008c2a00001c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002e74657874000000640b000000200000000c000000020000000000000000000000000000200000602e72737263000000100500000040000000060000000e0000000000000000000000000000400000402e72656c6f6300000c0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000402b0000000000004800000002000500082100008409000009000000000000000000000000000000502000008000000000000000000000000000000000000000000000000000000000000000000000000c506f2ef337d14f0bc66e27fa02006623253f6655697a25078f76132dfd4cf9ec02d54581a9310a12538c2a82f19f230bbe2ac6017a095a82147a15f65488b5b38c9612cfc2c228f748d5519b4981a836189698e99b7f54961091fbb404afb93ab9d8110f22652ab16e7ff50f9dfb4236d78f61e93555018ba85d95c28cb5452a02281000000a0000002a00133003001e00000001000011000214fe0116fe010b072d0500160a2b0b02031e281200000a0a2b00062a000042534a4201000100000000000c00000076322e302e35303732370000000005006c0000001c020000237e0000880200003c03000023537472696e677300000000c40500000800000023555300cc050000100000002347554944000000dc050000a803000023426c6f620000000000000002000001471502000900000000fa0133001600000100000014000000020000000200000002000000120000000e00000001000000010000000300000000000a00010000000000060084007d000600c900aa000600d700aa000600fd00eb0006001601eb0006003101eb0006005001eb0006006d01eb0006008401eb0006009f01eb000600b801eb000600d101eb000600ee01eb0006001a0207023b002e02000006005d023d0206007d023d020a00df02c4020e00210302030e00270302030000000001000000000001000100010110002b004600050001000100d0200000000081188b000a000100dc2000000000960091000e00010000000100f40200000200fa0211008b00140019008b00190021008b00140029008b00140031008b00140039008b00140041008b00140049008b00140051008b00140059008b00140061008b00140069008b00140071008b001e0081008b00240089008b000a0009008b000a0091008b000a009900340336022e003b00ac022e000b0043022e0013006d022e0023006d022e002b006d022e00330073022e0053004a032e004300e4022e004b0025032e006b0075032e007b0087032e005b0065032e0073007e0340008b00cb003e020480000006000000f50f00000100000029009b02000002000000000000000000000001007400000000000200000000000000000000000100b8020000000002000000000000000000000001007d00000000000000003c4d6f64756c653e004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e646c6c00526567756c617245787072657373696f6e4576616c7561746f72004d6963726f736f66742e456e74657270726973654d616e6167656d656e742e446174614163636573732e53716c006d73636f726c69620053797374656d004f626a656374002e63746f72004d617463686573526567756c617245787072657373696f6e0053797374656d2e52756e74696d652e496e7465726f705365727669636573004775696441747472696275746500436f6d56697369626c654174747269627574650053797374656d2e5265666c656374696f6e00417373656d626c7943756c7475726541747472696275746500417373656d626c7954726164656d61726b41747472696275746500417373656d626c79436f6e66696775726174696f6e41747472696275746500417373656d626c794465736372697074696f6e41747472696275746500417373656d626c795469746c6541747472696275746500417373656d626c79436f7079726967687441747472696275746500417373656d626c7950726f6475637441747472696275746500417373656d626c79436f6d70616e7941747472696275746500417373656d626c7946696c6556657273696f6e41747472696275746500417373656d626c7956657273696f6e4174747269627574650053797374656d2e446961676e6f73746963730044656275676761626c6541747472696275746500446562756767696e674d6f6465730053797374656d2e52756e74696d652e436f6d70696c6572536572766963657300436f6d70696c6174696f6e52656c61786174696f6e734174747269627574650052756e74696d65436f6d7061746962696c697479417474726962757465004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c0053797374656d2e44617461004d6963726f736f66742e53716c5365727665722e5365727665720053716c46756e6374696f6e41747472696275746500696e707574007061747465726e0053797374656d2e546578742e526567756c617245787072657373696f6e730052656765780052656765784f7074696f6e730049734d61746368000003200000000000a79e22af2016204a81c804d4f9bce8010008b77a5c561934e08903200001050002020e0e042001010e042001010205200101113d042001010880a000240000048000009400000006020000002400005253413100040000010001004ddb14fd25fa54ef1fe05516d69c0bb19c86956e2d5245e728300417e6a018daac56b61ee215e4c096dba942368bb4aa76956042bb3efb709cda847d7396839f57a40b90829fe5f347a5d2e2c198367cbc1092aa9762ae9776e59fed16703887329ffeb6d6cbf44853c496a22bc79bb3ce00f29760995dafa6aa97779983e0b48169010005005455794d6963726f736f66742e53716c5365727665722e5365727665722e446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038390a446174614163636573730000000054020f497344657465726d696e69737469630154020949735072656369736501540e044e616d651b666e5f4d617463686573526567756c617245787072657373696f6e54557f4d6963726f736f66742e53716c5365727665722e5365727665722e53797374656d446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038391053797374656d4461746141636365737300000000070003020e0e115104070202022901002433333532323533352d393332652d346130342d623965302d30616330383630353137663300000501000000003801003353716c436c722066756e6374696f6e616c697479207573656420627920746865206461746120616363657373206c617965722e0000370100324d6963726f736f66742e456e74657270726973654d616e6167656d656e742e53716c2e446174614163636573734c6179657200004001003b436f707972696768742032303035204d6963726f736f667420436f72706f726174696f6e2e2020416c6c207269676874732072657365727665642e00002401001f4d6963726f736f6674204f7065726174696f6e73204d616e6167657220763300001a0100154d6963726f736f667420436f72706f726174696f6e00000f01000a362e302e343038352e3000000801000701000000000801000800000000001e01000100540216577261704e6f6e457863657074696f6e5468726f777301000000000000cdef7c44000000000200000059000000a82a0000a80c000052534453165649e3ed4a514990cc3fb2ca36648a01000000643a5c6d6f6d76332e6d61696e5c7461726765745c64656275675c693338365c4d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e706462000000002c2b000000000000000000004e2b0000002000000000000000000000000000000000000000000000402b00000000000000000000000000000000000000005f436f72446c6c4d61696e006d73636f7265652e646c6c0000000000ff250020ec5600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000b80400000000000000000000b80434000000560053005f00560045005200530049004f004e005f0049004e0046004f0000000000bd04effe00000100000006000000f50f000006000000f50f3f000000000000000400000002000000000000000000000000000000440000000100560061007200460069006c00650049006e0066006f00000000002400040000005400720061006e0073006c006100740069006f006e00000000000000b00418040000010053007400720069006e006700460069006c00650049006e0066006f000000f4030000010030003000300030003000340062003000000080003400010043006f006d006d0065006e00740073000000530071006c0043006c0072002000660075006e006300740069006f006e0061006c0069007400790020007500730065006400200062007900200074006800650020006400610074006100200061006300630065007300730020006c0061007900650072002e0000004c001600010043006f006d00700061006e0079004e0061006d006500000000004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e000000900033000100460069006c0065004400650073006300720069007000740069006f006e00000000004d006900630072006f0073006f00660074002e0045006e00740065007200700072006900730065004d0061006e006100670065006d0065006e0074002e00530071006c002e0044006100740061004100630063006500730073004c0061007900650072000000000038000b000100460069006c006500560065007200730069006f006e000000000036002e0030002e0034003000380035002e0030000000000064002100010049006e007400650072006e0061006c004e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c00000000009c003c0001004c006500670061006c0043006f007000790072006900670068007400000043006f0070007900720069006700680074002000320030003000350020004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e002e002000200041006c006c0020007200690067006800740073002000720065007300650072007600650064002e0000006c00210001004f0072006900670069006e0061006c00460069006c0065006e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c0000000000600020000100500072006f0064007500630074004e0061006d006500000000004d006900630072006f0073006f006600740020004f007000650072006100740069006f006e00730020004d0061006e00610067006500720020007600330000003c000b000100500072006f006400750063007400560065007200730069006f006e00000036002e0030002e0034003000380035002e0030000000000040000b00010041007300730065006d0062006c0079002000560065007200730069006f006e00000036002e0030002e0034003000380035002e00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000c000000603b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set        @ClrName1 = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.DataAccessLayer');        

-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName1)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash1
END        

--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash1, @ClrName1        
END
GO

-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash BINARY(64), @ClrName NVARCHAR(4000);
set  @Hash = HASHBYTES(N'SHA2_512', 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006182CF4B0000000000000000E00002210B010800001600000008000000000000BE3400000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000006834000053000000004000006004000000000000000000000000000000000000006000000C000000B83300001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000C4140000002000000016000000020000000000000000000000000000200000602E7273726300000060040000004000000006000000180000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001E00000000000000000000000000004000004200000000000000000000000000000000A0340000000000004800000002000500DC250000DC0D00000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000360002731000000A7D010000042A0000133002002D00000001000011000F01281100000A16FE010A062D03002B1A027B010000040F01281200000A6F1300000A1F2C6F1400000A262A5200027B01000004037B010000046F1500000A262A0000133004004C00000002000011007E1600000A0A027B010000042C13027B010000046F1700000A16FE0216FE012B01170C082D1A027B0100000416027B010000046F1700000A17596F1800000A0A06731900000A0B2B00072A133003002900000001000011000314FE0116FE010A062D0B7201000070731A00000A7A02036F1B00000A731C00000A7D010000042A000000133002002A00000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03027B010000046F1D00000A6F1E00000A002A1E02281F00000A2A5602281F00000A000002732100000A7D02000004002A133002002F000000010000110228080000060000032C0E036F2200000A16FE0216FE012B01170A062D0F00027B02000004036F2300000A0000002A001B3003007600000003000011007E1600000A0A00027B020000046F2400000A0D2B1C1203282500000A0B00067209000070076F1D00000A282600000A0A001203282700000A130411042DD7DE0F1203FE160300001B6F2800000A00DC0006282900000A16FE01130411042D09007E1600000A0C2B0B0006176F2A00000A0C2B00082A000001100000020014002D41000F0000000013300200140000000100001100027B020000046F2B00000A16FE010A2B00062A133001000B000000040000110073080000060A2B00062A00133004008100000005000011000F00281200000A0A0F00281100000A2D10066F2C00000A282900000A16FE012B0116130411042D08280C0000060D2B4E06178D2100000113051105161F2C9D1105176F2D00000A0B160C2B1600070807089A6F2C00000A6F2E00000AA2000817580C08078E69FE04130411042DDE07280100002B000773090000060D2B00092A00000013300100110000000600001100027B020000046F2B00000A0A2B00062A0000001B300300560000000700001100160A00027B020000046F2400000A0D2B1F1203282500000A0B0007031B283100000A0A0616FE01130411042D022B0E001203282700000A130411042DD4DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010003040000F000000001B300200520000000700001100170A00037B020000046F2400000A0D2B1B1203282500000A0B000207280F0000060A06130411042D022B0E001203282700000A130411042DD8DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010002C3C000F0000000013300200170000000800001100020328130000060A066F0B00000616FE010B2B00072A001B300200670000000900001100027B0200000473090000060A00037B020000046F2400000A0D2B261203282500000A0B0006076F0F000006130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCDDE0F1203FE160300001B6F2800000A00DC00060C2B00082A000110000002001A003751000F000000001B30020064000000090000110073080000060A00037B020000046F2400000A0D2B291203282500000A0B0002076F0F00000616FE01130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCADE0F1203FE160300001B6F2800000A00DC00060C2B00082A01100000020014003A4E000F0000000013300400410000000A000011000314FE0116FE010C082D0B7201000070731A00000A7A036F1B00000A0A06178D210000010D09161F2C9D09176F2D00000A0B027B02000004076F2300000A002A000000133002002500000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03026F1D00000A6F1E00000A002A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000014050000237E000080050000A805000023537472696E677300000000280B00001000000023555300380B0000100000002347554944000000480B00009402000023426C6F6200000000000000020000015717A2090908000000FA01330016000001000000250000000300000002000000150000000F0000000300000032000000110000000A0000000100000002000000020000000300000001000000020000000100000000000A0001000000000006009C0095000A00CA00AF000A00F000DB0006000601FA000A002C01DB0006005B01510106006D0151010600A10186010600B001860106006902570206008002570206009D0257020600BC0257020600D50257020600EE02570206000903570206002403570206005C033D0306007003570206009C0389035300B00300000600DF03BF030600FF03BF0306001D0495000A003304AF000A005404AF0006006C0495000600840495000A00A504AF000600CB0486012300E204000006001705950006004805950006004D05950006006E0595000A007905AF0006008C059500000000000100000000000100010001201000450051000500010001000120100088005100050002000800010014010A000100A8012F00502000000000860027010E00010060200000000086003601120001009920000000008600410118000200B02000000000860047011E000300082100000000E601680123000300402100000000E6017A0129000400762100000000861880010E0005007E2100000000861880010E0005009421000000008618800136000500D02100000000C600BE013F000600642200000000E609C701430006008422000000009608D201470006009C22000000009600DB014C0006002C23000000008600E101530007004C23000000008600E70157000700C023000000008600EB015C0008003024000000008600F4015C0009005424000000009600FD0162000A00D824000000009600030262000C00582500000000E601680123000E00A82500000000E6017A0129000F00000001001902000001001F02000001002502000001002702000001002902000001003102000001003302000001003B02000001004202000001004A02000002005002000001004A020000020050020000010025020000010027020200090003000D0003000900510080017400590080017400610080017400690080017400710080017400790080017400810080017400890080017400910080017900990080017400A10080017E00B10080018400B90080010E00C10080010E00C90080018900210080010E002900C701430029005B043F0021006504F10021006504F700210065040101D900730407012100790453002100BE010A01290080017400E1008001740031009A043F002100800174000900BE013F0039007A017400090080010E00E900800189000C0080010E001400C10453000C00D9044F010C00ED0459011C00FB046801D90007056D011C000E054300010123050E00D9002B057401D900390579010C00C1045300D90043053F00D90060058F01D90066053F00190174059901210180010E00D9009D05DA010C00A405F5012E001B002B022E006B0073022E000B0012022E0013002B022E00230031022E002B0012022E00330040022E003B002B022E004B002B022E005B0061022E0063006A0243007B008F00630003011701C0018301B101E0018301B10100028301B10120028301B101FD0010017E018A01A501D601E301EF01FB0109020300010000000D026B00000014026F0002000B00030002000C0005004301490162010480000001000000B30EF0680000000000005100000002000000000000000000000001008C00000000000200000000000000000000000100A300000000005F00A10100000000003C4D6F64756C653E004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E646C6C00436F6E636174656E617465004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E6564446174615479706500536574006D73636F726C69620053797374656D004F626A6563740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E446174612E53716C547970657300494E756C6C61626C650053797374656D2E5465787400537472696E674275696C64657200696E7465726D656469617465526573756C7400496E69740053716C537472696E6700416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465002E63746F720053797374656D2E436F6C6C656374696F6E732E47656E65726963004C6973746031006D656D626572730049436F6C6C656374696F6E603100546F537472696E67006765745F49734E756C6C006765745F4E756C6C00506172736500436F756E740048617300496E636C7564657300496E436F6D6D6F6E00556E696F6E00496E746572736563740049734E756C6C004E756C6C0076616C7565006F7468657200720077006F626A65637473007300656C656D656E740073756273657400616E6F74686572006669727374007365636F6E640053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174006765745F56616C756500417070656E6400537472696E6700456D707479006765745F4C656E67746800417267756D656E744E756C6C457863657074696F6E0052656164537472696E670053716C55736572446566696E656454797065417474726962757465006765745F436F756E740049456E756D657261626C6560310041646452616E676500456E756D657261746F7200476574456E756D657261746F72006765745F43757272656E7400436F6E636174004D6F76654E6578740049446973706F7361626C6500446973706F73650049734E756C6C4F72456D70747900537562737472696E67005472696D004368617200537472696E6753706C69744F7074696F6E730053706C697400546F4C6F77657200417272617900536F72740053716C4D6574686F6441747472696275746500537472696E67436F6D70617269736F6E00457175616C730041646400000372000003770000032C0000000000988CD7764C980A49A3DB04E0EFC50A160008B77A5C561934E0890306121103200001052001011115052001011208042000111505200101121905200101121D0606151221010E08200101151225010E0320000E03200002040000120C060001120C111503200008042001020E05200102120C080002120C120C120C03280002040800120C042001010E042001010205200101115504200101080520010111696101000200000004005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F000005200112110E0520011211030307010205200112111C02060E0520020E08080607030E1115022B010002000000020054080B4D61784279746553697A65401F000054020D4973427974654F7264657265640105151221010E05151225010E0920010115127901130008200015117D0113000515117D010E04200013000600030E0E0E0E040001020E0420010E080B07050E0E0E15117D010E02040701120C0920021D0E1D0311808907100101011D1E00030A010E0B07060E1D0E08120C021D03240100020054020F497344657465726D696E6973746963015402094973507265636973650103070108080003020E0E1180950B0705020E0215117D010E02050702120C020520010113000D0705120C0E120C15117D010E020807040E1D0E021D031801001355736572446566696E6564446174615479706500000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313000000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000006182CF4B000000000200000091000000D4330000D415000052534453E34F9E44F81FB94E95CF281C5235867A01000000443A5C50726F6A656374735C55736572446566696E656444617461547970655C55736572446566696E656444617461547970655C6F626A5C44656275675C4D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E70646200000000903400000000000000000000AE340000002000000000000000000000000000000000000000000000A034000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000080400000000000000000000080434000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE0000010000000100F068B30E00000100F068B30E3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00468030000010053007400720069006E006700460069006C00650049006E0066006F00000044030000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000500014000100460069006C0065004400650073006300720069007000740069006F006E0000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0033003700360033002E00320036003800360034000000000098003B00010049006E007400650072006E0061006C004E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C00000000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F00660074002000320030003100300000000000A0003B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C0000000000480014000100500072006F0064007500630074004E0061006D00650000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0033003700360033002E00320036003800360034000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0033003700360033002E0032003600380036003400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000C03400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set        @ClrName = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.UserDefinedDataType');

-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash
END        

--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash, @ClrName        
END
GO

Server operating system

The following versions of Windows Server operating system are supported.

System Center component Windows Server 2019 Standard, Datacenter Windows Server 2019 Server Core Windows Server 2022 Standard, Datacenter Windows Server 2022 Server Core
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager Database or Data Warehouse Database
Service Manager Self-Service Portal (HTML 5)

Client operating system

The following versions of Windows client operating system are supported for the Service Manager console.

System Center client-side components Windows Server® 2019 Standard, Datacenter Enterprise Windows Server® 2022 Standard, Datacenter Windows 10 Windows 11
Service Manager Console

.NET Versions supported

The following versions of .NET are supported for Service Manager.

System Center component .NET 3.5 SP1 .NET 4 .NET 4.5 .NET 4.5.1 .NET 4.5.2 .NET 4.6 .NET 4.6.1 .NET 4.7 .NET 4.8
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager console
Service Manager Self-Service Portal

PowerShell Versions supported

The following versions of PowerShell are supported for Service Manager.

System Center Component Windows PowerShell 4.0 Windows PowerShell 5.0
Service Manager Console
Service Manager Management Server
Service Manager Data Warehouse Management Server

This article details the system requirements for System Center 2019 - Service Manager (SM).

System requirements for System Center 2019 - Service Manager

The following sections describe the general performance and scalability guidance for SM 2019, and recommend the hardware configurations for various workloads. Because System Center 2019 is built to be flexible and scalable, the hardware requirements for specific scenarios may differ from the guidelines that are presented here.

Capacity limits for Service Manager

Read Configurations for deployment scenarios to learn about the tested capacity limits of Service Manager.

Supported coexistence

To help simplify upgrades, you can use Service Manager 2019 connectors with the following System Center components.

  • System Center 2016/2019 Virtual Machine manager
  • System Center 2016/2019 Orchestrator
  • System Center 2016/2019 Operations Manager
  • System Center 2016 Configuration Manager (only during migration scenario)
  • System Center Configuration Manager CB releases
    • 1511, 1602, 1606, 1710, and 1802 (supported with Service Manager 2019 RTM)
    • 1806 to 2103, 2107 (supported with Service Manager 2019 UR2 and later)

Hardware

Servers Processor (min) Processor (rec) RAM (min) RAM (rec) Hard drive space (min) Hard drive space (rec)
Service Manager Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 8 GB 10 GB 10 GB
Service Manager Database 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 80 GB 80 GB
Service Manager Data Warehouse Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 16 GB 10 GB 10 GB
Service Manager Data Warehouse Databases 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 400 GB 400 GB
Service Manager Console 2-Core 2 GHz CPU 2-Core 2 GHz CPU 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (standalone) 4-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Secondary Management Server (Recommended) 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 16 GB 32 GB 80 GB 80 GB

Software requirements

Component Requirement
Service Manager management server The management server needs: ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Native client; Microsoft Report Viewer Redistributable, which is available with the Service Manager media.

The management server must be installed on a 64-bit edition of Windows.
Data warehouse management server The warehouse management server requires: SQL Server Native client

The data warehouse management server must be installed on a 64-bit edition of Windows.
Service Manager/data warehouse databases The Service Manager or data warehouse databases require: SQL Server Reporting Services (SSRS); SQL Server Analysis Management Objects.

The SQL Server and Analysis Services collation settings must be the same for the computers hosting the Service Manager database, data warehouse database, analysis services database, and Reporting Services database.
Service Manager console The console requires: Microsoft Report Viewer Redistributable (available on System Center media): Microsoft Excel in order to view OLAP data cubes on the console computer; ADO.NET Data Services Update for.NET Framework 3.5 SP1 for Windows Server; SQL Server Analysis Management Objects.

The console can be installed on both 32-bit and 64-bit editions of Windows.
Self-Service portal The Self-Service Portal server requires: Windows 2012 R2 server or later; the IIS role and ASP.NET 4.5 enabled; SQL Server Analysis Management Objects.

Join the server machine to the same domain where the Service Manager SDK Service is running. Ideally, on the primary or secondary server.
Machines using self-service The Self Service portal needs a screen resolution above 1024 X 768.

Supported browsers: Microsoft Edge; Microsoft Internet Explorer 10 and 11; Mozilla Firefox 42 and later; Google Chrome 46 and later.
SQL Server Reporting Services In a deployment topology where the computer hosting SSRS isn't on the same computer that hosts the data warehouse management server, you have to add Microsoft.EnterpriseManagement.Reporting.Code to the global assembly cache. Learn about the manual steps.

Additional notes

  • Operations Manager - Service Manager has the capability to import alerts and configuration items from an Operations Manager environment. Read about installing both Service Manager and Operations Manager in the same environment. You can create a data mart for Operations Manager.

  • Configuration Manager - Service Manager can import configuration items from a Configuration Manager environment.

  • Network requirements - To view external content from within knowledge articles, computers that host the Service Manager console must have Internet access, either directly or through a proxy server.

  • SMTP server- You must have access to a Simple Mail Transfer Protocol (SMTP) server to use the Notification feature and for incident creation through email.

  • Windows safe mode- Service Manager doesn't operate and the services used by Service Manager don't start if Windows Server is running in safe mode. If you attempt to start the Service Manager services manually while in safe mode, the services fail to start and an error is written into the event log.

SQL Server requirements

Microsoft SQL Server hosts the databases that System Center - Service Manager creates. In addition, System Center 2019 - Service Manager requires SQL Server Analysis Services (SSAS) to work with Microsoft Online Analytical Processing (OLAP) cubes. SQL Server Reporting Services (SSRS) is required to support System Center 2019 - Service Manager reporting.

Use this information to evaluate if your SQL Server environment is ready to support the installation of or upgrade to System Center 2019. Use this information whether you're deploying one or multiple components of System Center.

Note

During installation, select SQL Server full-text search on the computers running SQL Server that will host the Service Manager and data warehouse databases.

SQL Server version support

Note

  • SM doesn’t support SSAS mode Tabular. Select the SSAS mode as Multi-dimensional during the installation of SQL Server.
  • For the supported versions of SQL, use the service packs that are currently in support by Microsoft.
  • Service Manager 2019 supports SQL 2019 with CU8 or later; however, it doesn't support SQL 2019 RTM.
  • With SQL 2019 (CU8 or later), use ODBC 17.3 to 17.10.4.1, and MSOLEDBSQL 18.2 to 18.6.6.
Service Manager SQL Server 2016 and SPs SQL Server 2017 SQL Server 2019 with Cumulative Update 8
Service Manager/Data Warehouse database

Note

System Center 2019 - Service Manager doesn't support the MultiSubnetFailover parameter. This parameter isn't used in System Center 2019 - Service Manager connection strings.

Allow updates

To either install or upgrade System Center 2019 - Service Manager, computers running SQL Server that host databases must be configured to allow updates. If updates aren't allowed, System Center 2019 - Service Manager Setup won't complete and the following error message appears at the Create database stage of the installation:

An error occurred while executing a customer action: _ExecuteSqlScripts. This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the corrections are made, you can retry the upgrade for this role.

You can check the status of allow updates on SQL Server by executing the following stored procedure from within SQL Server Management Studio:

sp_configure 'allow updates'

In the results table, examine the value for run_value. If the value of run value is 1, set it back to 0 with the following stored procedure, and then run Setup again.

sp_configure 'allow updates',0 reconfigure with override

AlwaysOn Availability Groups considerations for Service Manager databases

SQL Server AlwaysOn Availability Groups functionality is supported by System Center 2019 - Service Manager.

For more information about installing Service Manager with AlwaysOn availability groups, refer here.

Upgrade to SQL 2017

The following steps provide information about upgrading to SQL 2017.

Note

Upgrade process to SQL 2017 uninstalls the reporting services; ensure to migrate required reports such as backup reporting DB and encryption keys.

Use the following steps to upgrade from SQL 2016 to 2017:

  1. Upgrade to SQL 2017.
  2. Install SQL 2017 reporting services (SSRS), launch the reporting services configuration manager to use the existing reporting DB, and restore encryption keys. Configure the Web service URL and Web portal URL.
  3. Use the same values for reporting server Web service virtual directory and Web portal URL that you had before initiating the upgrade process for SQL 2017.
  4. Configure the SSRS as per the details shared here.
  5. [Optional] To enable CLR strict security, run the following script on each of the Service Manager databases. By default, CLR strict security is disabled after you upgrade to SQL 2017.

Upgrade to SQL 2019

The following steps provide information about upgrading to SQL 2019.

Note

  • You must use Cumulative Update 8 (CU8) or later with SQL 2019.
  • Use ODBC 17.3 to 17.10.4.1, and MSOLEDBSQL 18.2 to 18.6.6.
  • Upgrade process to SQL 2019 uninstalls the reporting services; ensure to migrate required reports such as backup reporting DB and encryption keys.

Use the following steps to upgrade from SQL 2017 to 2019:

  1. Upgrade to SQL 2019.
  2. Install SQL 2019 reporting services (SSRS), and launch the reporting services configuration manager to use the existing reporting DB, restore encryption keys. Configure the Web service URL and Web portal URL.
  3. Use the same values for reporting server Web service virtual directory and Web portal URL that you had before initiating the upgrade process for SQL 2019.
  4. Configure the SSRS as per the details shared here.
  5. [Optional] To enable CLR strict security, run the following script on each of the Service Manager databases. By default, CLR strict security is disabled after you upgrade to SQL 2019.

Enable CLR strict security

Optional. Use the following script to enable CLR strict security.

-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash1 BINARY(64), @ClrName1 NVARCHAR(4000);
set @Hash1 = HASHBYTES(N'SHA2_512', 0x4d5a90000300000004000000ffff0000b800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000e1fba0e00b409cd21b8014ccd21546869732070726f6772616d2063616e6e6f742062652072756e20696e20444f53206d6f64652e0d0d0a2400000000000000504500004c010300cdef7c440000000000000000e0000e210b010800000c000000080000000000005e2b000000200000004000000000ec560020000000020000040000000000000004000000000000000080000000020000f2f10000030000040000100000100000000010000010000000000000100000000000000000000000042b000057000000004000001005000000000000000000000000000000000000006000000c0000008c2a00001c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002e74657874000000640b000000200000000c000000020000000000000000000000000000200000602e72737263000000100500000040000000060000000e0000000000000000000000000000400000402e72656c6f6300000c0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000402b0000000000004800000002000500082100008409000009000000000000000000000000000000502000008000000000000000000000000000000000000000000000000000000000000000000000000c506f2ef337d14f0bc66e27fa02006623253f6655697a25078f76132dfd4cf9ec02d54581a9310a12538c2a82f19f230bbe2ac6017a095a82147a15f65488b5b38c9612cfc2c228f748d5519b4981a836189698e99b7f54961091fbb404afb93ab9d8110f22652ab16e7ff50f9dfb4236d78f61e93555018ba85d95c28cb5452a02281000000a0000002a00133003001e00000001000011000214fe0116fe010b072d0500160a2b0b02031e281200000a0a2b00062a000042534a4201000100000000000c00000076322e302e35303732370000000005006c0000001c020000237e0000880200003c03000023537472696e677300000000c40500000800000023555300cc050000100000002347554944000000dc050000a803000023426c6f620000000000000002000001471502000900000000fa0133001600000100000014000000020000000200000002000000120000000e00000001000000010000000300000000000a00010000000000060084007d000600c900aa000600d700aa000600fd00eb0006001601eb0006003101eb0006005001eb0006006d01eb0006008401eb0006009f01eb000600b801eb000600d101eb000600ee01eb0006001a0207023b002e02000006005d023d0206007d023d020a00df02c4020e00210302030e00270302030000000001000000000001000100010110002b004600050001000100d0200000000081188b000a000100dc2000000000960091000e00010000000100f40200000200fa0211008b00140019008b00190021008b00140029008b00140031008b00140039008b00140041008b00140049008b00140051008b00140059008b00140061008b00140069008b00140071008b001e0081008b00240089008b000a0009008b000a0091008b000a009900340336022e003b00ac022e000b0043022e0013006d022e0023006d022e002b006d022e00330073022e0053004a032e004300e4022e004b0025032e006b0075032e007b0087032e005b0065032e0073007e0340008b00cb003e020480000006000000f50f00000100000029009b02000002000000000000000000000001007400000000000200000000000000000000000100b8020000000002000000000000000000000001007d00000000000000003c4d6f64756c653e004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e646c6c00526567756c617245787072657373696f6e4576616c7561746f72004d6963726f736f66742e456e74657270726973654d616e6167656d656e742e446174614163636573732e53716c006d73636f726c69620053797374656d004f626a656374002e63746f72004d617463686573526567756c617245787072657373696f6e0053797374656d2e52756e74696d652e496e7465726f705365727669636573004775696441747472696275746500436f6d56697369626c654174747269627574650053797374656d2e5265666c656374696f6e00417373656d626c7943756c7475726541747472696275746500417373656d626c7954726164656d61726b41747472696275746500417373656d626c79436f6e66696775726174696f6e41747472696275746500417373656d626c794465736372697074696f6e41747472696275746500417373656d626c795469746c6541747472696275746500417373656d626c79436f7079726967687441747472696275746500417373656d626c7950726f6475637441747472696275746500417373656d626c79436f6d70616e7941747472696275746500417373656d626c7946696c6556657273696f6e41747472696275746500417373656d626c7956657273696f6e4174747269627574650053797374656d2e446961676e6f73746963730044656275676761626c6541747472696275746500446562756767696e674d6f6465730053797374656d2e52756e74696d652e436f6d70696c6572536572766963657300436f6d70696c6174696f6e52656c61786174696f6e734174747269627574650052756e74696d65436f6d7061746962696c697479417474726962757465004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c0053797374656d2e44617461004d6963726f736f66742e53716c5365727665722e5365727665720053716c46756e6374696f6e41747472696275746500696e707574007061747465726e0053797374656d2e546578742e526567756c617245787072657373696f6e730052656765780052656765784f7074696f6e730049734d61746368000003200000000000a79e22af2016204a81c804d4f9bce8010008b77a5c561934e08903200001050002020e0e042001010e042001010205200101113d042001010880a000240000048000009400000006020000002400005253413100040000010001004ddb14fd25fa54ef1fe05516d69c0bb19c86956e2d5245e728300417e6a018daac56b61ee215e4c096dba942368bb4aa76956042bb3efb709cda847d7396839f57a40b90829fe5f347a5d2e2c198367cbc1092aa9762ae9776e59fed16703887329ffeb6d6cbf44853c496a22bc79bb3ce00f29760995dafa6aa97779983e0b48169010005005455794d6963726f736f66742e53716c5365727665722e5365727665722e446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038390a446174614163636573730000000054020f497344657465726d696e69737469630154020949735072656369736501540e044e616d651b666e5f4d617463686573526567756c617245787072657373696f6e54557f4d6963726f736f66742e53716c5365727665722e5365727665722e53797374656d446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038391053797374656d4461746141636365737300000000070003020e0e115104070202022901002433333532323533352d393332652d346130342d623965302d30616330383630353137663300000501000000003801003353716c436c722066756e6374696f6e616c697479207573656420627920746865206461746120616363657373206c617965722e0000370100324d6963726f736f66742e456e74657270726973654d616e6167656d656e742e53716c2e446174614163636573734c6179657200004001003b436f707972696768742032303035204d6963726f736f667420436f72706f726174696f6e2e2020416c6c207269676874732072657365727665642e00002401001f4d6963726f736f6674204f7065726174696f6e73204d616e6167657220763300001a0100154d6963726f736f667420436f72706f726174696f6e00000f01000a362e302e343038352e3000000801000701000000000801000800000000001e01000100540216577261704e6f6e457863657074696f6e5468726f777301000000000000cdef7c44000000000200000059000000a82a0000a80c000052534453165649e3ed4a514990cc3fb2ca36648a01000000643a5c6d6f6d76332e6d61696e5c7461726765745c64656275675c693338365c4d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e706462000000002c2b000000000000000000004e2b0000002000000000000000000000000000000000000000000000402b00000000000000000000000000000000000000005f436f72446c6c4d61696e006d73636f7265652e646c6c0000000000ff250020ec5600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000b80400000000000000000000b80434000000560053005f00560045005200530049004f004e005f0049004e0046004f0000000000bd04effe00000100000006000000f50f000006000000f50f3f000000000000000400000002000000000000000000000000000000440000000100560061007200460069006c00650049006e0066006f00000000002400040000005400720061006e0073006c006100740069006f006e00000000000000b00418040000010053007400720069006e006700460069006c00650049006e0066006f000000f4030000010030003000300030003000340062003000000080003400010043006f006d006d0065006e00740073000000530071006c0043006c0072002000660075006e006300740069006f006e0061006c0069007400790020007500730065006400200062007900200074006800650020006400610074006100200061006300630065007300730020006c0061007900650072002e0000004c001600010043006f006d00700061006e0079004e0061006d006500000000004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e000000900033000100460069006c0065004400650073006300720069007000740069006f006e00000000004d006900630072006f0073006f00660074002e0045006e00740065007200700072006900730065004d0061006e006100670065006d0065006e0074002e00530071006c002e0044006100740061004100630063006500730073004c0061007900650072000000000038000b000100460069006c006500560065007200730069006f006e000000000036002e0030002e0034003000380035002e0030000000000064002100010049006e007400650072006e0061006c004e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c00000000009c003c0001004c006500670061006c0043006f007000790072006900670068007400000043006f0070007900720069006700680074002000320030003000350020004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e002e002000200041006c006c0020007200690067006800740073002000720065007300650072007600650064002e0000006c00210001004f0072006900670069006e0061006c00460069006c0065006e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c0000000000600020000100500072006f0064007500630074004e0061006d006500000000004d006900630072006f0073006f006600740020004f007000650072006100740069006f006e00730020004d0061006e00610067006500720020007600330000003c000b000100500072006f006400750063007400560065007200730069006f006e00000036002e0030002e0034003000380035002e0030000000000040000b00010041007300730065006d0062006c0079002000560065007200730069006f006e00000036002e0030002e0034003000380035002e00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000c000000603b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set        @ClrName1 = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.DataAccessLayer');        

-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName1)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash1
END        

--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash1, @ClrName1        
END
GO

-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash BINARY(64), @ClrName NVARCHAR(4000);
set  @Hash = HASHBYTES(N'SHA2_512', 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006182CF4B0000000000000000E00002210B010800001600000008000000000000BE3400000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000006834000053000000004000006004000000000000000000000000000000000000006000000C000000B83300001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000C4140000002000000016000000020000000000000000000000000000200000602E7273726300000060040000004000000006000000180000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001E00000000000000000000000000004000004200000000000000000000000000000000A0340000000000004800000002000500DC250000DC0D00000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000360002731000000A7D010000042A0000133002002D00000001000011000F01281100000A16FE010A062D03002B1A027B010000040F01281200000A6F1300000A1F2C6F1400000A262A5200027B01000004037B010000046F1500000A262A0000133004004C00000002000011007E1600000A0A027B010000042C13027B010000046F1700000A16FE0216FE012B01170C082D1A027B0100000416027B010000046F1700000A17596F1800000A0A06731900000A0B2B00072A133003002900000001000011000314FE0116FE010A062D0B7201000070731A00000A7A02036F1B00000A731C00000A7D010000042A000000133002002A00000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03027B010000046F1D00000A6F1E00000A002A1E02281F00000A2A5602281F00000A000002732100000A7D02000004002A133002002F000000010000110228080000060000032C0E036F2200000A16FE0216FE012B01170A062D0F00027B02000004036F2300000A0000002A001B3003007600000003000011007E1600000A0A00027B020000046F2400000A0D2B1C1203282500000A0B00067209000070076F1D00000A282600000A0A001203282700000A130411042DD7DE0F1203FE160300001B6F2800000A00DC0006282900000A16FE01130411042D09007E1600000A0C2B0B0006176F2A00000A0C2B00082A000001100000020014002D41000F0000000013300200140000000100001100027B020000046F2B00000A16FE010A2B00062A133001000B000000040000110073080000060A2B00062A00133004008100000005000011000F00281200000A0A0F00281100000A2D10066F2C00000A282900000A16FE012B0116130411042D08280C0000060D2B4E06178D2100000113051105161F2C9D1105176F2D00000A0B160C2B1600070807089A6F2C00000A6F2E00000AA2000817580C08078E69FE04130411042DDE07280100002B000773090000060D2B00092A00000013300100110000000600001100027B020000046F2B00000A0A2B00062A0000001B300300560000000700001100160A00027B020000046F2400000A0D2B1F1203282500000A0B0007031B283100000A0A0616FE01130411042D022B0E001203282700000A130411042DD4DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010003040000F000000001B300200520000000700001100170A00037B020000046F2400000A0D2B1B1203282500000A0B000207280F0000060A06130411042D022B0E001203282700000A130411042DD8DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010002C3C000F0000000013300200170000000800001100020328130000060A066F0B00000616FE010B2B00072A001B300200670000000900001100027B0200000473090000060A00037B020000046F2400000A0D2B261203282500000A0B0006076F0F000006130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCDDE0F1203FE160300001B6F2800000A00DC00060C2B00082A000110000002001A003751000F000000001B30020064000000090000110073080000060A00037B020000046F2400000A0D2B291203282500000A0B0002076F0F00000616FE01130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCADE0F1203FE160300001B6F2800000A00DC00060C2B00082A01100000020014003A4E000F0000000013300400410000000A000011000314FE0116FE010C082D0B7201000070731A00000A7A036F1B00000A0A06178D210000010D09161F2C9D09176F2D00000A0B027B02000004076F2300000A002A000000133002002500000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03026F1D00000A6F1E00000A002A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000014050000237E000080050000A805000023537472696E677300000000280B00001000000023555300380B0000100000002347554944000000480B00009402000023426C6F6200000000000000020000015717A2090908000000FA01330016000001000000250000000300000002000000150000000F0000000300000032000000110000000A0000000100000002000000020000000300000001000000020000000100000000000A0001000000000006009C0095000A00CA00AF000A00F000DB0006000601FA000A002C01DB0006005B01510106006D0151010600A10186010600B001860106006902570206008002570206009D0257020600BC0257020600D50257020600EE02570206000903570206002403570206005C033D0306007003570206009C0389035300B00300000600DF03BF030600FF03BF0306001D0495000A003304AF000A005404AF0006006C0495000600840495000A00A504AF000600CB0486012300E204000006001705950006004805950006004D05950006006E0595000A007905AF0006008C059500000000000100000000000100010001201000450051000500010001000120100088005100050002000800010014010A000100A8012F00502000000000860027010E00010060200000000086003601120001009920000000008600410118000200B02000000000860047011E000300082100000000E601680123000300402100000000E6017A0129000400762100000000861880010E0005007E2100000000861880010E0005009421000000008618800136000500D02100000000C600BE013F000600642200000000E609C701430006008422000000009608D201470006009C22000000009600DB014C0006002C23000000008600E101530007004C23000000008600E70157000700C023000000008600EB015C0008003024000000008600F4015C0009005424000000009600FD0162000A00D824000000009600030262000C00582500000000E601680123000E00A82500000000E6017A0129000F00000001001902000001001F02000001002502000001002702000001002902000001003102000001003302000001003B02000001004202000001004A02000002005002000001004A020000020050020000010025020000010027020200090003000D0003000900510080017400590080017400610080017400690080017400710080017400790080017400810080017400890080017400910080017900990080017400A10080017E00B10080018400B90080010E00C10080010E00C90080018900210080010E002900C701430029005B043F0021006504F10021006504F700210065040101D900730407012100790453002100BE010A01290080017400E1008001740031009A043F002100800174000900BE013F0039007A017400090080010E00E900800189000C0080010E001400C10453000C00D9044F010C00ED0459011C00FB046801D90007056D011C000E054300010123050E00D9002B057401D900390579010C00C1045300D90043053F00D90060058F01D90066053F00190174059901210180010E00D9009D05DA010C00A405F5012E001B002B022E006B0073022E000B0012022E0013002B022E00230031022E002B0012022E00330040022E003B002B022E004B002B022E005B0061022E0063006A0243007B008F00630003011701C0018301B101E0018301B10100028301B10120028301B101FD0010017E018A01A501D601E301EF01FB0109020300010000000D026B00000014026F0002000B00030002000C0005004301490162010480000001000000B30EF0680000000000005100000002000000000000000000000001008C00000000000200000000000000000000000100A300000000005F00A10100000000003C4D6F64756C653E004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E646C6C00436F6E636174656E617465004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E6564446174615479706500536574006D73636F726C69620053797374656D004F626A6563740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E446174612E53716C547970657300494E756C6C61626C650053797374656D2E5465787400537472696E674275696C64657200696E7465726D656469617465526573756C7400496E69740053716C537472696E6700416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465002E63746F720053797374656D2E436F6C6C656374696F6E732E47656E65726963004C6973746031006D656D626572730049436F6C6C656374696F6E603100546F537472696E67006765745F49734E756C6C006765745F4E756C6C00506172736500436F756E740048617300496E636C7564657300496E436F6D6D6F6E00556E696F6E00496E746572736563740049734E756C6C004E756C6C0076616C7565006F7468657200720077006F626A65637473007300656C656D656E740073756273657400616E6F74686572006669727374007365636F6E640053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174006765745F56616C756500417070656E6400537472696E6700456D707479006765745F4C656E67746800417267756D656E744E756C6C457863657074696F6E0052656164537472696E670053716C55736572446566696E656454797065417474726962757465006765745F436F756E740049456E756D657261626C6560310041646452616E676500456E756D657261746F7200476574456E756D657261746F72006765745F43757272656E7400436F6E636174004D6F76654E6578740049446973706F7361626C6500446973706F73650049734E756C6C4F72456D70747900537562737472696E67005472696D004368617200537472696E6753706C69744F7074696F6E730053706C697400546F4C6F77657200417272617900536F72740053716C4D6574686F6441747472696275746500537472696E67436F6D70617269736F6E00457175616C730041646400000372000003770000032C0000000000988CD7764C980A49A3DB04E0EFC50A160008B77A5C561934E0890306121103200001052001011115052001011208042000111505200101121905200101121D0606151221010E08200101151225010E0320000E03200002040000120C060001120C111503200008042001020E05200102120C080002120C120C120C03280002040800120C042001010E042001010205200101115504200101080520010111696101000200000004005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F000005200112110E0520011211030307010205200112111C02060E0520020E08080607030E1115022B010002000000020054080B4D61784279746553697A65401F000054020D4973427974654F7264657265640105151221010E05151225010E0920010115127901130008200015117D0113000515117D010E04200013000600030E0E0E0E040001020E0420010E080B07050E0E0E15117D010E02040701120C0920021D0E1D0311808907100101011D1E00030A010E0B07060E1D0E08120C021D03240100020054020F497344657465726D696E6973746963015402094973507265636973650103070108080003020E0E1180950B0705020E0215117D010E02050702120C020520010113000D0705120C0E120C15117D010E020807040E1D0E021D031801001355736572446566696E6564446174615479706500000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313000000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000006182CF4B000000000200000091000000D4330000D415000052534453E34F9E44F81FB94E95CF281C5235867A01000000443A5C50726F6A656374735C55736572446566696E656444617461547970655C55736572446566696E656444617461547970655C6F626A5C44656275675C4D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E70646200000000903400000000000000000000AE340000002000000000000000000000000000000000000000000000A034000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000080400000000000000000000080434000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE0000010000000100F068B30E00000100F068B30E3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00468030000010053007400720069006E006700460069006C00650049006E0066006F00000044030000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000500014000100460069006C0065004400650073006300720069007000740069006F006E0000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0033003700360033002E00320036003800360034000000000098003B00010049006E007400650072006E0061006C004E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C00000000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F00660074002000320030003100300000000000A0003B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C0000000000480014000100500072006F0064007500630074004E0061006D00650000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0033003700360033002E00320036003800360034000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0033003700360033002E0032003600380036003400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000C03400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set        @ClrName = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.UserDefinedDataType');

-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash
END        

--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash, @ClrName        
END
GO

Server operating system

The following versions of Windows Server operating system are supported.

System Center component Windows Server 2016 Standard, Datacenter Windows Server 2016 Server Core Windows Server 2019 Standard, Datacenter Windows Server 2019 Server Core
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager Database or Data Warehouse Database
Service Manager Self-Service Portal (HTML 5)

Client operating system

The following versions of Windows client operating system are supported for the Service Manager console.

System Center client-side components Windows Server® 2016 Standard, Datacenter Enterprise Windows Server® 2019 Standard, Data Center Windows 10 Windows 11
Service Manager Console

.NET Versions supported

The following versions of .NET are supported for Service Manager.

Note

System Center Service Manager 2019 UR4 and later supports .NET 4.8

System Center component .NET 3.5 SP1 .NET 4 .NET 4.5 .NET 4.5.1 .NET 4.5.2 .NET 4.6 .NET 4.6.1 .NET 4.7 .NET 4.8
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager console
Service Manager Self-Service Portal

PowerShell Versions supported

The following versions of PowerShell are supported for Service Manager.

System Center Component Windows PowerShell 2.0 Windows PowerShell 3.0 Windows PowerShell 4.0 Windows PowerShell 5.0
Service Manager Console
Service Manager Management Server
Service Manager Data Warehouse Management Server

Important

This version of Service Manager has reached the end of support. We recommend you to upgrade to Service Manager 2022.

This article details the system requirements for System Center 1807 - Service Manager (SM).

System requirements for System Center 1807 - Service Manager

The following sections describe the general performance and scalability guidance for SM 1807, and recommend the hardware configurations for various workloads. Because System Center 1807 is built to be flexible and scalable, the hardware requirements for specific scenarios may differ from the guidelines that are presented here.

Capacity limits for Service Manager

Read Configurations for deployment scenarios to learn about the tested capacity limits of Service Manager.

Supported coexistence

To help simplify upgrades, you can use Service Manager 1807 connectors with the following System Center components.

  • System Center 2012 R2/2016 Virtual Machine manager
  • System Center 2012 R2/2016 Orchestrator
  • System Center 2012 R2/2016 Operations Manager
  • System Center 2012 R2/2016 Configuration Manager
  • System Center Configuration Manager CB releases - 1511, 1602, 1606, 1710, 1802, 1806, and 1810

Hardware

Servers Processor (min) Processor (rec) RAM (min) RAM (rec) Hard drive space (min) Hard drive space (rec)
Service Manager Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 8 GB 10 GB 10 GB
Service Manager Database 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 80 GB 80 GB
Service Manager Data Warehouse Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 16 GB 10 GB 10 GB
Service Manager Data Warehouse Databases 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 400 GB 400 GB
Service Manager Console 2-Core 2 GHz CPU 2-Core 2 GHz CPU 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (standalone) 4-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Secondary Management Server (Recommended) 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 16 GB 32 GB 80 GB 80 GB

Software requirements

Component Requirement
Service Manager management server The management server needs: ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Native client; Microsoft Report Viewer Redistributable, which is available with the Service Manager media.

The management server must be installed on a 64-bit edition of Windows.
Data warehouse management server The warehouse management server requires: SQL Server Native client

The data warehouse management server must be installed on a 64-bit edition of Windows.
Service Manager/data warehouse databases The Service Manager or data warehouse databases require: SQL Server Reporting Services (SSRS); SQL Server Analysis Management Objects.

The SQL Server and Analysis Services collation settings must be the same for the computers hosting the Service Manager database, data warehouse database, analysis services database, and Reporting Services database.
Service Manager console The console requires: Microsoft Report Viewer Redistributable (available on System Center media): Microsoft Excel in order to view OLAP data cubes on the console computer; ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Analysis Management Objects.

The console can be installed on both 32-bit and 64-bit editions of Windows.
Self-Service portal The Self-Service Portal server requires: Windows 2012 R2 server or later; the IIS role and ASP.NET 4.5 enabled; SQL Server Analysis Management Objects.

Join the server machine to the same domain where the Service Manager SDK Service is running. Ideally, on the primary or secondary server.
Machines using self-service The Self Service portal needs a screen resolution above 1024 X 768.

Supported browsers: Microsoft Edge; Microsoft Internet Explorer 10 and 11; Mozilla Firefox 42 and later; Google Chrome 46 and later.
SQL Server Reporting Services In a deployment topology where the computer hosting SSRS isn't on the same computer that hosts the data warehouse management server, you've to add Microsoft.EnterpriseManagement.Reporting.Code to the global assembly cache. Learn about the manual steps.

Additional notes

  • Operations Manager - Service Manager has the capability to import alerts and configuration items from an Operations Manager environment. Read about installing both Service Manager and Operations Manager in the same environment. You can create a data mart for Operations Manager.

  • Configuration Manager - Service Manager can import configuration items from a Configuration Manager environment.

  • Network requirements - To view external content from within knowledge articles, computers that host the Service Manager console must have Internet access, either directly or through a proxy server.

  • SMTP server- You must have access to a Simple Mail Transfer Protocol (SMTP) server to use the Notification feature and for incident creation through email.

  • Windows safe mode- Service Manager doesn't operate and the services used by Service Manager don't start if Windows Server is running in safe mode. If you attempt to start the Service Manager services manually while in safe mode, the services fail to start and an error is written into the event log.

SQL Server requirements

Microsoft SQL Server hosts the databases that System Center - Service Manager creates. In addition, System Center 1807 - Service Manager requires SQL Server Analysis Services (SSAS) to work with Microsoft Online Analytical Processing (OLAP) cubes. SQL Server Reporting Services (SSRS) is required to support System Center 1807 - Service Manager reporting.

Use this information to evaluate if your SQL Server environment is ready to support the installation of or upgrade to System Center 1807. Use this information whether you're deploying one or multiple components of System Center.

SQL Server version support

Note

For the supported versions of SQL, use the service packs that are currently in support by Microsoft.

Service Manager SQL Server 2012 SQL Server 2014 and SPs SQL Server 2016 and SPs SQL Server 2017
Service Manager/Data Warehouse database

Note

System Center 1807 - Service Manager doesn't support the MultiSubnetFailover parameter. This parameter isn't used in System Center 1807 - Service Manager connection strings.

Allow updates

To either install or upgrade System Center 1807 - Service Manager, computers running SQL Server that host databases must be configured to allow updates. If updates aren't allowed, System Center 1807 - Service Manager Setup won't complete and the following error message will appear at the Create database stage of the installation:

An error occurred while executing a customer action: _ExecuteSqlScripts. This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the corrections are made, you can retry the upgrade for this role.

You can check the status of allow updates on SQL Server by executing the following stored procedure from within SQL Server Management Studio:

sp_configure 'allow updates'

In the results table, examine the value for "run_value". If the value of "run value" is 1, set it back to 0 with the following stored procedure, and then run Setup again.

sp_configure 'allow updates',0 reconfigure with override

AlwaysOn Availability Groups considerations for Service Manager databases

SQL Server AlwaysOn Availability Groups functionality is supported by System Center 1807 - Service Manager.

For more information about installing Service Manager with AlwaysOn availability groups, refer here.

Upgrade to SQL 2017

The following steps provide information about upgrading to SQL 2017.

Note

  • With SM 1807, SQL 2017 is supported only if it's upgraded from SQL 2016. Fresh installation of SQL 2017 with SM 1807 isn't supported.
  • Users with SM 1801 deployment and SQL 2016 need to apply SM 1807 and then upgrade to SQL 2017.
  • Upgrade process to SQL 2017 uninstalls the reporting services; ensure to migrate required reports such as backup reporting DB and encryption keys.

Use the following steps to upgrade from SQL 2016 to 2017:

  1. Upgrade to SQL 2017.

  2. Install SQL 2017 reporting services (SSRS), and launch the reporting services configuration manager to use the existing reporting DB, restore encryption keys. Configure the Web service URL and Web portal URL.

  3. Use the same values for reporting server Web service virtual directory and Web portal URL that you had before initiating the upgrade process for SQL 2017.

  4. Configure the SSRS as per the details shared here.

  5. [Optional] To enable CLR strict security, run the following script on each of the service manager databases.

    By default, CLR strict security is disabled after you upgrade to SQL 2017.

    -- Do this only for SQL server version 2017 and more
    IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
    BEGIN
    DECLARE @Hash1 BINARY(64), @ClrName1 NVARCHAR(4000);
    set @Hash1 = HASHBYTES(N'SHA2_512', 0x4d5a90000300000004000000ffff0000b800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000e1fba0e00b409cd21b8014ccd21546869732070726f6772616d2063616e6e6f742062652072756e20696e20444f53206d6f64652e0d0d0a2400000000000000504500004c010300cdef7c440000000000000000e0000e210b010800000c000000080000000000005e2b000000200000004000000000ec560020000000020000040000000000000004000000000000000080000000020000f2f10000030000040000100000100000000010000010000000000000100000000000000000000000042b000057000000004000001005000000000000000000000000000000000000006000000c0000008c2a00001c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002e74657874000000640b000000200000000c000000020000000000000000000000000000200000602e72737263000000100500000040000000060000000e0000000000000000000000000000400000402e72656c6f6300000c0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000402b0000000000004800000002000500082100008409000009000000000000000000000000000000502000008000000000000000000000000000000000000000000000000000000000000000000000000c506f2ef337d14f0bc66e27fa02006623253f6655697a25078f76132dfd4cf9ec02d54581a9310a12538c2a82f19f230bbe2ac6017a095a82147a15f65488b5b38c9612cfc2c228f748d5519b4981a836189698e99b7f54961091fbb404afb93ab9d8110f22652ab16e7ff50f9dfb4236d78f61e93555018ba85d95c28cb5452a02281000000a0000002a00133003001e00000001000011000214fe0116fe010b072d0500160a2b0b02031e281200000a0a2b00062a000042534a4201000100000000000c00000076322e302e35303732370000000005006c0000001c020000237e0000880200003c03000023537472696e677300000000c40500000800000023555300cc050000100000002347554944000000dc050000a803000023426c6f620000000000000002000001471502000900000000fa0133001600000100000014000000020000000200000002000000120000000e00000001000000010000000300000000000a00010000000000060084007d000600c900aa000600d700aa000600fd00eb0006001601eb0006003101eb0006005001eb0006006d01eb0006008401eb0006009f01eb000600b801eb000600d101eb000600ee01eb0006001a0207023b002e02000006005d023d0206007d023d020a00df02c4020e00210302030e00270302030000000001000000000001000100010110002b004600050001000100d0200000000081188b000a000100dc2000000000960091000e00010000000100f40200000200fa0211008b00140019008b00190021008b00140029008b00140031008b00140039008b00140041008b00140049008b00140051008b00140059008b00140061008b00140069008b00140071008b001e0081008b00240089008b000a0009008b000a0091008b000a009900340336022e003b00ac022e000b0043022e0013006d022e0023006d022e002b006d022e00330073022e0053004a032e004300e4022e004b0025032e006b0075032e007b0087032e005b0065032e0073007e0340008b00cb003e020480000006000000f50f00000100000029009b02000002000000000000000000000001007400000000000200000000000000000000000100b8020000000002000000000000000000000001007d00000000000000003c4d6f64756c653e004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e646c6c00526567756c617245787072657373696f6e4576616c7561746f72004d6963726f736f66742e456e74657270726973654d616e6167656d656e742e446174614163636573732e53716c006d73636f726c69620053797374656d004f626a656374002e63746f72004d617463686573526567756c617245787072657373696f6e0053797374656d2e52756e74696d652e496e7465726f705365727669636573004775696441747472696275746500436f6d56697369626c654174747269627574650053797374656d2e5265666c656374696f6e00417373656d626c7943756c7475726541747472696275746500417373656d626c7954726164656d61726b41747472696275746500417373656d626c79436f6e66696775726174696f6e41747472696275746500417373656d626c794465736372697074696f6e41747472696275746500417373656d626c795469746c6541747472696275746500417373656d626c79436f7079726967687441747472696275746500417373656d626c7950726f6475637441747472696275746500417373656d626c79436f6d70616e7941747472696275746500417373656d626c7946696c6556657273696f6e41747472696275746500417373656d626c7956657273696f6e4174747269627574650053797374656d2e446961676e6f73746963730044656275676761626c6541747472696275746500446562756767696e674d6f6465730053797374656d2e52756e74696d652e436f6d70696c6572536572766963657300436f6d70696c6174696f6e52656c61786174696f6e734174747269627574650052756e74696d65436f6d7061746962696c697479417474726962757465004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c0053797374656d2e44617461004d6963726f736f66742e53716c5365727665722e5365727665720053716c46756e6374696f6e41747472696275746500696e707574007061747465726e0053797374656d2e546578742e526567756c617245787072657373696f6e730052656765780052656765784f7074696f6e730049734d61746368000003200000000000a79e22af2016204a81c804d4f9bce8010008b77a5c561934e08903200001050002020e0e042001010e042001010205200101113d042001010880a000240000048000009400000006020000002400005253413100040000010001004ddb14fd25fa54ef1fe05516d69c0bb19c86956e2d5245e728300417e6a018daac56b61ee215e4c096dba942368bb4aa76956042bb3efb709cda847d7396839f57a40b90829fe5f347a5d2e2c198367cbc1092aa9762ae9776e59fed16703887329ffeb6d6cbf44853c496a22bc79bb3ce00f29760995dafa6aa97779983e0b48169010005005455794d6963726f736f66742e53716c5365727665722e5365727665722e446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038390a446174614163636573730000000054020f497344657465726d696e69737469630154020949735072656369736501540e044e616d651b666e5f4d617463686573526567756c617245787072657373696f6e54557f4d6963726f736f66742e53716c5365727665722e5365727665722e53797374656d446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038391053797374656d4461746141636365737300000000070003020e0e115104070202022901002433333532323533352d393332652d346130342d623965302d30616330383630353137663300000501000000003801003353716c436c722066756e6374696f6e616c697479207573656420627920746865206461746120616363657373206c617965722e0000370100324d6963726f736f66742e456e74657270726973654d616e6167656d656e742e53716c2e446174614163636573734c6179657200004001003b436f707972696768742032303035204d6963726f736f667420436f72706f726174696f6e2e2020416c6c207269676874732072657365727665642e00002401001f4d6963726f736f6674204f7065726174696f6e73204d616e6167657220763300001a0100154d6963726f736f667420436f72706f726174696f6e00000f01000a362e302e343038352e3000000801000701000000000801000800000000001e01000100540216577261704e6f6e457863657074696f6e5468726f777301000000000000cdef7c44000000000200000059000000a82a0000a80c000052534453165649e3ed4a514990cc3fb2ca36648a01000000643a5c6d6f6d76332e6d61696e5c7461726765745c64656275675c693338365c4d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e706462000000002c2b000000000000000000004e2b0000002000000000000000000000000000000000000000000000402b00000000000000000000000000000000000000005f436f72446c6c4d61696e006d73636f7265652e646c6c0000000000ff250020ec5600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000b80400000000000000000000b80434000000560053005f00560045005200530049004f004e005f0049004e0046004f0000000000bd04effe00000100000006000000f50f000006000000f50f3f000000000000000400000002000000000000000000000000000000440000000100560061007200460069006c00650049006e0066006f00000000002400040000005400720061006e0073006c006100740069006f006e00000000000000b00418040000010053007400720069006e006700460069006c00650049006e0066006f000000f4030000010030003000300030003000340062003000000080003400010043006f006d006d0065006e00740073000000530071006c0043006c0072002000660075006e006300740069006f006e0061006c0069007400790020007500730065006400200062007900200074006800650020006400610074006100200061006300630065007300730020006c0061007900650072002e0000004c001600010043006f006d00700061006e0079004e0061006d006500000000004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e000000900033000100460069006c0065004400650073006300720069007000740069006f006e00000000004d006900630072006f0073006f00660074002e0045006e00740065007200700072006900730065004d0061006e006100670065006d0065006e0074002e00530071006c002e0044006100740061004100630063006500730073004c0061007900650072000000000038000b000100460069006c006500560065007200730069006f006e000000000036002e0030002e0034003000380035002e0030000000000064002100010049006e007400650072006e0061006c004e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c00000000009c003c0001004c006500670061006c0043006f007000790072006900670068007400000043006f0070007900720069006700680074002000320030003000350020004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e002e002000200041006c006c0020007200690067006800740073002000720065007300650072007600650064002e0000006c00210001004f0072006900670069006e0061006c00460069006c0065006e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c0000000000600020000100500072006f0064007500630074004e0061006d006500000000004d006900630072006f0073006f006600740020004f007000650072006100740069006f006e00730020004d0061006e00610067006500720020007600330000003c000b000100500072006f006400750063007400560065007200730069006f006e00000036002e0030002e0034003000380035002e0030000000000040000b00010041007300730065006d0062006c0079002000560065007200730069006f006e00000036002e0030002e0034003000380035002e00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000c000000603b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
    set        @ClrName1 = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.DataAccessLayer');        
    
    -- Drop trusted assembly if exists
    IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName1)
    BEGIN
    EXEC SYS.sp_drop_trusted_assembly @Hash1
    END        
    
    --Add to trusted assembly
    EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash1, @ClrName1        
    END
    GO
    

Server operating system

The following versions of Windows Server operating system are supported.

System Center component Windows Server 2012 Standard, Datacenter Windows Server 2012 R2 Standard, Datacenter Windows Server 2016 Windows Server 2016 (Server with Desktop Experience) Windows Server 2016 Nano Server
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager Database or Data Warehouse Database
Service Manager Self-Service Portal (HTML 5)  

Client operating system

The following versions of Windows client operating system are supported for the Service Manager console.

System Center client-side components Windows® 7 Windows® 8 Windows® 8.1 Windows Server® 2008 R2 SP1 Windows Server® 2012 Windows Server® 2012 R2 Standard, Datacenter Windows 10 Enterprise Windows Server® 2016 Standard, Datacenter
Service Manager Console

.NET Versions supported

The following versions of .NET are supported for Service Manager.

System Center 1807 component .NET 3.5 SP1 .NET 4 .NET 4.5 .NET 4.5.1 .NET 4.5.2 .NET 4.6
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager console
Service Manager Self-Service Portal  

PowerShell Versions supported

The following versions of PowerShell are supported for Service Manager.

System Center Component Windows PowerShell 2.0 Windows PowerShell 3.0 Windows PowerShell 4.0 Windows PowerShell 5.0
Service Manager Console
Service Manager Management Server
Service Manager Data Warehouse Management Server

Important

This version of Service Manager has reached the end of support. We recommend you to upgrade to Service Manager 2022.

This article details the system requirements for System Center 1801 - Service Manager (SM).

This article details the system requirements for System Center 2016 - Service Manager (SM).

System requirements for System Center 1801 - Service Manager

The following sections describe the general performance and scalability guidance for SM 1801, and recommend the hardware configurations for various workloads. Because System Center 1801 is built to be flexible and scalable, the hardware requirements for specific scenarios may differ from the guidelines that are presented here.

Capacity limits for Service Manager

Read Configurations for deployment scenarios to learn about the tested capacity limits of Service Manager.

Supported coexistence

To help simplify upgrades, you can use Service Manager 1801 connectors with the following System Center components.

  • System Center 2012 R2/2016 Virtual Machine manager
  • System Center 2012 R2/2016 Orchestrator
  • System Center 2012 R2/2016 Operations Manager
  • System Center 2012 R2/2016 Configuration Manager
  • System Center Configuration Manager CB releases - 1511, 1602, 1606 and 1710

Hardware

Servers Processor (min) Processor (rec) RAM (min) RAM (rec) Hard drive space (min) Hard drive space (rec)
Service Manager Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 8 GB 10 GB 10 GB
Service Manager Database 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 80 GB 80 GB
Service Manager Data Warehouse Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 16 GB 10 GB 10 GB
Service Manager Data Warehouse Databases 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 400 GB 400 GB
Service Manager Console 2-Core 2 GHz CPU 2-Core 2 GHz CPU 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (standalone) 4-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Secondary Management Server (Recommended) 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 16 GB 32 GB 80 GB 80 GB

Software requirements

Component Requirement
Service Manager management server The management server needs: ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Native client; Microsoft Report Viewer Redistributable, which is available with the Service Manager media.

The management server must be installed on a 64-bit edition of Windows.
Data warehouse management server The warehouse management server requires: SQL Server Native client

The data warehouse management server must be installed on a 64-bit edition of Windows.
Service Manager/data warehouse databases The Service Manager or data warehouse databases require: SQL Server Reporting Services (SSRS); SQL Server Analysis Management Objects.

The SQL Server and Analysis Services collation settings must be the same for the computers hosting the Service Manager database, data warehouse database, analysis services database, and Reporting Services database.
Service Manager console The console requires: Microsoft Report Viewer Redistributable (available on System Center media): Microsoft Excel in order to view OLAP data cubes on the console computer; ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Analysis Management Objects.

The console can be installed on both 32-bit and 64-bit editions of Windows.
Self-Service portal The Self-Service Portal server requires: Windows 2012 R2 server or later; the IIS role and ASP.NET 4.5 enabled; SQL Server Analysis Management Objects.

Join the server machine to the same domain where the Service Manager SDK Service is running. Ideally, on the primary or secondary server.
Machines using self-service The Self Service portal needs a screen resolution above 1024 X 768.

Supported browsers: Microsoft Edge; Microsoft Internet Explorer 10 and 11; Mozilla Firefox 42 and later; Google Chrome 46 and later.
SQL Server Reporting Services In a deployment topology where the computer hosting SSRS isn't on the same computer that hosts the data warehouse management server, you've to add Microsoft.EnterpriseManagement.Reporting.Code to the global assembly cache. Learn about the manual steps.

Additional notes

  • Operations Manager - Service Manager has the capability to import alerts and configuration items from an Operations Manager environment. Read about installing both Service Manager and Operations Manager in the same environment. You can create a data mart for Operations Manager.

  • Configuration Manager - Service Manager can import configuration items from a Configuration Manager environment.

  • Network requirements - To view external content from within knowledge articles, computers that host the Service Manager console must have Internet access, either directly or through a proxy server.

  • SMTP server- You must have access to a Simple Mail Transfer Protocol (SMTP) server to use the Notification feature and for incident creation through email.

  • Windows safe mode- Service Manager doesn't operate and the services used by Service Manager don't start if Windows Server is running in safe mode. If you attempt to start the Service Manager services manually while in safe mode, the services fail to start and an error is written into the event log.

SQL Server requirements

Microsoft SQL Server hosts the databases that System Center - Service Manager creates. In addition, System Center 1801 - Service Manager requires SQL Server Analysis Services (SSAS) to work with Microsoft Online Analytical Processing (OLAP) cubes. SQL Server Reporting Services (SSRS) is required to support System Center 1801 - Service Manager reporting.

Use this information to evaluate if your SQL Server environment is ready to support the installation of or upgrade to System Center 1801. Use this information whether you're deploying one or multiple components of System Center.

SQL Server version support

Note

For the supported versions of SQL, use the service packs that are currently in support by Microsoft.

Service Manager SQL Server 2012 SQL Server 2014 and SPs SQL Server 2016 and SPs
Service Manager/Data Warehouse database

Note

System Center 1801 - Service Manager does not support the MultiSubnetFailover parameter. This parameter isn't used in System Center 1801 - Service Manager connection strings.

Allow updates

To either install or upgrade System Center 1801 - Service Manager, computers running SQL Server that host databases must be configured to allow updates. If updates aren't allowed, System Center 1801 - Service Manager Setup won't complete and the following error message will appear at the Create database stage of the installation:

An error occurred while executing a customer action: _ExecuteSqlScripts. This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the corrections are made, you can retry the upgrade for this role.

You can check the status of allow updates on SQL Server by executing the following stored procedure from within SQL Server Management Studio:

sp_configure 'allow updates'

In the results table, examine the value for "run_value". If the value of "run value" is 1, set it back to 0 with the following stored procedure, and then run Setup again.

sp_configure 'allow updates',0 reconfigure with override

AlwaysOn Availability Groups considerations for Service Manager databases

SQL Server AlwaysOn Availability Groups functionality is supported by System Center 1801 - Service Manager.

For more information about installing Service Manager with AlwaysOn availability groups, refer here.

Server operating system

The following versions of Windows Server operating system are supported.

System Center component Windows Server 2012 Standard, Datacenter Windows Server 2012 R2 Standard, Datacenter Windows Server 2016 Windows Server 2016 (Server with Desktop Experience) Windows Server 2016 Nano Server
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager Database or Data Warehouse Database
Service Manager Self-Service Portal (HTML 5)  

Client operating system

The following versions of Windows client operating system are supported for the Service Manager console.

System Center client-side components Windows® 7 Windows® 8 Windows® 8.1 Windows Server® 2008 R2 SP1 Windows Server® 2012 Windows Server® 2012 R2 Standard, Datacenter Windows 10 Enterprise Windows Server® 2016 Standard, Datacenter
Service Manager Console

.NET Versions supported

The following versions of .NET are supported for Service Manager.

System Center 1801 component .NET 3.5 SP1 .NET 4 .NET 4.5 .NET 4.5.1 .NET 4.5.2 .NET 4.6
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager console
Service Manager Self-Service Portal  

PowerShell Versions supported

The following versions of PowerShell are supported for Service Manager.

System Center Component Windows PowerShell 2.0 Windows PowerShell 3.0 Windows PowerShell 4.0 Windows PowerShell 5.0
Service Manager Console
Service Manager Management Server
Service Manager Data Warehouse Management Server

System requirements for System Center 2016 - Service Manager

The following sections describe the general performance and scalability guidance for SM 2016, and recommend the hardware configurations for various workloads. Because System Center 2016 is built to be flexible and scalable, the hardware requirements for specific scenarios may differ from the guidelines that are presented here.

Capacity limits for Service Manager

Learn about the tested capacity limits for various Service Manager deployment scenarios.

Supported coexistence

To help simplify upgrades, you can use the following Service Manager 2016 connectors with System Center 2012 R2 components.

  • System Center 2012 R2 Virtual Machine manager
  • System Center 2012 R2 Orchestrator
  • System Center 2012 R2 Operations Manager
  • System Center 2012 R2 Configuration Manager
  • System Center Configuration Manager (SCCM) CB releases - 1511, 1602, 1606, and 1710.
    • UR5 supports 1802
    • UR9 and UR10 supports from 1806 to 2103. However, there's a limitation that the size of the devices supported by SCCM should be less than 2 PB.
    • UR10 supports 2107

Hardware

Server Processor (min) Processor (rec) RAM (min) RAM (rec) Hard drive space (min) Hard drive space (rec)
Service Manager Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 8 GB 10 GB 10 GB
Service Manager Database 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 80 GB 80 GB
Service Manager Data Warehouse Management Server 4-Core 2.66 GHz CPU 4-Core 2.66 GHz CPU 8 GB 16 GB 10 GB 10 GB
Service Manager Data Warehouse Databases 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 32 GB 400 GB 400 GB
Service Manager Console 2-Core 2 GHz CPU 2-Core 2 GHz CPU 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (standalone) 4-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Secondary Management Server (Recommended) 8-Core 2.66 GHz CPU 8-Core 2.66 GHz CPU 16 GB 32 GB 80 GB 80 GB

Server operating system

The following versions of Windows Server operating system are supported.

System Center component Windows Server 2012 Standard, Datacenter Windows Server 2012 R2 Standard, Datacenter Windows Server 2016 Windows Server 2016 (Server with Desktop Experience) Windows Server 2016 Nano Server
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager Database or Data Warehouse Database
Service Manager Self-Service Portal (HTML 5)  

Client operating system

The following versions of Windows client operating system are supported for the Service Manager console.

System Center client-side components Windows® 7 Windows® 8 Windows® 8.1 Windows Server® 2008 R2 SP1 Windows Server® 2012 Windows Server® 2012 R2 Standard, Datacenter Windows 10 Enterprise Windows Server® 2016 Standard, Datacenter
Service Manager Console

.NET versions

The following versions of .NET are supported for Service Manager.

System Center 2016 component .NET 3.5 SP1 .NET 4 .NET 4.5 .NET 4.5.1 .NET 4.5.2 .NET 4.6 .NET 4.6.1 .NET 4.7
Service Manager Management Server
Service Manager Data Warehouse Management Server
Service Manager console
Service Manager Self-Service Portal

PowerShell Versions supported

The following versions of PowerShell are supported for Service Manager.

System Center Component Windows PowerShell 2.0 Windows PowerShell 3.0 Windows PowerShell 4.0 Windows PowerShell 5.0
Service Manager Console
Service Manager Management Server
Service Manager Data Warehouse Management Server

Software requirements

Component Requirement
Service Manager management server The management server needs: ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Native client; Microsoft Report Viewer Redistributable, which is available with the Service Manager media.

The management server must be installed on a 64-bit edition of Windows.
Data warehouse management server The warehouse management server requires: SQL Server Native client

The data warehouse management server must be installed on a 64-bit edition of Windows.
Service Manager/data warehouse databases The Service Manager or data warehouse databases require: SQL Server Reporting Services (SSRS); SQL Server Analysis Management Objects.

The SQL Server and Analysis Services collation settings must be the same for the computers hosting the Service Manager database, data warehouse database, analysis services database, and Reporting Services database.
Service Manager console The console requires: Microsoft Report Viewer Redistributable (available on System Center media): Microsoft Excel in order view OLAP data cubes on the console computer; ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server; SQL Server Analysis Management Objects

The console can be installed on both 32-bit and 64-bit editions of Windows.
Self-Service portal The Self-Service Portal server requires: Windows 2012 R2 server or later; the IIS role and ASP.NET 4.5 enabled; SQL Server Analysis Management Objects

Join the server machine to the same domain where the Service Manager SDK Service is running. Ideally, on the primary or secondary server.
Machines using self-service The Self Service portal needs a screen resolution above 1024 X 768.

Supported browsers: Microsoft Edge; Microsoft Internet Explorer 10 and 11; Mozilla Firefox 42 and later; Google Chrome 46 and later
SQL Server Reporting Services In a deployment topology where the computer hosting SSRS isn't on the same computer that hosts the data warehouse management server, you've to add Microsoft.EnterpriseManagement.Reporting.Code to the global assembly cache. Learn about the manual steps.
Operations Manager Service Manager has the capability to import alerts and configuration items from an Operations Manager environment. Read about installing both Service Manager and Operations Manager in the same environment.

You can create a data mart for Operations Manager.
Configuration Manager Service Manager can import configuration items from a Configuration Manager environment.
Network requirements To view external content from within knowledge articles, computers that host the Service Manager console must have Internet access, either directly or through a proxy server.
SMTP server You must have access to a Simple Mail Transfer Protocol (SMTP) server to use the Notification feature and for incident creation through email.
Windows safe mode Service Manager doesn't operate and the services used by Service Manager don't start if Windows Server is running in safe mode. If you attempt to start the Service Manager services manually while in safe mode, the services fail to start and an error is written into the event log.

Microsoft SQL Server hosts the databases that System Center 2016 - Service Manager creates. In addition, System Center 2016 - Service Manager requires SQL Server Analysis Services (SSAS) to work with Microsoft Online Analytical Processing (OLAP) cubes. SQL Server Reporting Services (SSRS) is required to support System Center 2016 - Service Manager reporting.

Use this information to evaluate if your SQL Server environment is ready to support the installation of or upgrade to System Center 2016. Use this information whether you're deploying one or multiple components of System Center.

SQL Server versions

The following table summarizes the support for SQL Server 64-bit Enterprise and Standard versions.

Note

For the supported versions of SQL, use the service packs that are currently in support by Microsoft.

Service Manager SQL Server 2012 SQL Server 2014 and SPs SQL Server 2016 and SPs
Service Manager/Data Warehouse database
  • System Center 2016 - Service Manager doesn't support setting the MultiSubnetFailover parameter. This parameter isn't used in Service Manager connection strings.
  • SQL Server AlwaysOn Availability Groups are supported in System Center 2016 - Service Manager. Learn more.
  • To install or upgrade Service Manager, SQL Server machines that host databases must be configured to allow updates. Otherwise, an error appears when Service Manager tries to create a database:
    • An error occurred while executing a customer action: _ExecuteSqlScripts. This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the corrections are made, you can retry upgrade for this role.

    • You can check the status of allow updates on SQL Server by executing the following stored procedure from within SQL Server Management Studio:

      sp_configure 'allow updates'
      

      In the results table, examine the value for "run_value". If the value of "run value" is 1, set it back to 0 with the following stored procedure, and then run Setup again.

      sp_configure 'allow updates',0 reconfigure with override
      

Next steps