System Center Service Manager 的系统要求

本文详细介绍 System Center 2022 - Service Manager(SM)的系统要求。

注意

与早期版本不同,对于 SM 2022,无需手动安装报表查看器工具 /Microsoft SQL Server 2014 的 CLR 类型作为先决条件。

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
  • System Center 2019/2022 Operations Manager
  • System Center 2019/2022 Configuration Manager(仅在迁移方案中)
  • System Center Configuration Manager CB 版本
    • 1511、1602、1606、1710、1802、1806 到 2103、2107

硬件

服务器 处理器 (min) 处理器 (rec) RAM (min) RAM (rec) 硬盘空间 (min) 硬盘空间 (rec)
Service Manager 管理服务器 四核 2.66 GHz CPU 四核 2.66 GHz CPU 8 GB 8 GB 10 GB 10GB
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 10GB
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 10GB
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 管理服务器 管理服务器需要: ADO.NET 适用于 Windows Server 的 .NET Framework 3.5 SP1 的 Data Services 更新;SQL Server Native 客户端

管理服务器必须安装在 64 位版本的 Windows 上。
数据仓库管理服务器 仓库管理服务器需要:SQL Server Native 客户端

数据仓库管理服务器必须安装在 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 数据多维数据集;ADO.NET 适用于 Windows Server 的 .NET Framework 3.5 SP1 的 Data Services 更新;SQL Server 分析管理对象。

可以在 64 位版本的 Windows 上安装控制台。
自助服务门户 自助服务门户服务器需要:Windows 2016 服务器或更高版本;已启用 IIS 角色并 ASP.NET 4.5;SQL Server 分析管理对象。

将服务器计算机加入运行 Service Manager SDK 服务的同一域。 理想情况下,在主服务器或辅助服务器上。
使用自助服务的计算机 自助服务门户需要上述的屏幕分辨率为 1024 X 768。

支持的浏览器:Microsoft Edge;Microsoft Internet Explorer 10 和 11;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 安全模式 - Service Manager 不会运行,如果 Windows Server 以安全模式运行,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 的一个或多个组件,都使用此信息。

注意

在安装过程中,在运行 SQL Server 的计算机上选择 SQL Server 全文搜索 ,该计算机将托管 Service Manager 和数据仓库数据库。

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的值。 如果运行值为 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 会卸载 Reporting Services;确保迁移所需的报告,例如备份报告数据库和加密密钥。

使用以下步骤从 SQL 2016 升级到 2017

  1. 升级到 SQL 2017。
  2. 安装 SQL 2017 Reporting Services (SSRS),启动 Reporting Services 配置管理器以使用现有的报告数据库,并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
  3. 在启动 SQL 2017 升级过程之前,对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用相同的值。
  4. 根据此处共享的详细信息配置 SSRS。
  5. [可选] 若要启用 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 会卸载 Reporting Services;确保迁移所需的报告,例如备份报告数据库和加密密钥。

使用以下步骤从 SQL 2017 升级到 2019

  1. 升级到 SQL 2019。
  2. 安装 SQL 2019 Reporting Services (SSRS),启动 Reporting Services 配置管理器以使用现有的报告数据库,并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
  3. 在启动 SQL 2019 升级过程之前,对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用相同的值。
  4. 根据此处共享的详细信息配置 SSRS。
  5. [可选] 若要启用 CLR 严格安全性,请在每个 Service Manager 数据库上运行以下 脚本 。 默认情况下,升级到 SQL 2019 后,会禁用 CLR 严格安全性。

启用 CLR 严格安全性

可选。 使用以下脚本启用 CLR 严格安全性。

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

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

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

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

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

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

服务器操作系统

支持以下版本的 Windows Server 操作系统。

System Center 组件 Windows Server 2019 Standard、Datacenter Windows Server 2019 Server Core Windows Server 2022 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 Standard、Datacenter Enterprise Windows Server® 2022 Standard、Datacenter Windows 10 Windows 11
Service Manager 控制台

支持的 .NET 版本

Service Manager 支持以下版本的 .NET。

System Center 组件 .NET 3.5 SP1 .NET 4 .NET 4.5 .NET 4.5.1 .Net 4.5.2 .NET 4.6 .NET 4.6.1 .NET 4.7 .NET 4.8
Service Manager 管理服务器
Service Manager 数据仓库管理服务器
Service Manager 控制台
Service Manager 自助服务门户

支持的 PowerShell 版本

Service Manager 支持以下版本的 PowerShell。

System Center 组件 Windows PowerShell 4.0 Windows PowerShell 5.0
Service Manager 控制台
Service Manager 管理服务器
Service Manager 数据仓库管理服务器

本文详细介绍 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 (min) RAM (rec) 硬盘空间 (min) 硬盘空间 (rec)
Service Manager 管理服务器 四核 2.66 GHz CPU 四核 2.66 GHz CPU 8 GB 8 GB 10 GB 10GB
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 10GB
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 10GB
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 管理服务器 管理服务器需要: ADO.NET 适用于 Windows Server 的 .NET Framework 3.5 SP1 的 Data Services 更新;SQL Server Native 客户端;Microsoft Service Manager 媒体提供的报表查看器可再发行组件。

管理服务器必须安装在 64 位版本的 Windows 上。
数据仓库管理服务器 仓库管理服务器需要:SQL Server Native 客户端

数据仓库管理服务器必须安装在 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报表查看器可再发行组件(在 System Center 媒体上可用):Microsoft Excel,以便在控制台计算机上查看 OLAP 数据多维数据集;ADO.NET Windows Server 的 Data Services Update for.NET Framework 3.5 SP1;SQL Server 分析管理对象。

可以在 32 位和 64 位版本的 Windows 上安装控制台。
自助服务门户 自助服务门户服务器需要: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 安全模式 - Service Manager 不会运行,如果 Windows Server 以安全模式运行,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 的一个或多个组件,都使用此信息。

注意

在安装过程中,在运行 SQL Server 的计算机上选择 SQL Server 全文搜索 ,该计算机将托管 Service Manager 和数据仓库数据库。

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的值。 如果运行值为 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 会卸载 Reporting Services;确保迁移所需的报告,例如备份报告数据库和加密密钥。

使用以下步骤从 SQL 2016 升级到 2017

  1. 升级到 SQL 2017。
  2. 安装 SQL 2017 Reporting Services (SSRS),启动 Reporting Services 配置管理器以使用现有的报告数据库,并还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
  3. 在启动 SQL 2017 升级过程之前,对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用相同的值。
  4. 根据此处共享的详细信息配置 SSRS。
  5. [可选] 若要启用 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 会卸载 Reporting Services;确保迁移所需的报告,例如备份报告数据库和加密密钥。

使用以下步骤从 SQL 2017 升级到 2019

  1. 升级到 SQL 2019。
  2. 安装 SQL 2019 Reporting Services (SSRS),并启动 Reporting Services 配置管理器以使用现有的报告数据库,还原加密密钥。 配置 Web 服务 URL 和 Web 门户 URL。
  3. 在启动 SQL 2019 升级过程之前,对报表服务器 Web 服务虚拟目录和 Web 门户 URL 使用相同的值。
  4. 根据此处共享的详细信息配置 SSRS。
  5. [可选] 若要启用 CLR 严格安全性,请在每个 Service Manager 数据库上运行以下 脚本 。 默认情况下,升级到 SQL 2019 后,会禁用 CLR 严格安全性。

启用 CLR 严格安全性

可选。 使用以下脚本启用 CLR 严格安全性。

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

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

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

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

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

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

服务器操作系统

支持以下版本的 Windows Server 操作系统。

System Center 组件 Windows Server 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,数据中心 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 数据仓库管理服务器

重要

此版本的 Service Manager 已终止支持。 建议 升级到 Service Manager 2022

本文详细介绍 System Center 1801 - Service Manager(SM)的系统要求。

本文详细介绍 System Center 2016 - Service Manager(SM)的系统要求。

System Center 1801 - Service Manager 的系统要求

以下部分介绍了 SM 1801 的一般性能和可伸缩性指南,并建议针对各种工作负荷配置硬件。 由于 System Center 1801 构建为灵活且可缩放,因此特定方案的硬件要求可能与此处提供的准则不同。

Service Manager 的容量限制

阅读 有关部署方案的 配置,了解 Service Manager 测试的容量限制。

支持的共存

为了帮助简化升级,可以将 Service Manager 1801 连接器与以下 System Center 组件一起使用。

  • System Center 2012 R2/2016 Virtual Machine Manager
  • System Center 2012 R2/2016 Orchestrator
  • System Center 2012 R2/2016 Operations Manager
  • System Center 2012 R2/2016 Configuration Manager
  • System Center Configuration Manager CB 版本 - 1511、1602、1606 和 1710

硬件

服务器 处理器 (min) 处理器 (rec) RAM (min) RAM (rec) 硬盘空间 (min) 硬盘空间 (rec)
Service Manager 管理服务器 四核 2.66 GHz CPU 四核 2.66 GHz CPU 8 GB 8 GB 10 GB 10GB
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 10GB
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 10GB
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 管理服务器 管理服务器需要: ADO.NET 适用于 Windows Server 的 .NET Framework 3.5 SP1 的 Data Services 更新;SQL Server Native 客户端;Microsoft Service Manager 媒体提供的报表查看器可再发行组件。

管理服务器必须安装在 64 位版本的 Windows 上。
数据仓库管理服务器 仓库管理服务器需要:SQL Server Native 客户端

数据仓库管理服务器必须安装在 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报表查看器可再发行组件(在 System Center 媒体上可用):Microsoft Excel,以便在控制台计算机上查看 OLAP 数据多维数据集;ADO.NET 适用于 Windows Server 的 .NET Framework 3.5 SP1 的 Data Services 更新;SQL Server 分析管理对象。

可以在 32 位和 64 位版本的 Windows 上安装控制台。
自助服务门户 自助服务门户服务器需要: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 安全模式 - Service Manager 不会运行,如果 Windows Server 以安全模式运行,Service Manager 使用的服务不会启动。 如果在安全模式下尝试手动启动 Service Manager 服务,则服务无法启动,并且错误将写入事件日志中。

SQL Server 要求

Microsoft SQL Server 托管 System Center - Service Manager 创建的数据库。 此外,System Center 1801 - Service Manager 要求 SQL Server Analysis Services (SSAS) 处理Microsoft联机分析处理(OLAP)多维数据集。 需要 SQL Server Reporting Services (SSRS) 才能支持 System Center 1801 - Service Manager 报告。

使用此信息来评估 SQL Server 环境是否准备好支持安装或升级到 System Center 1801。 无论是部署 System Center 的一个或多个组件,都使用此信息。

SQL Server 版本支持

注意

对于支持的 SQL 版本,请使用当前受Microsoft支持的 Service Pack。

Service Manager SQL Server 2012 SQL Server 2014 和 SP SQL Server 2016 和 SP
Service Manager/数据仓库数据库

注意

System Center 1801 - Service Manager 不支持 MultiSubnetFailover 参数。 System Center 1801 - Service Manager 连接字符串 中不使用此参数。

允许更新

若要安装或升级 System Center 1801 - Service Manager,必须将运行托管数据库的 SQL Server 的计算机配置为允许更新。 如果不允许更新,System Center 1801 - 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 1801 - Service Manager 支持 SQL Server AlwaysOn 可用性组功能。

有关使用 AlwaysOn 可用性组安装 Service Manager 的详细信息, 请参阅此处

服务器操作系统

支持以下版本的 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 1801 组件 .NET 3.5 SP1 .NET 4 .NET 4.5 .NET 4.5.1 .Net 4.5.2 .NET 4.6
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 2016 的一般性能和可伸缩性指南,并建议针对各种工作负荷配置硬件。 由于 System Center 2016 构建为灵活且可缩放,因此特定方案的硬件要求可能与此处提供的准则不同。

Service Manager 的容量限制

了解 各种 Service Manager 部署方案的已测试容量限制。

支持的共存

为了帮助简化升级,可以将以下 Service Manager 2016 连接器与 System Center 2012 R2 组件配合使用。

  • System Center 2012 R2 Virtual Machine Manager
  • System Center 2012 R2 Orchestrator
  • System Center 2012 R2 Operations Manager
  • System Center 2012 R2 Configuration Manager
  • System Center Configuration Manager (SCCM) CB 版本 - 1511、1602、1606 和 1710。
    • UR5 支持 1802
    • UR9 和 UR10 支持从 1806 到 2103。 但是,存在一个限制,即 SCCM 支持的设备的大小应小于 2 PB。
    • UR10 支持 2107

硬件

服务器 处理器 (min) 处理器 (rec) RAM (min) RAM (rec) 硬盘空间 (min) 硬盘空间 (rec)
Service Manager 管理服务器 四核 2.66 GHz CPU 四核 2.66 GHz CPU 8 GB 8 GB 10 GB 10GB
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 10GB
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 10GB
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 管理服务器 管理服务器需要: ADO.NET 适用于 Windows Server 的 .NET Framework 3.5 SP1 的 Data Services 更新;SQL Server Native 客户端;Microsoft Service Manager 媒体提供的报表查看器可再发行组件。

管理服务器必须安装在 64 位版本的 Windows 上。
数据仓库管理服务器 仓库管理服务器需要:SQL Server Native 客户端

数据仓库管理服务器必须安装在 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报表查看器可再发行组件(在 System Center 媒体上可用):Microsoft Excel,以便查看控制台计算机上的 OLAP 数据多维数据集;ADO.NET 适用于 Windows Server 的 .NET Framework 3.5 SP1 的 Data Services 更新;SQL Server 分析管理对象

可以在 32 位和 64 位版本的 Windows 上安装控制台。
自助服务门户 自助服务门户服务器需要: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 创建数据市场。
配置管理器 Service Manager 可以从 Configuration Manager 环境导入配置项目。
网络要求 若要从知识文章中查看外部内容,托管 Service Manager 控制台的计算机必须直接或通过代理服务器访问 Internet。
SMTP 服务器 你必须有权访问简单邮件传输协议 (SMTP) 服务器才能使用通知功能以及通过电子邮件创建事件。
Windows 安全模式 Service Manager 不运行,如果 Windows Server 以安全模式运行,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 硬件性能