System Center Service Manager에 대한 시스템 요구 사항

이 문서에서는 System Center 2022 - SM(Service Manager)에 대한 시스템 요구 사항을 자세히 설명합니다.

참고 항목

이전 릴리스와 달리 SM 2022의 경우 필수 구성 요소로 보고서 뷰어 도구 /Microsoft CLR Types for SQL Server 2014를 수동으로 설치할 필요가 없습니다.

System Center 2022 - Service Manager에 대한 시스템 요구 사항

다음 섹션에서는 SM 2022에 대한 일반적인 성능 및 확장성 지침을 설명하고 다양한 워크로드에 대한 하드웨어 구성을 권장합니다. System Center 2022는 유연하고 확장 가능하도록 빌드되었으므로 특정 시나리오에 대한 하드웨어 요구 사항은 여기에 제시된 지침과 다를 수 있습니다.

Service Manager의 용량 제한

Service Manager의 테스트된 용량 제한에 대해 알아보려면 배포 시나리오에 대한 구성을 읽어보세요.

지원되는 공존

업그레이드를 간소화하기 위해 다음 System Center 구성 요소와 함께 Service Manager 2022 커넥터를 사용할 수 있습니다.

• System Center 2019/2022 Virtual Machine 관리자
• System Center 2019/2022 Orchestrator
• System Center 2019/2022 Operations Manager
• System Center 2019/2022 Configuration Manager(마이그레이션 시나리오 중만)
• System Center Configuration Manager CB 릴리스
  • 1511, 1602, 1606, 1710, 1802, 1806 ~ 2103, 2107

하드웨어

서버	프로세서(min)	프로세서(rec)	RAM(min)	RAM(rec)	하드 드라이브 공간(min)	하드 드라이브 공간(rec)
Service Manager 관리 서버	4코어 2.66GHz CPU	4코어 2.66GHz CPU	8GB	8GB	10 GB	10 GB
Service Manager 데이터베이스	8코어 2.66GHz CPU	8코어 2.66GHz CPU	8GB	32GB	80GB	80GB
Service Manager 데이터 웨어하우스 관리 서버	4코어 2.66GHz CPU	4코어 2.66GHz CPU	8GB	16GB	10 GB	10 GB
Service Manager 데이터 웨어하우스 데이터베이스	8코어 2.66GHz CPU	8코어 2.66GHz CPU	8GB	32GB	400GB	400GB
Service Manager 콘솔	2코어 2GHz CPU	2코어 2GHz CPU	4GB	4GB	10 GB	10 GB
Service Manager 셀프 서비스 포털(독립 실행형)	4코어 2.66GHz CPU	8코어 2.66GHz CPU	8GB	16GB	80GB	80GB
Service Manager 셀프 서비스 포털 + 보조 관리 서버(권장)	8코어 2.66GHz CPU	8코어 2.66GHz CPU	16GB	32GB	80GB	80GB

소프트웨어 요구 사항

구성 요소	요구 사항
Service Manager 관리 서버	관리 서버는 Windows Server용 .NET Framework 3.5 SP1용 Data Services 업데이트 ADO.NET 필요합니다. SQL Server Native Client 관리 서버는 64비트 버전의 Windows에 설치해야 합니다.
데이터 웨어하우스 관리 서버	웨어하우스 관리 서버에는 SQL Server Native Client가 필요합니다. 데이터 웨어하우스 관리 서버는 64비트 버전의 Windows에 설치해야 합니다.
Service Manager/데이터 웨어하우스 데이터베이스	Service Manager 또는 데이터 웨어하우스 데이터베이스에는 SSRS(SQL Server Reporting Services)가 필요합니다. SQL Server 분석 관리 개체입니다. SQL Server 및 Analysis Services 데이터 정렬 설정은 Service Manager 데이터베이스, 데이터 웨어하우스 데이터베이스, Analysis Services 데이터베이스 및 Reporting Services 데이터베이스를 호스팅하는 컴퓨터에 대해 동일해야 합니다.
Service Manager 콘솔	콘솔에는 콘솔 컴퓨터에서 OLAP 데이터 큐브를 보려면 Microsoft Excel이 필요합니다. ADO.NET Windows Server용 .NET Framework 3.5 SP1용 Data Services 업데이트 SQL Server 분석 관리 개체입니다. 콘솔은 64비트 버전의 Windows에 설치할 수 있습니다.
셀프 서비스 포털	셀프 서비스 포털 서버에는 Windows 2016 서버 이상이 필요합니다. IIS 역할 및 ASP.NET 4.5를 사용하도록 설정했습니다. SQL Server 분석 관리 개체입니다. Service Manager SDK 서비스가 실행 중인 동일한 도메인에 서버 머신을 조인합니다. 기본 또는 보조 서버에서 이상적입니다.
셀프 서비스를 사용하는 컴퓨터	셀프 서비스 포털은 화면 해상도가 1024 X 768을 넘어야 합니다. 지원되는 브라우저: Microsoft Edge; Microsoft Internet Explorer 10 및 11; 모질라 파이어 폭스 42 이상; 구글 크롬 46 이상.
SQL Server Reporting Services	SSRS를 호스팅하는 컴퓨터가 데이터 웨어하우스 관리 서버를 호스트하는 동일한 컴퓨터에 없는 배포 토폴로지에서 Microsoft.EnterpriseManagement.Reporting.Code를 전역 어셈블리 캐시에 추가해야 합니다. 수동 단계에 대해 알아봅니다.

추가 참고 사항

• Operations Manager - Service Manager에는 Operations Manager 환경에서 경고 및 구성 항목을 가져올 수 있는 기능이 있습니다. 동일한 환경에서 Service Manager와 Operations Manager를 모두 설치하는 방법에 대해 알아봅니다. Operations Manager용 데이터 마트를 만들 수 있습니다.

• Configuration Manager - Service Manager는 Configuration Manager 환경에서 구성 항목을 가져올 수 있습니다.

• 네트워크 요구 사항 - 기술 문서 내에서 외부 콘텐츠를 보려면 Service Manager 콘솔을 호스트하는 컴퓨터에 직접 또는 프록시 서버를 통해 인터넷에 액세스할 수 있어야 합니다.

• SMTP 서버 - 알림 기능을 사용하고 전자 메일을 통해 인시던트를 만들려면 SMTP(Simple Mail Transfer Protocol) 서버에 액세스할 수 있어야 합니다.

• Windows 안전 모드 - Service Manager가 작동하지 않으며 Windows Server가 안전 모드로 실행되는 경우 Service Manager에서 사용하는 서비스가 시작되지 않습니다. 안전 모드에서 Service Manager 서비스를 수동으로 시작하려고 하면 서비스가 시작되지 않으며 이벤트 로그에 오류가 기록됩니다.

SQL Server 요구 사항

Microsoft SQL Server는 System Center - Service Manager에서 만드는 데이터베이스를 호스트합니다. 또한 System Center 2022 - Service Manager를 사용하려면 SSAS(SQL Server Analysis Services)가 OLAP(Microsoft Online Analytical Processing) 큐브와 함께 작동해야 합니다. System Center 2022 - Service Manager 보고를 지원하려면 SSRS(SQL Server Reporting Services)가 필요합니다.

이 정보를 사용하여 SQL Server 환경이 System Center 2022 설치 또는 업그레이드를 지원할 준비가 되었는지 평가합니다. System Center의 구성 요소를 하나 또는 여러 개 배포하는지 여부에 관계없이 이 정보를 사용합니다.

참고 항목

설치하는 동안 Service Manager 및 데이터 웨어하우스 데이터베이스를 호스트할 SQL Server를 실행하는 컴퓨터에서 SQL Server 전체 텍스트 검색을 선택합니다.

SQL Server 버전 지원

참고 항목

• SM은 SSAS 모드 테이블 형식을 지원하지 않습니다. SQL Server를 설치하는 동안 SSAS 모드를 다차원 모드로 선택합니다.
• 지원되는 SQL 버전의 경우 현재 Microsoft에서 지원하는 서비스 팩을 사용합니다.
• Service Manager 2022는 CU8 이상의 SQL 2019를 지원합니다. 그러나 SQL 2019 RTM은 지원하지 않습니다.
• SQL 2019(CU8 이상)에서 ODBC 17.3~17.10.4.1 및 MSOLEDBSQL 18.2~18.6.6을 사용합니다.

Service Manager	SQL Server 2017	누적 업데이트 8이 있는 SQL Server 2019
Service Manager/Data Warehouse 데이터베이스	•	•

참고 항목

System Center 2022 - Service Manager는 MultiSubnetFailover 매개 변수를 지원하지 않습니다. 이 매개 변수는 System Center 2022 - Service Manager 연결 문자열 사용되지 않습니다.

업데이트 허용

System Center 2022 - Service Manager를 설치하거나 업그레이드하려면 업데이트를 허용하도록 데이터베이스를 호스트하는 SQL Server를 실행하는 컴퓨터를 구성해야 합니다. 업데이트가 허용되지 않으면 System Center 2022 - Service Manager 설치가 완료되지 않으며 설치의 데이터베이스 만들기 단계에 다음 오류 메시지가 표시됩니다.

고객 작업을 실행하는 동안 오류가 발생했습니다. _ExecuteSqlScripts. 영구적으로 수정하기 전에 이 업그레이드가 실패했습니다. 업그레이드 과정에서 시스템의 원래 상태로 성공적으로 롤백했습니다. 수정이 완료되면 이 역할에 대한 업그레이드를 다시 시도할 수 있습니다.

SQL Server Management Studio 내에서 아래와 같은 저장 프로시저를 실행하면 SQL Server에서 allow updates 상태를 확인할 수 있습니다.

sp_configure 'allow updates'

결과 테이블에서 run_value 값을 검사합니다. 실행 값 값이 1이면 다음 저장 프로시저를 사용하여 다시 0으로 설정한 다음 설치 프로그램을 다시 실행합니다.

sp_configure 'allow updates',0 reconfigure with override

Service Manager 데이터베이스에 대한 AlwaysOn 가용성 그룹 고려 사항

SQL Server AlwaysOn 가용성 그룹 기능은 System Center 2022 - Service Manager에서 지원됩니다.

AlwaysOn 가용성 그룹을 사용하여 Service Manager를 설치하는 방법에 대한 자세한 내용은 여기를 참조하세요.

SQL 2017로 업그레이드

다음 단계에서는 SQL 2017로 업그레이드하는 방법에 대한 정보를 제공합니다.

참고 항목

SQL 2017로 업그레이드 프로세스는 보고 서비스를 제거합니다. 백업 보고 DB 및 암호화 키와 같은 필수 보고서를 마이그레이션해야 합니다.

다음 단계를 사용하여 SQL 2016에서 2017로 업그레이드합니다.

1. SQL 2017로 업그레이드합니다.
2. SQL 2017 Reporting Services(SSRS)를 설치하고, 보고 서비스 구성 관리자를 시작하여 기존 보고 DB를 사용하고, 암호화 키를 복원합니다. 웹 서비스 URL 및 웹 포털 URL을 구성합니다.
3. SQL 2017에 대한 업그레이드 프로세스를 시작하기 전에 서버 웹 서비스 가상 디렉터리 및 웹 포털 URL을 보고하는 데 동일한 값을 사용합니다.
4. 여기에 공유 된 세부 정보에 따라 SSRS를 구성합니다.
5. [선택 사항] CLR 엄격한 보안을 사용하도록 설정하려면 각 Service Manager 데이터베이스에서 다음 스크립트를 실행합니다. 기본적으로 SQL 2017로 업그레이드한 후에는 CLR 엄격한 보안을 사용할 수 없습니다.

SQL 2019로 업그레이드

다음 단계에서는 SQL 2019로 업그레이드하는 방법에 대한 정보를 제공합니다.

참고 항목

• SQL 2019에서 CU8(누적 업데이트 8) 이상을 사용해야 합니다.
• ODBC 17.3에서 17.10.4.1, MSOLEDBSQL 18.2~18.6.6을 사용합니다.
• SQL 2019로 업그레이드 프로세스는 보고 서비스를 제거합니다. 백업 보고 DB 및 암호화 키와 같은 필수 보고서를 마이그레이션해야 합니다.

다음 단계를 사용하여 SQL 2017에서 2019로 업그레이드합니다.

1. SQL 2019로 업그레이드합니다.
2. SQL 2019 보고 서비스(SSRS)를 설치하고, 보고 서비스 구성 관리자를 시작하여 기존 보고 DB를 사용하고, 암호화 키를 복원합니다. 웹 서비스 URL 및 웹 포털 URL을 구성합니다.
3. SQL 2019에 대한 업그레이드 프로세스를 시작하기 전에 서버 웹 서비스 가상 디렉터리 및 웹 포털 URL을 보고하는 데 동일한 값을 사용합니다.
4. 여기에 공유 된 세부 정보에 따라 SSRS를 구성합니다.
5. [선택 사항] CLR 엄격한 보안을 사용하도록 설정하려면 각 Service Manager 데이터베이스에서 다음 스크립트를 실행합니다. 기본적으로 SQL 2019로 업그레이드한 후에는 CLR 엄격한 보안을 사용할 수 없습니다.

CLR 엄격한 보안 사용

선택 사항. 다음 스크립트를 사용하여 CLR 엄격한 보안을 사용하도록 설정합니다.

-- 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

서버 운영 체제

지원되는 Windows Server 운영 체제 버전은 다음과 같습니다.

System Center 구성 요소	Windows Server 2019 Standard, Datacenter	Windows Server 2019 Server Core	Windows Server 2022 표준, 데이터 센터	Windows Server 2022 Server Core
Service Manager 관리 서버	•	•	•	•
Service Manager 데이터 웨어하우스 관리 서버	•	•	•	•
Service Manager 데이터베이스 또는 데이터 웨어하우스 데이터베이스	•	•	•	•
Service Manager 셀프 서비스 포털(HTML 5)	•	•	•	•

클라이언트 운영 체제

Service Manager 콘솔에 대해 지원되는 Windows 클라이언트 운영 체제 버전은 다음과 같습니다.

System Center 클라이언트 쪽 구성 요소	Windows Server® 2019 Standard, Datacenter Enterprise	Windows Server® 2022 Standard, Datacenter	Windows 10	Windows 11
Service Manager 콘솔	•	•	•	•

지원되는 .NET 버전

Service Manager에는 다음 버전의 .NET이 지원됩니다.

System Center 구성 요소	.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 관리 서버	•			•		•	•	•	•
Service Manager 데이터 웨어하우스 관리 서버	•			•		•	•	•	•
Service Manager 콘솔	•			•		•	•	•	•
Service Manager 셀프 서비스 포털	•			•		•	•	•	•

지원되는 PowerShell 버전

Service Manager에 대해 지원되는 PowerShell 버전은 다음과 같습니다.

System Center 구성 요소	Windows PowerShell 4.0	Windows PowerShell 5.0
Service Manager 콘솔	•	•
Service Manager 관리 서버	•	•
Service Manager 데이터 웨어하우스 관리 서버	•	•

다음 단계

• Service Manager의 정품 및 선택 버전에 대해 알아보고 180일 평가판 설치를 선택하는 것이 이 두 버전에 어떤 영향을 미치는지 알아보려면 Service Manager 버전을 검토 하세요.
• Service Manager의 테스트된 제한에 대해 알아보려면 배포 시나리오에 대한 구성을 읽어 보세요.
• Service Manager 하드웨어 성능에 대해 읽어봅니다.