System Center Service Manager 的系統需求
重要
Service Provider Foundation （SPF） 已從 System Center 2025 停止。 不過，SPF 2022 將繼續使用 System Center 2025 元件。
本文詳述 System Center 2025 - Service Manager （SM） 的系統需求。
注意
與舊版不同的是，針對SM 2025，會移除 Analysis Management 物件。
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
硬體
| 伺服器 | 處理器 (分鐘) | 處理器 (rec) | RAM (分鐘) | RAM (rec) | 硬碟空間 (分鐘) | 硬碟空間 (rec) |
|---|---|---|---|---|---|---|
| Service Manager 管理伺服器 | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 8 GB | 10 GB | 10 GB |
| Service Manager 資料庫 | 八核心 2.66 GHz CPU | 八核心 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 數據倉儲資料庫 | 八核心 2.66 GHz CPU | 八核心 2.66 GHz CPU | 8 GB | 32 GB | 400 GB | 400 GB |
| Service Manager 控制台 | 雙核心 2 GHz CPU | 雙核心 2 GHz CPU | 4 GB | 4 GB | 10 GB | 10 GB |
| Service Manager 自助入口網站 （獨立版） | 四核心 2.66 GHz CPU | 八核心 2.66 GHz CPU | 8 GB | 16 GB | 80 GB | 80 GB |
| Service Manager 自助入口網站 + 次要管理伺服器 （建議） | 八核心 2.66 GHz CPU | 八核心 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 Update;SQL Server Native 用戶端 管理伺服器必須安裝在64位版本的Windows上。 |
| 數據倉儲管理伺服器 | 倉儲管理伺服器需要：SQL Server Native 用戶端 數據倉儲管理伺服器必須安裝在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 數據 Cube;ADO.NET 適用於 Windows Server 的 .NET Framework 3.5 SP1 Data Services Update。 主控台可以安裝在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 控制台的電腦必須直接或透過 Proxy 伺服器存取因特網。
SMTP 伺服器 - 您必須能夠存取簡易郵件傳輸通訊協定 （SMTP） 伺服器，才能使用通知功能，以及透過電子郵件建立事件。
Windows 安全模式 - Service Manager 不會運作，而且如果 Windows Server 以安全模式執行，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） Cube。 需要 SQL Server Reporting Services （SSRS） 才能支援 System Center 2025 - Service Manager 報告。
使用這項資訊來評估您的 SQL Server 環境是否準備好支援安裝或升級至 System Center 2025。 不論您要部署 System Center 的一或多個元件，請使用此資訊。
注意
在安裝期間，在執行 SQL Server 的電腦上選取 SQL Server 全文搜索 ，以裝載 Service Manager 和數據倉儲資料庫。
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 元件 | SQL Server 2019 含累積更新 8 | 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的值。 如果執行值的值是 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 會卸載 Reporting Services;確保移轉必要的報告，例如備份報告 DB 和加密金鑰。
使用下列步驟從 SQL 2017 升級至 2019：
- 升級至 SQL 2019。
- 安裝 SQL 2019 Reporting Services （SSRS）、啟動 Reporting Services 組態管理員以使用現有的報告資料庫，以及還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 針對您在起始 SQL 2019 升級程式之前擁有的報表伺服器 Web 服務虛擬目錄和 Web 入口網站 URL 使用相同的值。
- 根據這裡共用的詳細數據設定 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 會卸載 Reporting Services;確保移轉必要的報告，例如備份報告 DB 和加密金鑰。
使用下列步驟，從 SQL 2019 升級至 2022：
- 升級至 SQL 2022。
- 安裝 SQL 2022 Reporting Services （SSRS）、啟動 Reporting Services 組態管理員以使用現有的報告資料庫，以及還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 針對您在起始 SQL 2022 升級程式之前擁有的報表伺服器 Web 服務虛擬目錄和 Web 入口網站 URL 使用相同的值。
- 根據這裡共用的詳細數據設定 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 Standard、Datacenter Enterprise | 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，您不需要手動安裝報表查看器工具 /，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
硬體
| 伺服器 | 處理器 (分鐘) | 處理器 (rec) | RAM (分鐘) | RAM (rec) | 硬碟空間 (分鐘) | 硬碟空間 (rec) |
|---|---|---|---|---|---|---|
| Service Manager 管理伺服器 | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 8 GB | 10 GB | 10 GB |
| Service Manager 資料庫 | 八核心 2.66 GHz CPU | 八核心 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 數據倉儲資料庫 | 八核心 2.66 GHz CPU | 八核心 2.66 GHz CPU | 8 GB | 32 GB | 400 GB | 400 GB |
| Service Manager 控制台 | 雙核心 2 GHz CPU | 雙核心 2 GHz CPU | 4 GB | 4 GB | 10 GB | 10 GB |
| Service Manager 自助入口網站 （獨立版） | 四核心 2.66 GHz CPU | 八核心 2.66 GHz CPU | 8 GB | 16 GB | 80 GB | 80 GB |
| Service Manager 自助入口網站 + 次要管理伺服器 （建議） | 八核心 2.66 GHz CPU | 八核心 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 Update;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 數據 Cube;ADO.NET 適用於 Windows Server 的 .NET Framework 3.5 SP1 Data Services Update;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 控制台的電腦必須直接或透過 Proxy 伺服器存取因特網。
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） Cube。 需要 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 | SQL Server 2019 含累積更新 8 |
|---|---|---|
| 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;確保移轉必要的報告，例如備份報告 DB 和加密金鑰。
使用下列步驟從 SQL 2016 升級至 2017：
- 升級至 SQL 2017。
- 安裝 SQL 2017 Reporting Services （SSRS）、啟動 Reporting Services 組態管理員以使用現有的報告資料庫，以及還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 針對您在起始 SQL 2017 升級程式之前擁有的報表伺服器 Web 服務虛擬目錄和 Web 入口網站 URL 使用相同的值。
- 根據這裡共用的詳細數據設定 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 會卸載 Reporting Services;確保移轉必要的報告，例如備份報告 DB 和加密金鑰。
使用下列步驟從 SQL 2017 升級至 2019：
- 升級至 SQL 2019。
- 安裝 SQL 2019 Reporting Services （SSRS）、啟動 Reporting Services 組態管理員以使用現有的報告資料庫，以及還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 針對您在起始 SQL 2019 升級程式之前擁有的報表伺服器 Web 服務虛擬目錄和 Web 入口網站 URL 使用相同的值。
- 根據這裡共用的詳細數據設定 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 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 和更新版本支援）
硬體
| 伺服器 | 處理器 (分鐘) | 處理器 (rec) | RAM (分鐘) | RAM (rec) | 硬碟空間 (分鐘) | 硬碟空間 (rec) |
|---|---|---|---|---|---|---|
| Service Manager 管理伺服器 | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 8 GB | 10 GB | 10 GB |
| Service Manager 資料庫 | 八核心 2.66 GHz CPU | 八核心 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 數據倉儲資料庫 | 八核心 2.66 GHz CPU | 八核心 2.66 GHz CPU | 8 GB | 32 GB | 400 GB | 400 GB |
| Service Manager 控制台 | 雙核心 2 GHz CPU | 雙核心 2 GHz CPU | 4 GB | 4 GB | 10 GB | 10 GB |
| Service Manager 自助入口網站 （獨立版） | 四核心 2.66 GHz CPU | 八核心 2.66 GHz CPU | 8 GB | 16 GB | 80 GB | 80 GB |
| Service Manager 自助入口網站 + 次要管理伺服器 （建議） | 八核心 2.66 GHz CPU | 八核心 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 Update;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 數據 Cube：ADO.NET Data Services Update for.NET Framework 3.5 SP1 for Windows Server;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 控制台的電腦必須直接或透過 Proxy 伺服器存取因特網。
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） Cube。 需要 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 | SQL Server 2019 含累積更新 8 |
|---|---|---|---|
| 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;確保移轉必要的報告，例如備份報告 DB 和加密金鑰。
使用下列步驟從 SQL 2016 升級至 2017：
- 升級至 SQL 2017。
- 安裝 SQL 2017 Reporting Services （SSRS）、啟動 Reporting Services 組態管理員以使用現有的報告資料庫，以及還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 針對您在起始 SQL 2017 升級程式之前擁有的報表伺服器 Web 服務虛擬目錄和 Web 入口網站 URL 使用相同的值。
- 根據這裡共用的詳細數據設定 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 會卸載 Reporting Services;確保移轉必要的報告，例如備份報告 DB 和加密金鑰。
使用下列步驟從 SQL 2017 升級至 2019：
- 升級至 SQL 2019。
- 安裝 SQL 2019 Reporting Services （SSRS），並啟動 Reporting Services 組態管理員以使用現有的報告資料庫，還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 針對您在起始 SQL 2019 升級程式之前擁有的報表伺服器 Web 服務虛擬目錄和 Web 入口網站 URL 使用相同的值。
- 根據這裡共用的詳細數據設定 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，數據中心 | 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 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
硬體
| 伺服器 | 處理器 (分鐘) | 處理器 (rec) | RAM (分鐘) | RAM (rec) | 硬碟空間 (分鐘) | 硬碟空間 (rec) |
|---|---|---|---|---|---|---|
| Service Manager 管理伺服器 | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 8 GB | 10 GB | 10 GB |
| Service Manager 資料庫 | 八核心 2.66 GHz CPU | 八核心 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 數據倉儲資料庫 | 八核心 2.66 GHz CPU | 八核心 2.66 GHz CPU | 8 GB | 32 GB | 400 GB | 400 GB |
| Service Manager 控制台 | 雙核心 2 GHz CPU | 雙核心 2 GHz CPU | 4 GB | 4 GB | 10 GB | 10 GB |
| Service Manager 自助入口網站 （獨立版） | 四核心 2.66 GHz CPU | 八核心 2.66 GHz CPU | 8 GB | 16 GB | 80 GB | 80 GB |
| Service Manager 自助入口網站 + 次要管理伺服器 （建議） | 八核心 2.66 GHz CPU | 八核心 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 Update;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 數據 Cube;ADO.NET 適用於 Windows Server 的 .NET Framework 3.5 SP1 Data Services Update;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 控制台的電腦必須直接或透過 Proxy 伺服器存取因特網。 |
| 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） Cube。 需要 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 硬體效能的相關信息。