重要说明
Service Provider Foundation (SPF) 在 System Center 2025 中已弃用。 但是，SPF 2022 将继续与 System Center 2025 组件配合使用。
本文详细介绍 System Center 2025 - Service Manager (SM) 的系统要求。
注意
与早期版本不同，对于 SM 2025，分析管理对象被删除。
System Center 2025 - Service Manager 的系统要求
以下部分介绍了 SM 2025 的一般性能和可伸缩性指南，并针对各种工作负荷推荐硬件配置。 由于 System Center 2025 构建为灵活且可缩放，因此特定方案的硬件要求可能与此处介绍的准则不同。
Service Manager 的容量限制
阅读部署方案的配置，了解 Service Manager 经过测试的容量限制。
支持的共存
为了帮助简化升级，可以将 Service Manager 2025 连接器与以下 System Center 组件一起使用。
- System Center 2022/2025 Virtual Machine Manager
- System Center 2022/2025 Operations Manager
- System Center 2022/2025 Configuration Manager（仅在迁移方案中）
- System Center Configuration Manager CB 版本
- 1511、1602、1606、1710、1802、1806 到 2103、2107、2111、2203、2207、2211、2303、2309、2403
硬件
| 服务器 | 处理器 (min) | 处理器 (rec) | RAM (最小值) | RAM (rec) | 硬盘空间 (min) | 硬盘空间 (rec) |
|---|---|---|---|---|---|---|
| Service Manager 管理服务器 | 四核 2.66 GHz CPU | 四核 2.66 GHz CPU | 8 GB | 8 GB | 10 GB | 10 GB |
| Service Manager 数据库 | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 32 GB | 80 GB | 80 GB |
| Service Manager 数据仓库管理服务器 | 四核 2.66 GHz CPU | 四核 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
| Service Manager 数据仓库数据库 | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 32 GB | 400 GB | 400 GB |
| Service Manager 控制台 | 2 核 2 GHz CPU | 2 核 2 GHz CPU | 4 GB | 4 GB | 10 GB | 10 GB |
| Service Manager 自助服务门户（独立） | 四核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 16 GB | 80 GB | 80 GB |
| Service Manager 自助服务门户 + 辅助管理服务器（建议） | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 16 GB | 32 GB | 80 GB | 80 GB |
软件要求
| 组件 | 要求 |
|---|---|
| Service Manager 管理服务器 | 管理服务器需要：用于 Windows Server 的 .NET Framework 3.5 SP1 的 ADO.NET Data Services 更新；SQL Server Native Client 管理服务器必须安装在 64 位版本的 Windows 上。 |
| 数据仓库管理服务器 | 仓库管理服务器需要：SQL Server Native Client 数据仓库管理服务器必须安装在 64 位版本的 Windows 上。 |
| Service Manager/数据仓库数据库 | Service Manager 或数据仓库数据库需要：SQL Server Reporting Services (SSRS)。 对于承载 Service Manager 数据库、数据仓库数据库、Analysis Services 数据库和 Reporting Services 数据库的计算机，SQL Server 和 Analysis Services 排序规则设置必须相同。 |
| Service Manager 控制台 | 控制台需要：Microsoft Excel 才能在控制台计算机上查看 OLAP 数据多维数据集；用于 Windows Server 的 .NET Framework 3.5 SP1 的 ADO.NET Data Services 更新。 可以在 64 位版本的 Windows 上安装控制台。 |
| 自助服务门户 | 自助服务门户服务器需要：Windows 2016 服务器或更高版本；已启用 IIS 角色和 ASP.NET 4.5。 将服务器计算机加入运行 Service Manager SDK 服务的同一域。 理想情况下，在主服务器或辅助服务器上。 |
| 使用自助服务的计算机 | 自助服务门户需要上述的屏幕分辨率为 1024 X 768。 支持的浏览器：Microsoft Edge 121 及更高版本；Microsoft Internet Explorer 10 和 11；Mozilla Firefox 42 及更高版本；Google Chrome 121 及更高版本。 |
| 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 控制台的计算机必须直接或通过代理服务器访问 Internet。
SMTP 服务器 - 你必须有权访问简单邮件传输协议 (SMTP) 服务器才能使用通知功能以及通过电子邮件创建事件。
Windows 安全模式 - 如果 Windows Server 在安全模式下运行，则 Service Manager 不会运行，Service Manager 使用的服务也不会启动。 如果尝试在安全模式下手动启动 Service Manager 服务，服务将无法启动并且错误将被写入事件日志中。
SQL Server 要求
Microsoft SQL Server 托管 System Center - Service Manager 创建的数据库。 此外，System Center 2025 - Service Manager 要求 SQL Server Analysis Services (SSAS) 处理 Microsoft 联机分析处理 (OLAP) 数据多维数据集。 需要 SQL Server Reporting Services (SSRS) 来支持 System Center 2025 - Service Manager 报告。
使用此信息来评估你的 SQL Server 环境是否准备好支持安装或升级到 System Center 2025。 无论你部署一个还是多个 System Center 组件，均使用此信息。
注意
在将承载 Service Manager 和数据仓库数据库的计算机（运行 SQL Server）上进行安装的过程中必须选择 SQL Server 全文搜索。
SQL Server 版本支持
注意
- SM 不支持 SSAS 模式表格。 在安装 SQL Server 期间，选择 SSAS 模式作为多维模式。
- 对于支持的 SQL 版本，请使用 Microsoft 当前支持的 Service Pack。
- Service Manager 2025 支持具有 CU8 或更高版本的 SQL 2019；但是，它不支持 SQL 2019 RTM。
- 使用 SQL 2019（CU8 或更高版本），使用 ODBC 17.3 到 17.10.6，使用 MSOLEDBSQL 18.2 到 18.7.2。
| System Center 组件 | 具有累积更新 8 的 SQL Server 2019 | SQL Server 2022 |
|---|---|---|
| Service Manager | • | • |
| 数据仓库数据库 | • | • |
注意
System Center 2025 - Service Manager 不支持 MultiSubnetFailover 参数。 System Center 2025 - Service Manager 连接字符串中不使用此参数。
允许更新
若要安装或升级到 System Center 2025 - Service Manager，运行 SQL Server 的计算机必须配置为允许更新。 如果不允许更新，则 System Center 2025 - Service Manager 安装程序将无法完成，并且在安装的创建数据库阶段会出现以下错误消息：
执行自定义操作时出错: _ExecuteSqlScripts。 在执行永久性修改之前,此升级尝试失败? 升级已经成功地回滚到系统的原始状态? 进行更正之后，你可以重试此角色升级。
通过从 SQL Server Management Studio 内执行下列存储过程，你可以在 SQL Server 上检查“ allow updates ”的状态：
sp_configure 'allow updates'
在结果表中，检查 run_value 的值。 如果 run value 的值为 1，请使用以下存储过程将其设置回 0，然后再次运行安装程序。
sp_configure 'allow updates',0 reconfigure with override
针对 Service Manager 数据库的 AlwaysOn 可用性组注意事项
System Center 2025 - Service Manager 支持 SQL Server AlwaysOn 可用性组功能。
有关使用 AlwaysOn 可用性组安装 Service Manager 的详细信息，请参阅此处。
升级到 SQL 2019
以下步骤提供有关升级到 SQL 2019 的信息。
注意
- 必须在 SQL 2019 中使用累积更新 8 (CU8) 或更高版本。
- 使用 ODBC 17.3-17.10.4.1 和 MSOLEDBSQL 18.2-18.6.6。
- 升级到 SQL 2019 的过程会卸载报告服务；确保迁移所需的报告，如备份报告数据库和加密密钥。
使用以下步骤从 SQL 2017 升级到 2019：
- 升级到 SQL 2019。
- 安装 SQL 2019 Reporting Services (SSRS)，启动 Reporting Services 配置管理器，以使用现有的报告 DB，并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
- 对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用与启动 SQL 2019 升级过程之前相同的值。
- 根据此处共享的详细信息配置 SSRS。
- [可选] 若要启用 CLR 严格安全性，请在每个 Service Manager 数据库上运行以下脚本。 默认情况下，升级到 SQL 2019 后，CLR 严格安全性被禁用。
升级到 SQL 2022
以下步骤提供有关升级到 SQL 2022 的信息。
注意
- 必须在 SQL 2022 中使用累积更新 8 (CU8) 或更高版本。
- 使用 ODBC 17.3-17.10.4.1 和 MSOLEDBSQL 18.2-18.6.6。
- 升级到 SQL 2022 的过程会卸载报告服务；确保迁移所需的报告，如备份报告数据库和加密密钥。
使用以下步骤从 SQL 2019 升级到 2022：
- 升级到 SQL 2022。
- 安装 SQL 2022 Reporting Services (SSRS)，启动 Reporting Services 配置管理器，以使用现有的报告 DB，并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
- 对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用与启动 SQL 2022 升级过程之前相同的值。
- 根据此处共享的详细信息配置 SSRS。
- [可选] 若要启用 CLR 严格安全性，请在每个 Service Manager 数据库上运行以下脚本。 默认情况下，升级到 SQL 2022 后，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 Standard、Datacenter | Windows Server 2022 Server Core | Windows Server 2025 Standard、Datacenter | Windows Server 2025 Server Core |
|---|---|---|---|---|---|---|
| Service Manager 管理服务器 | • | • | • | • | • | • |
| Service Manager 数据仓库管理服务器 | • | • | • | • | • | • |
| Service Manager 数据库或数据仓库数据库 | • | • | • | • | • | • |
| Service Manager 自助服务门户 (HTML 5) | • | • | • | • | • | • |
客户端操作系统
Service Manager 控制台支持以下版本的 Windows 客户端操作系统。
| System Center 客户端组件 | Windows Server® 2019 标准版、数据中心企业版 | Windows Server® 2022 Standard、Datacenter Enterprise | Windows Server® 2025 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 数据仓库管理服务器 | • | • |
本文详细介绍 System Center 2022 - Service Manager (SM) 的系统要求。
注意
与早期版本不同，对于 SM 2022，无需手动安装 Report Viewer 工具 /Microsoft CLR Types for SQL Server 2014 作为先决条件。
System Center 2022 - Service Manager 的系统要求
以下部分介绍了 SM 2022 的一般性能和可伸缩性指南，并针对各种工作负荷推荐硬件配置。 由于 System Center 2022 构建为灵活且可缩放，因此特定方案的硬件要求可能与此处介绍的准则不同。
Service Manager 的容量限制
阅读部署方案的配置，了解 Service Manager 经过测试的容量限制。
支持的共存
为了帮助简化升级，可以将 Service Manager 2022 连接器与以下 System Center 组件一起使用。
- System Center 2019/2022 Virtual Machine Manager
- System Center 2019/2022 Orchestrator (系统中心2019/2022编排器)
- 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 (最小值) | RAM (rec) | 硬盘空间 (min) | 硬盘空间 (rec) |
|---|---|---|---|---|---|---|
| Service Manager 管理服务器 | 四核 2.66 GHz CPU | 四核 2.66 GHz CPU | 8 GB | 8 GB | 10 GB | 10 GB |
| Service Manager 数据库 | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 32 GB | 80 GB | 80 GB |
| Service Manager 数据仓库管理服务器 | 四核 2.66 GHz CPU | 四核 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
| Service Manager 数据仓库数据库 | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 32 GB | 400 GB | 400 GB |
| Service Manager 控制台 | 2 核 2 GHz CPU | 2 核 2 GHz CPU | 4 GB | 4 GB | 10 GB | 10 GB |
| Service Manager 自助服务门户（独立） | 四核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 16 GB | 80 GB | 80 GB |
| Service Manager 自助服务门户 + 辅助管理服务器（建议） | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 16 GB | 32 GB | 80 GB | 80 GB |
软件要求
| 组件 | 要求 |
|---|---|
| Service Manager 管理服务器 | 管理服务器需要：用于 Windows Server 的 .NET Framework 3.5 SP1 的 ADO.NET Data Services 更新；SQL Server Native Client 管理服务器必须安装在 64 位版本的 Windows 上。 |
| 数据仓库管理服务器 | 仓库管理服务器需要：SQL Server Native Client 数据仓库管理服务器必须安装在 64 位版本的 Windows 上。 |
| Service Manager/数据仓库数据库 | Service Manager 或数据仓库数据库需要：SQL Server Reporting Services (SSRS)；SQL Server 分析管理对象。 对于承载 Service Manager 数据库、数据仓库数据库、Analysis Services 数据库和 Reporting Services 数据库的计算机，SQL Server 和 Analysis Services 排序规则设置必须相同。 |
| Service Manager 控制台 | 控制台需要：Microsoft Excel 才能在控制台计算机上查看 OLAP 数据多维数据集；用于 Windows Server 的 .NET Framework 3.5 SP1 的 ADO.NET 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；Mozilla Firefox 42 及更高版本；Google Chrome 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 控制台的计算机必须直接或通过代理服务器访问 Internet。
SMTP 服务器 - 你必须有权访问简单邮件传输协议 (SMTP) 服务器才能使用通知功能以及通过电子邮件创建事件。
Windows 安全模式 - 如果 Windows Server 在安全模式下运行，则 Service Manager 不会运行，Service Manager 使用的服务也不会启动。 如果尝试在安全模式下手动启动 Service Manager 服务，服务将无法启动并且错误将被写入事件日志中。
SQL Server 要求
Microsoft SQL Server 托管 System Center - Service Manager 创建的数据库。 此外，System Center 2022 - Service Manager 要求 SQL Server Analysis Services (SSAS) 处理 Microsoft 联机分析处理 (OLAP) 数据多维数据集。 需要 SQL Server Reporting Services (SSRS) 来支持 System Center 2022 - Service Manager 报告。
使用此信息来评估你的 SQL Server 环境是否准备好支持安装或升级到 System Center 2022。 无论你部署一个还是多个 System Center 组件，均使用此信息。
注意
在将承载 Service Manager 和数据仓库数据库的计算机（运行 SQL Server）上进行安装的过程中必须选择 SQL Server 全文搜索。
SQL Server 版本支持
注意
- SM 不支持 SSAS 模式表格。 在安装 SQL Server 期间，选择 SSAS 模式作为多维模式。
- 对于支持的 SQL 版本，请使用 Microsoft 当前支持的 Service Pack。
- 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/数据仓库数据库 | • | • |
注意
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 的值。 如果 run value 的值为 1，请使用以下存储过程将其设置回 0，然后再次运行安装程序。
sp_configure 'allow updates',0 reconfigure with override
针对 Service Manager 数据库的 AlwaysOn 可用性组注意事项
System Center 2022 - Service Manager 支持 SQL Server AlwaysOn 可用性组功能。
有关使用 AlwaysOn 可用性组安装 Service Manager 的详细信息，请参阅此处。
升级到 SQL 2017
以下步骤提供有关升级到 SQL 2017 的信息。
注意
升级到 SQL 2017 的过程会卸载报告服务；确保迁移所需的报告，如备份报告数据库和加密密钥。
使用以下步骤从 SQL 2016 升级到 2017：
- 升级到 SQL 2017。
- 安装 SQL 2017 Reporting Services (SSRS)，启动 Reporting Services 配置管理器，以使用现有的报告 DB，并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
- 对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用与启动 SQL 2017 升级过程之前相同的值。
- 根据此处共享的详细信息配置 SSRS。
- [可选] 若要启用 CLR 严格安全性，请在每个 Service Manager 数据库上运行以下脚本。 默认情况下，升级到 SQL 2017 后，CLR 严格安全性被禁用。
升级到 SQL 2019
以下步骤提供有关升级到 SQL 2019 的信息。
注意
- 必须在 SQL 2019 中使用累积更新 8 (CU8) 或更高版本。
- 使用 ODBC 17.3-17.10.4.1 和 MSOLEDBSQL 18.2-18.6.6。
- 升级到 SQL 2019 的过程会卸载报告服务；确保迁移所需的报告，如备份报告数据库和加密密钥。
使用以下步骤从 SQL 2017 升级到 2019：
- 升级到 SQL 2019。
- 安装 SQL 2019 Reporting Services (SSRS)，启动 Reporting Services 配置管理器，以使用现有的报告 DB，并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
- 对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用与启动 SQL 2019 升级过程之前相同的值。
- 根据此处共享的详细信息配置 SSRS。
- [可选] 若要启用 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 Standard、Datacenter | Windows Server 2022 Server Core |
|---|---|---|---|---|
| Service Manager 管理服务器 | • | • | • | • |
| Service Manager 数据仓库管理服务器 | • | • | • | • |
| Service Manager 数据库或数据仓库数据库 | • | • | • | • |
| Service Manager 自助服务门户 (HTML 5) | • | • | • | • |
客户端操作系统
Service Manager 控制台支持以下版本的 Windows 客户端操作系统。
| System Center 客户端组件 | Windows Server® 2019 标准版、数据中心企业版 | 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 数据仓库管理服务器 | • | • |
本文详细介绍 System Center 2019 - Service Manager (SM) 的系统要求。
System Center 2019 - Service Manager 的系统要求
以下部分介绍了 SM 2019 的一般性能和可伸缩性指南，并针对各种工作负荷推荐硬件配置。 由于 System Center 2019 构建为灵活且可缩放，因此特定方案的硬件要求可能与此处介绍的准则不同。
Service Manager 的容量限制
阅读部署方案的配置，了解 Service Manager 经过测试的容量限制。
支持的共存
为了帮助简化升级，可以将 Service Manager 2019 连接器与以下 System Center 组件一起使用。
- System Center 2016/2019 Virtual Machine Manager
- System Center 2016/2019 Orchestrator
- System Center 2016/2019 Operations Manager
- System Center 2016 Configuration Manager（仅在迁移方案中）
- System Center Configuration Manager CB 版本
- 1511、1602、1606、1710 和 1802（Service Manager 2019 RTM 支持）
- 1806 到 2103、2107（Service Manager 2019 UR2 及更高版本支持）
硬件
| 服务器 | 处理器 (min) | 处理器 (rec) | RAM (最小值) | RAM (rec) | 硬盘空间 (min) | 硬盘空间 (rec) |
|---|---|---|---|---|---|---|
| Service Manager 管理服务器 | 四核 2.66 GHz CPU | 四核 2.66 GHz CPU | 8 GB | 8 GB | 10 GB | 10 GB |
| Service Manager 数据库 | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 32 GB | 80 GB | 80 GB |
| Service Manager 数据仓库管理服务器 | 四核 2.66 GHz CPU | 四核 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
| Service Manager 数据仓库数据库 | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 32 GB | 400 GB | 400 GB |
| Service Manager 控制台 | 2 核 2 GHz CPU | 2 核 2 GHz CPU | 4 GB | 4 GB | 10 GB | 10 GB |
| Service Manager 自助服务门户（独立） | 四核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 16 GB | 80 GB | 80 GB |
| Service Manager 自助服务门户 + 辅助管理服务器（建议） | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 16 GB | 32 GB | 80 GB | 80 GB |
软件要求
| 组件 | 要求 |
|---|---|
| Service Manager 管理服务器 | 管理服务器需要：用于 Windows Server 的 .NET Framework 3.5 SP1 的 ADO.NET Data Services 更新；SQL Server Native Client；Service Manager 媒体提供的 Microsoft Report Viewer Redistributable。 管理服务器必须安装在 64 位版本的 Windows 上。 |
| 数据仓库管理服务器 | 仓库管理服务器需要：SQL Server Native Client 数据仓库管理服务器必须安装在 64 位版本的 Windows 上。 |
| Service Manager/数据仓库数据库 | Service Manager 或数据仓库数据库需要：SQL Server Reporting Services (SSRS)；SQL Server 分析管理对象。 对于承载 Service Manager 数据库、数据仓库数据库、Analysis Services 数据库和 Reporting Services 数据库的计算机，SQL Server 和 Analysis Services 排序规则设置必须相同。 |
| Service Manager 控制台 | 控制台需要：Microsoft Report Viewer Redistributable（可在 System Center 媒体上获取）；Microsoft Excel 才能在控制台计算机上查看 OLAP 数据多维数据集；用于 Windows Server 的 .NET Framework 3.5 SP1 的 ADO.NET Data Services 更新；SQL Server 分析管理对象。 控制台可安装在 Windows 的 32 位和 64 位版本上。 |
| 自助服务门户 | 自助服务门户服务器需要：Windows 2012 R2 服务器或更高版本；已启用 IIS 角色和 ASP.NET 4.5；SQL Server 分析管理对象。 将服务器计算机加入运行 Service Manager SDK 服务的同一域。 理想情况下，在主服务器或辅助服务器上。 |
| 使用自助服务的计算机 | 自助服务门户需要上述的屏幕分辨率为 1024 X 768。 支持的浏览器：Microsoft Edge；Microsoft Internet Explorer 10 和 11；Mozilla Firefox 42 及更高版本；Google Chrome 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 控制台的计算机必须直接或通过代理服务器访问 Internet。
SMTP 服务器 - 你必须有权访问简单邮件传输协议 (SMTP) 服务器才能使用通知功能以及通过电子邮件创建事件。
Windows 安全模式 - 如果 Windows Server 在安全模式下运行，则 Service Manager 不会运行，Service Manager 使用的服务也不会启动。 如果尝试在安全模式下手动启动 Service Manager 服务，服务将无法启动并且错误将被写入事件日志中。
SQL Server 要求
Microsoft SQL Server 托管 System Center - Service Manager 创建的数据库。 此外，System Center 2019 - Service Manager 要求 SQL Server Analysis Services (SSAS) 处理 Microsoft 联机分析处理 (OLAP) 数据多维数据集。 需要 SQL Server Reporting Services (SSRS) 来支持 System Center 2019 - Service Manager 报告。
使用此信息来评估你的 SQL Server 环境是否准备好支持安装或升级到 System Center 2019。 无论你部署一个还是多个 System Center 组件，均使用此信息。
注意
在将承载 Service Manager 和数据仓库数据库的计算机（运行 SQL Server）上进行安装的过程中必须选择 SQL Server 全文搜索。
SQL Server 版本支持
注意
- SM 不支持 SSAS 模式表格。 在安装 SQL Server 期间，选择 SSAS 模式作为多维模式。
- 对于支持的 SQL 版本，请使用 Microsoft 当前支持的 Service Pack。
- Service Manager 2019 支持具有 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 2016 和 SP | SQL Server 2017 | 具有累积更新 8 的 SQL Server 2019 |
|---|---|---|---|
| Service Manager/数据仓库数据库 | • | • | • |
注意
System Center 2019 - Service Manager 不支持 MultiSubnetFailover 参数。 System Center 2019 - Service Manager 连接字符串中不使用此参数。
允许更新
若要安装或升级到 System Center 2019 - Service Manager，运行 SQL Server 的计算机必须配置为允许更新。 如果不允许更新，则 System Center 2019 - Service Manager 安装程序将无法完成，并且在安装的创建数据库阶段会出现以下错误消息：
执行自定义操作时出错: _ExecuteSqlScripts。 在执行永久性修改之前,此升级尝试失败? 升级已经成功地回滚到系统的原始状态? 进行更正之后，你可以重试此角色升级。
通过从 SQL Server Management Studio 内执行下列存储过程，你可以在 SQL Server 上检查“ allow updates ”的状态：
sp_configure 'allow updates'
在结果表中，检查 run_value 的值。 如果 run value 的值为 1，请使用以下存储过程将其设置回 0，然后再次运行安装程序。
sp_configure 'allow updates',0 reconfigure with override
针对 Service Manager 数据库的 AlwaysOn 可用性组注意事项
System Center 2019 - Service Manager 支持 SQL Server AlwaysOn 可用性组功能。
有关使用 AlwaysOn 可用性组安装 Service Manager 的详细信息，请参阅此处。
升级到 SQL 2017
以下步骤提供有关升级到 SQL 2017 的信息。
注意
升级到 SQL 2017 的过程会卸载报告服务；确保迁移所需的报告，如备份报告数据库和加密密钥。
使用以下步骤从 SQL 2016 升级到 2017：
- 升级到 SQL 2017。
- 安装 SQL 2017 Reporting Services (SSRS)，启动 Reporting Services 配置管理器，以使用现有的报告 DB，并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
- 对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用与启动 SQL 2017 升级过程之前相同的值。
- 根据此处共享的详细信息配置 SSRS。
- [可选] 若要启用 CLR 严格安全性，请在每个 Service Manager 数据库上运行以下脚本。 默认情况下，升级到 SQL 2017 后，CLR 严格安全性被禁用。
升级到 SQL 2019
以下步骤提供有关升级到 SQL 2019 的信息。
注意
- 必须在 SQL 2019 中使用累积更新 8 (CU8) 或更高版本。
- 使用 ODBC 17.3-17.10.4.1 和 MSOLEDBSQL 18.2-18.6.6。
- 升级到 SQL 2019 的过程会卸载报告服务；确保迁移所需的报告，如备份报告数据库和加密密钥。
使用以下步骤从 SQL 2017 升级到 2019：
- 升级到 SQL 2019。
- 安装 SQL 2019 Reporting Services (SSRS)，并启动 Reporting Services 配置管理器，以使用现有的报告 DB，并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
- 对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用与启动 SQL 2019 升级过程之前相同的值。
- 根据此处共享的详细信息配置 SSRS。
- [可选] 若要启用 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 2016 Standard、Datacenter | Windows Server 2016 Server Core | Windows Server 2019 Standard、Datacenter | Windows Server 2019 Server Core |
|---|---|---|---|---|
| Service Manager 管理服务器 | • | • | • | • |
| Service Manager 数据仓库管理服务器 | • | • | • | • |
| Service Manager 数据库或数据仓库数据库 | • | • | • | • |
| Service Manager 自助服务门户 (HTML 5) | • | • | • | • |
客户端操作系统
Service Manager 控制台支持以下版本的 Windows 客户端操作系统。
| System Center 客户端组件 | Windows Server® 2016 Standard、Datacenter Enterprise | Windows Server® 2019 Standard、Data Center | Windows 10 | Windows 11 |
|---|---|---|---|---|
| Service Manager 控制台 | • | • | • | • |
支持的 .NET 版本
Service Manager 支持以下版本的 .NET。
注意
System Center Service Manager 2019 UR4 及更高版本支持 .NET 4.8
| 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 2.0 | Windows PowerShell 3.0 | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|---|---|
| Service Manager 控制台 | • | • | ||
| Service Manager 管理服务器 | • | • | ||
| Service Manager 数据仓库管理服务器 | • | • |
本文详细介绍 System Center 2016 - Service Manager (SM) 的系统要求。
System Center 2016 - Service Manager 的系统要求
以下部分介绍了 SM 2016 的一般性能和可伸缩性指南，并针对各种工作负荷推荐硬件配置。 由于 System Center 2016 构建为灵活且可缩放，因此特定方案的硬件要求可能与此处介绍的准则不同。
Service Manager 的容量限制
了解各种 Service Manager 部署方案经过测试的容量限制。
支持的共存
为了帮助简化升级，可以将以下 Service Manager 2016 连接器与 System Center 2012 R2 组件一起使用。
- System Center 2012 R2 虚拟机管理器
- System Center 2012 R2 Orchestrator
- 系统中心 2012 R2 操作管理器
- System Center 2012 R2 Configuration Manager 配置管理器
- System Center Configuration Manager (SCCM) CB 版本 - 1511、1602、1606 和 1710。
- UR5 支持 1802
- UR9 和 UR10 支持从 1806 到 2103。 但是，SCCM 支持的设备的大小有一个限制，应该小于 2 PB。
- UR10 支持 2107
硬件
| 服务器 | 处理器 (min) | 处理器 (rec) | RAM (最小值) | RAM (rec) | 硬盘空间 (min) | 硬盘空间 (rec) |
|---|---|---|---|---|---|---|
| Service Manager 管理服务器 | 四核 2.66 GHz CPU | 四核 2.66 GHz CPU | 8 GB | 8 GB | 10 GB | 10 GB |
| Service Manager 数据库 | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 32 GB | 80 GB | 80 GB |
| Service Manager 数据仓库管理服务器 | 四核 2.66 GHz CPU | 四核 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
| Service Manager 数据仓库数据库 | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 32 GB | 400 GB | 400 GB |
| Service Manager 控制台 | 2 核 2 GHz CPU | 2 核 2 GHz CPU | 4 GB | 4 GB | 10 GB | 10 GB |
| Service Manager 自助服务门户（独立） | 四核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 8 GB | 16 GB | 80 GB | 80 GB |
| Service Manager 自助服务门户 + 辅助管理服务器（建议） | 8 核 2.66 GHz CPU | 8 核 2.66 GHz CPU | 16 GB | 32 GB | 80 GB | 80 GB |
服务器操作系统
支持以下版本的 Windows Server 操作系统。
| System Center 组件 | Windows Server 2012 Standard、Datacenter | Windows Server 2012 R2 Standard、Datacenter | Windows Server 2016 | Windows Server 2016（具有桌面体验的服务器） | Windows Server 2016 Nano Server |
|---|---|---|---|---|---|
| Service Manager 管理服务器 | • | • | • | ||
| Service Manager 数据仓库管理服务器 | • | • | • | ||
| Service Manager 数据库或数据仓库数据库 | • | • | • | ||
| Service Manager 自助服务门户 (HTML 5) | • | • | • |
客户端操作系统
Service Manager 控制台支持以下版本的 Windows 客户端操作系统。
| System Center 客户端组件 | Windows® 7 | Windows® 8 | Windows® 8.1 | Windows Server® 2008 R2 SP1 | Windows Server® 2012 | Windows Server® 2012 R2 Standard、Datacenter | Windows 10 企业版 | Windows Server® 2016 Standard、Datacenter |
|---|---|---|---|---|---|---|---|---|
| Service Manager 控制台 | • | • | • | • | • | • |
.NET 版本
Service Manager 支持以下版本的 .NET。
| System Center 2016 组件 | .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 管理服务器 | • | • | • | • | • | |||
| Service Manager 数据仓库管理服务器 | • | • | • | • | • | |||
| Service Manager 控制台 | • | • | • | • | • | |||
| Service Manager 自助服务门户 | • | • | • | • | • |
支持的 PowerShell 版本
Service Manager 支持以下版本的 PowerShell。
| System Center 组件 | Windows PowerShell 2.0 | Windows PowerShell 3.0 | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|---|---|
| Service Manager 控制台 | • | • | ||
| Service Manager 管理服务器 | • | • | ||
| Service Manager 数据仓库管理服务器 | • | • |
软件要求
| 组件 | 要求 |
|---|---|
| Service Manager 管理服务器 | 管理服务器需要：用于 Windows Server 的 .NET Framework 3.5 SP1 的 ADO.NET Data Services 更新；SQL Server Native Client；Service Manager 媒体提供的 Microsoft Report Viewer Redistributable。 管理服务器必须安装在 64 位版本的 Windows 上。 |
| 数据仓库管理服务器 | 仓库管理服务器需要：SQL Server Native Client 数据仓库管理服务器必须安装在 64 位版本的 Windows 上。 |
| Service Manager/数据仓库数据库 | Service Manager 或数据仓库数据库需要：SQL Server Reporting Services (SSRS)；SQL Server 分析管理对象。 对于承载 Service Manager 数据库、数据仓库数据库、Analysis Services 数据库和 Reporting Services 数据库的计算机，SQL Server 和 Analysis Services 排序规则设置必须相同。 |
| Service Manager 控制台 | 控制台需要：Microsoft Report Viewer Redistributable（可在 System Center 媒体上获取）；Microsoft Excel 才能在控制台计算机上查看 OLAP 数据多维数据集；用于 Windows Server 的 .NET Framework 3.5 SP1 的 ADO.NET Data Services 更新；SQL Server 分析管理对象。 控制台可安装在 Windows 的 32 位和 64 位版本上。 |
| 自助服务门户 | 自助服务门户服务器需要：Windows 2012 R2 服务器或更高版本；已启用 IIS 角色和 ASP.NET 4.5；SQL Server 分析管理对象 将服务器计算机加入运行 Service Manager SDK 服务的同一域。 理想情况下，在主服务器或辅助服务器上。 |
| 使用自助服务的计算机 | 自助服务门户需要上述的屏幕分辨率为 1024 X 768。 支持的浏览器：Microsoft Edge；Microsoft Internet Explorer 10 和 11；Mozilla Firefox 42 及更高版本；Google Chrome 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 控制台的计算机必须直接或通过代理服务器访问 Internet。 |
| SMTP 服务器 | 你必须有权访问简单邮件传输协议 (SMTP) 服务器才能使用通知功能以及通过电子邮件创建事件。 |
| Windows 安全模式 | 如果 Windows Server 在安全模式下运行，则 Service Manager 不会运行，Service Manager 使用的服务也不会启动。 如果尝试在安全模式下手动启动 Service Manager 服务，服务将无法启动并且错误将被写入事件日志中。 |
Microsoft SQL Server 托管 System Center 2016 - Service Manager 创建的数据库。 此外，System Center 2016 - Service Manager 要求 SQL Server Analysis Services (SSAS) 处理 Microsoft 联机分析处理 (OLAP) 数据多维数据集。 需要 SQL Server Reporting Services (SSRS) 来支持 System Center 2016 - Service Manager 报告。
使用此信息来评估你的 SQL Server 环境是否准备好支持安装或升级到 System Center 2016。 无论你部署一个还是多个 System Center 组件，均使用此信息。
SQL Server 版本
下表汇总了对 SQL Server 64 位企业版和标准版的支持。
注意
对于支持的 SQL 版本，请使用 Microsoft 当前支持的 Service Pack。
| Service Manager | SQL Server 2012 | SQL Server 2014 和 SP | SQL Server 2016 和 SP |
|---|---|---|---|
| Service Manager/数据仓库数据库 | • | • |
- System Center 2016 - Service Manager 不支持设置 MultiSubnetFailover 参数。 Service Manager 连接字符串中不使用此参数。
- System Center 2016 - Service Manager 支持 SQL Server AlwaysOn 可用性组。 了解详细信息。
- 要安装或升级 Service Manager，承载数据库的 SQL Server 计算机必须配置为允许更新。 否则，当 Service Manager 尝试创建数据库时会出现错误：
执行自定义操作时出错: _ExecuteSqlScripts。 在执行永久性修改之前,此升级尝试失败? 升级已经成功地回滚到系统的原始状态? 进行更正之后，你可以重试此角色升级。
通过从 SQL Server Management Studio 内执行下列存储过程，你可以在 SQL Server 上检查“ allow updates ”的状态：
sp_configure 'allow updates'在结果表中,检查“run_value”的值? 如果“run value”的值为 1,请使用以下存储过程将其设置回 0,然后再次运行安装程序?
sp_configure 'allow updates',0 reconfigure with override
后续步骤
- 若要了解 Service Manager 的零售版和正式版，以及选择 180 天评估安装对这两个版本有何影响，请查看 Service Manager 版本。
- 若要了解 Service Manager 经过测试的限制，请阅读部署方案的配置。
- 了解 Service Manager 硬件性能。