System Center Service Manager 的系統需求
本文詳細說明 System Center 2022 - Service Manager (SM) 的系統需求。
注意
不同於舊版的SM 2022,您不需要手動安裝適用於 SQL Server 2014 的 Microsoft 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 Data Warehouse Management Server | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
Service Manager Data Warehouse 資料庫 | 八核心 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 管理伺服器 | 管理伺服器需要:ADO.NET Windows Server .NET Framework 3.5 SP1 的 Data Services Update;SQL Server Native Client 管理伺服器必須安裝在64位版本的Windows上。 |
數據倉儲管理伺服器 | 倉儲管理伺服器需要:SQL Server Native Client 數據倉儲管理伺服器必須安裝在64位版本的Windows上。 |
Service Manager/資料倉儲資料庫 | Service Manager 或數據倉儲資料庫需要:SQL Server Reporting Services (SSRS) ;SQL Server 分析管理物件。 在裝載 Service Manager 資料庫、資料倉儲資料庫、Analysis Services 資料庫和 Reporting Services 資料庫的電腦上,SQL Server 和 Analysis Services 定序設定必須相同。 |
Service Manager 主控台 | 控制台需要:Microsoft Excel 才能在控制台電腦上檢視 OLAP 數據 Cube;ADO.NET Windows Server .NET Framework 3.5 SP1 的 Data Services Update;SQL Server 分析管理物件。 主控台可以安裝在64位版本的Windows上。 |
自助入口網站 | Self-Service 入口網站伺服器需要: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 Online Analysis Processing (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;確保移轉必要的報告,例如備份報告資料庫和加密密鑰。
使用下列步驟從 SQL 2016 升級至 2017:
- 升級至 SQL 2017。
- 安裝 SQL 2017 Reporting Services (SSRS) 、啟動 Reporting Services 組態管理員以使用現有的報告資料庫,以及還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 針對報表伺服器 Web 服務虛擬目錄和入口網站 URL,請使用您在啟動 SQL 2017 升級程序之前所擁有的相同值。
- 依照這裡所分享的詳細資訊來設定 SSRS。
- [選擇性]若要啟用 CLR 嚴格安全性,請在每個 Service Manager 資料庫上執行下列腳本。 升級至 SQL 2017 之後,預設會停用 CLR 嚴格安全性。
升級至 SQL 2019
下列步驟提供升級至 SQL 2019 的相關信息。
注意
- 您必須搭配 SQL 2019 使用累積更新 8 (CU8) 或更新版本。
- 使用 ODBC 17.3 到 17.10.4.1 和 MSOLEDBSQL 18.2 到 18.6.6。
- 將程序升級至 SQL 2019 會卸載 Reporting Services;確保移轉必要的報告,例如備份報告資料庫和加密密鑰。
使用下列步驟從 SQL 2017 升級至 2019:
- 升級至 SQL 2019。
- 安裝 SQL 2019 Reporting Services (SSRS) 、啟動 Reporting Services 組態管理員以使用現有的報告資料庫,以及還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 針對您在起始 SQL 2019 升級程式之前擁有的報表伺服器 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 Data Warehouse Management Server | • | • | • | • |
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 Data Warehouse Management Server | • | • | • | • | • | • | |||
Service Manager 主控台 | • | • | • | • | • | • | |||
Service Manager Self-Service 入口網站 | • | • | • | • | • | • |
支援的 PowerShell 版本
Service Manager 支援下列 PowerShell 版本。
System Center 元件 | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
---|---|---|
Service Manager 主控台 | • | • |
Service Manager 管理伺服器 | • | • |
Service Manager Data Warehouse Management Server | • | • |
本文詳述 System Center 2019 - Service Manager (SM) 的系統需求。
System Center 2019 的系統需求 - Service Manager
下列各節說明 SM 2019 的一般效能和延展性指引,並建議各種工作負載的硬體組態。 由於 System Center 2019 建置為彈性且可調整,因此特定案例的硬體需求可能與此處顯示的指導方針不同。
Service Manager 的容量限制
請閱讀部署案例的設定,以了解 Service Manager 經測試的容量限制。
支援的共存
為了協助簡化升級,您可以搭配下列 System Center 元件使用 Service Manager 2019 連接器。
- 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 版本
- Service Manager 2019 RTM) 支援 1511、1602、1606、1710 和 1802 (
- Service Manager 2019 UR2 和更新版本支援 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 Data Warehouse Management Server | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
Service Manager Data Warehouse 資料庫 | 八核心 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 管理伺服器 | 管理伺服器需要:.NET Framework 3.5 SP1 的 ADO.NET 資料服務更新 (適用於 Windows Server)、SQL Server Native Client、Microsoft Report Viewer 可轉散發套件 (隨附於 Service Manager 媒體)。 管理伺服器必須安裝在64位版本的Windows上。 |
數據倉儲管理伺服器 | 倉儲管理伺服器需要:SQL Server Native Client 數據倉儲管理伺服器必須安裝在64位版本的Windows上。 |
Service Manager/資料倉儲資料庫 | Service Manager 或數據倉儲資料庫需要:SQL Server Reporting Services (SSRS) ;SQL Server 分析管理物件。 在裝載 Service Manager 資料庫、資料倉儲資料庫、Analysis Services 資料庫和 Reporting Services 資料庫的電腦上,SQL Server 和 Analysis Services 定序設定必須相同。 |
Service Manager 主控台 | 主控台需要:Microsoft Report Viewer 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 Server 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 Online Analysis Processing (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。
- 針對報表伺服器 Web 服務虛擬目錄和入口網站 URL,請使用您在啟動 SQL 2017 升級程序之前所擁有的相同值。
- 依照這裡所分享的詳細資訊來設定 SSRS。
- [選擇性]若要啟用 CLR 嚴格安全性,請在每個 Service Manager 資料庫上執行下列腳本。 升級至 SQL 2017 之後,預設會停用 CLR 嚴格安全性。
升級至 SQL 2019
下列步驟提供升級至 SQL 2019 的相關信息。
注意
- 您必須搭配 SQL 2019 使用累積更新 8 (CU8) 或更新版本。
- 使用 ODBC 17.3 到 17.10.4.1,以及 MSOLEDBSQL 18.2 到 18.6.6。
- 將程序升級至 SQL 2019 會卸載 Reporting Services;確保移轉必要的報告,例如備份報告 DB 和加密金鑰。
使用下列步驟從 SQL 2017 升級至 2019:
- 升級至 SQL 2019。
- 安裝 SQL 2019 Reporting Services (SSRS) ,並啟動 Reporting Services 組態管理員以使用現有的報告資料庫、還原加密密鑰。 設定 Web 服務 URL 和入口網站 URL。
- 在起始 SQL 2019 升級程式之前,針對報表伺服器 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 Data Warehouse Management Server | • | • | • | • |
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 Data Warehouse Management Server | • | • | • | • | • | • | |||
Service Manager 主控台 | • | • | • | • | • | • | |||
Service Manager Self-Service 入口網站 | • | • | • | • | • | • |
支援的 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 Data Warehouse Management Server | • | • |
重要
此版本的 Service Manager 已達到終止支援。 建議您升級至 Service Manager 2022。
此文詳述 System Center 1807 - Service Manager (SM) 的系統需求。
System Center 1807 - Service Manager 的系統需求
下列各節說明 SM 1807 的一般效能和延展性指引,並針對各種工作負載建議硬體組態。 由於 System Center 1807 的設計理念是保障靈活性與可調整性,因此特定案例的硬體需求可能不同於此處所提供指導方針。
Service Manager 的容量限制
請閱讀部署案例的設定,以了解 Service Manager 經測試的容量限制。
支援的共存
為了協助簡化升級,您可以搭配下列 System Center 元件使用 Service Manager 1807 連接器。
- System Center 2012 R2/2016 Virtual Machine Manager
- System Center 2012 R2/2016 Orchestrator
- System Center 2012 R2/2016 Operations Manager
- System Center 2012 R2/2016 Configuration Manager
- System Center Configuration Manager CB 版本 - 1511、1602、1606、1710、1802、1806 和 1810
硬體
伺服器 | 處理器 (分鐘) | 處理器 (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 Data Warehouse Management Server | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
Service Manager Data Warehouse 資料庫 | 八核心 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 管理伺服器 | 管理伺服器需要:ADO.NET Windows Server .NET Framework 3.5 SP1 的數據服務更新;SQL Server Native client;Microsoft Report Viewer 可轉散發套件,可供 Service Manager 媒體使用。 管理伺服器必須安裝在64位版本的Windows上。 |
數據倉儲管理伺服器 | 倉儲管理伺服器需要:SQL Server Native Client 數據倉儲管理伺服器必須安裝在64位版本的Windows上。 |
Service Manager/資料倉儲資料庫 | Service Manager 或數據倉儲資料庫需要:SQL Server Reporting Services (SSRS) ;SQL Server 分析管理物件。 在裝載 Service Manager 資料庫、資料倉儲資料庫、Analysis Services 資料庫和 Reporting Services 資料庫的電腦上,SQL Server 和 Analysis Services 定序設定必須相同。 |
Service Manager 主控台 | 主控台需要:Microsoft Report Viewer System Center 媒體) 上提供的可轉散發 (:Microsoft Excel,才能在控制台計算機上檢視 OLAP 數據 Cube;ADO.NET Windows Server .NET Framework 3.5 SP1 的數據服務更新;SQL Server 分析管理物件。 主控台可以安裝在32位和64位版本的Windows上。 |
自助入口網站 | 自助入口網站伺服器需要:Windows Server 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 1807 - Service Manager 須有 SQL Server Analysis Services (SSAS) 才能與 Microsoft 線上分析處理 (OLAP) Cube 搭配運作。 須有 SQL Server Reporting Services (SSRS) 才能支援 System Center 1807 - Service Manager 報告。
使用此資訊來評估您的 SQL Server 環境是否準備好支援安裝或升級至 System Center 1807。 無論您是部署 System Center 的一或多個元件,請使用此資訊。
SQL Server 版本支援
注意
針對支援的 SQL 版本,請使用 Microsoft 目前支援的 Service Pack。
Service Manager | SQL Server 2012 | SQL Server 2014 和 SP | SQL Server 2016 和 SP | SQL Server 2017 |
---|---|---|---|---|
Service Manager/資料倉儲資料庫 | • | • | • |
注意
System Center 1807 - Service Manager 不支援 MultiSubnetFailover 參數。 此參數不會用於 System Center 1807 - Service Manager 連接字串。
允許更新
若要安裝或升級 System Center 1807 - Service Manager,您必須將執行 SQL Server 且裝載資料庫的電腦設定為允許更新。 如果不允許更新,System Center 1807 - Service Manager 安裝程式將不會完成,而且安裝中的 [建立資料庫] 階段會出現下列錯誤訊息:
執行客戶動作時發生錯誤:_ExecuteSqlScripts。 在進行永久性修改之前,此升級嘗試失敗。 升級已成功還原回系統的原始狀態。 在更正錯誤之後,您可以針對此角色再次嘗試升級。
您可以在 SQL Server Management Studio 中執行下列預存程序,檢查 SQL Server 上的 allow updates 狀態:
sp_configure 'allow updates'
檢查結果表格中的 "run_value" 值。 如果 "run value" 的值為 1,請使用下列預存程序將值設定回 0,然後再執行安裝程式一次。
sp_configure 'allow updates',0 reconfigure with override
Service Manager 資料庫的 AlwaysOn 可用性群組考量
System Center 1807 - Service Manager 支援 SQL Server AlwaysOn 可用性群組功能。
如需使用 AlwaysOn 可用性群組安裝 Service Manager 的詳細資訊,請參閱這裡。
升級至 SQL 2017
下列步驟提供升級至 SQL 2017 的相關資訊。
注意
- 使用SM 1807時,只有在從SQL 2016升級 SQL 2017 時,才支援 SQL 2017。 不支援使用SM 1807的SQL 2017全新安裝。
- 具有 SM 1801 部署和 SQL 2016 的用戶必須套用 SM 1807,然後升級至 SQL 2017。
- 升級至 SQL 2017 的程式會卸載 Reporting Services;確保移轉必要的報告,例如備份報告資料庫和加密密鑰。
使用下列步驟從 SQL 2016 升級至 2017:
升級至 SQL 2017。
安裝 SQL 2017 Reporting Services (SSRS),然後啟動 Reporting Services 設定管理員以使用現有的報表資料庫,並還原加密金鑰。 設定 Web 服務 URL 和入口網站 URL。
針對報表伺服器 Web 服務虛擬目錄和入口網站 URL,請使用您在啟動 SQL 2017 升級程序之前所擁有的相同值。
依照這裡所分享的詳細資訊來設定 SSRS。
[選擇性] 若要啟用 CLR 嚴格安全性,請在每個 Service Manager 資料庫上執行下列指令碼。
升級至 SQL 2017 之後,預設會停用 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
伺服器作業系統
支援下列 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 Data Warehouse Management Server | • | • | • | ||
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 Enterprise | Windows Server® 2016 Standard、Datacenter |
---|---|---|---|---|---|---|---|---|
Service Manager 主控台 | • | • | • | • | • | • |
支援的 .NET 版本
Service Manager 支援下列版本的 .NET。
System Center 1807 元件 | .NET 3.5 SP1 | .NET 4 | .NET 4.5 | .NET 4.5.1 | .Net 4.5.2 | .NET 4.6 |
---|---|---|---|---|---|---|
Service Manager 管理伺服器 | • | • | ||||
Service Manager Data Warehouse Management Server | • | • | ||||
Service Manager 主控台 | • | • | ||||
Service Manager Self-Service 入口網站 | • | • |
支援的 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 Data Warehouse Management Server | • | • |
重要
此版本的 Service Manager 已終止支援。 建議您升級至 Service Manager 2022。
本文詳述 System Center 1801 - Service Manager (SM) 的系統需求。
本文詳述 System Center 2016 - Service Manager (SM) 的系統需求。
System Center 1801 - Service Manager 的系統需求
下列各節說明 SM 1801 的一般效能和延展性指引,並建議各種工作負載的硬體設定。 由於 System Center 1801 的設計理念是保障靈活性與可調整性,因此特定案例的硬體需求可能不同於此處所提供指導方針。
Service Manager 的容量限制
請閱讀部署案例的設定,以了解 Service Manager 經測試的容量限制。
支援的共存
為了協助簡化升級,您可以使用 Service Manager 1801 連接器搭配下列 System Center 元件。
- System Center 2012 R2/2016 Virtual Machine Manager
- System Center 2012 R2/2016 Orchestrator
- System Center 2012 R2/2016 Operations Manager
- System Center 2012 R2/2016 Configuration Manager
- System Center Configuration Manager CB 版本 - 1511、1602、1606 和 1710
硬體
伺服器 | 處理器 (分鐘) | 處理器 (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 Data Warehouse Management Server | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
Service Manager Data Warehouse 資料庫 | 八核心 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 管理伺服器 | 管理伺服器需要:.NET Framework 3.5 SP1 的 ADO.NET 資料服務更新 (適用於 Windows Server)、SQL Server Native Client、Microsoft Report Viewer 可轉散發套件 (隨附於 Service Manager 媒體)。 管理伺服器必須安裝在64位版本的Windows上。 |
數據倉儲管理伺服器 | 倉儲管理伺服器需要:SQL Server Native Client 數據倉儲管理伺服器必須安裝在64位版本的Windows上。 |
Service Manager/資料倉儲資料庫 | Service Manager 或數據倉儲資料庫需要:SQL Server Reporting Services (SSRS) ;SQL Server 分析管理物件。 在裝載 Service Manager 資料庫、資料倉儲資料庫、Analysis Services 資料庫和 Reporting Services 資料庫的電腦上,SQL Server 和 Analysis Services 定序設定必須相同。 |
Service Manager 主控台 | 主控台需要:Microsoft Report Viewer System Center 媒體) 提供可轉散發 (:Microsoft Excel,才能在控制台計算機上檢視 OLAP 數據 Cube;ADO.NET Windows Server .NET Framework 3.5 SP1 的 Data Services Update;SQL Server 分析管理物件。 主控台可以安裝在32位和64位版本的Windows上。 |
自助入口網站 | 自助入口網站伺服器需要:Windows Server 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 1801 - Service Manager 須有 SQL Server Analysis Services (SSAS) 才能與 Microsoft 線上分析處理 (OLAP) Cube 搭配運作。 須有 SQL Server Reporting Services (SSRS) 才能支援 System Center 1801 - Service Manager 報告。
使用此資訊來評估您的 SQL Server 環境是否準備好支援安裝或升級至 System Center 1801。 無論您是部署 System Center 的一或多個元件,請使用此資訊。
SQL Server 版本支援
注意
針對支援的 SQL 版本,請使用 Microsoft 目前支援的 Service Pack。
Service Manager | SQL Server 2012 | SQL Server 2014 和 SP | SQL Server 2016 和 SP |
---|---|---|---|
Service Manager/資料倉儲資料庫 | • | • |
注意
System Center 1801 - Service Manager 不支援 MultiSubnetFailover 參數。 這個參數不會用於 System Center 1801 - Service Manager 連接字串。
允許更新
若要安裝或升級 System Center 1801 - Service Manager,您必須將執行 SQL Server 且裝載資料庫的電腦設定為允許更新。 如果不允許更新,System Center 1801 - Service Manager 安裝程式將不會完成,且下列錯誤訊息會出現在安裝的建立資料庫階段:
執行客戶動作時發生錯誤:_ExecuteSqlScripts。 在進行永久性修改之前,此升級嘗試失敗。 升級已成功還原回系統的原始狀態。 在更正錯誤之後,您可以針對此角色再次嘗試升級。
您可以在 SQL Server Management Studio 中執行下列預存程序,檢查 SQL Server 上的 allow updates 狀態:
sp_configure 'allow updates'
檢查結果表格中的 "run_value" 值。 如果 "run value" 的值為 1,請使用下列預存程序將值設定回 0,然後再執行安裝程式一次。
sp_configure 'allow updates',0 reconfigure with override
Service Manager 資料庫的 AlwaysOn 可用性群組考量
System Center 1801 - Service Manager 支援 SQL Server AlwaysOn 可用性群組功能。
如需使用 AlwaysOn 可用性群組安裝 Service Manager 的詳細資訊,請參閱這裡。
伺服器作業系統
支援下列 Windows Server 作業系統版本。
System Center 元件 | Windows Server 2012 Standard、Datacenter | Windows Server 2012 R2 Standard、Datacenter | Windows Server 2016 | Windows Server 2016 (伺服器含桌面體驗) | Windows Server 2016 Nano Server |
---|---|---|---|---|---|
Service Manager 管理伺服器 | • | • | • | ||
Service Manager Data Warehouse Management Server | • | • | • | ||
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 Enterprise | Windows Server® 2016 Standard、Datacenter |
---|---|---|---|---|---|---|---|---|
Service Manager 主控台 | • | • | • | • | • | • |
支援的 .NET 版本
Service Manager 支援下列版本的 .NET。
System Center 1801 元件 | .NET 3.5 SP1 | .NET 4 | .NET 4.5 | .NET 4.5.1 | .Net 4.5.2 | .NET 4.6 |
---|---|---|---|---|---|---|
Service Manager 管理伺服器 | • | • | ||||
Service Manager Data Warehouse Management Server | • | • | ||||
Service Manager 主控台 | • | • | ||||
Service Manager Self-Service 入口網站 | • | • |
支援的 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 Data Warehouse Management Server | • | • |
System Center 2016 - Service Manager 的系統需求
下列各節說明 SM 2016 的一般效能和延展性指引,並建議各種工作負載的硬體設定。 由於 System Center 2016 的設計理念是保障靈活性與可調整性,因此特定案例的硬體需求可能不同於此處所提供指導方針。
Service Manager 的容量限制
了解各種 Service Manager 部署案例經測試的容量限制。
支援的共存
為了協助簡化升級,您可以搭配 System Center 2012 R2 元件使用下列 Service Manager 2016 連接器。
- 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 Data Warehouse Management Server | 四核心 2.66 GHz CPU | 四核心 2.66 GHz CPU | 8 GB | 16 GB | 10 GB | 10 GB |
Service Manager Data Warehouse 資料庫 | 八核心 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 Data Warehouse Management Server | • | • | • | ||
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 Enterprise | 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 Data Warehouse Management Server | • | • | • | • | • | |||
Service Manager 主控台 | • | • | • | • | • | |||
Service Manager Self-Service 入口網站 | • | • | • | • | • |
支援的 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 Data Warehouse Management Server | • | • |
軟體需求
元件 | 需求 |
---|---|
Service Manager 管理伺服器 | 管理伺服器需要:.NET Framework 3.5 SP1 的 ADO.NET 資料服務更新 (適用於 Windows Server)、SQL Server Native Client、Microsoft Report Viewer 可轉散發套件 (隨附於 Service Manager 媒體)。 管理伺服器必須安裝在64位版本的Windows上。 |
數據倉儲管理伺服器 | 倉儲管理伺服器需要:SQL Server Native Client 數據倉儲管理伺服器必須安裝在64位版本的Windows上。 |
Service Manager/資料倉儲資料庫 | Service Manager 或數據倉儲資料庫需要:SQL Server Reporting Services (SSRS) ;SQL Server 分析管理物件。 在裝載 Service Manager 資料庫、資料倉儲資料庫、Analysis Services 資料庫和 Reporting Services 資料庫的電腦上,SQL Server 和 Analysis Services 定序設定必須相同。 |
Service Manager 主控台 | 主控台需要:Microsoft Report Viewer System Center 媒體) 上提供可轉散發 (:Microsoft Excel 依序在控制台計算機上檢視 OLAP 數據 Cube;ADO.NET Windows Server .NET Framework 3.5 SP1 的 Data Services Update;SQL Server 分析管理物件 主控台可以安裝在32位和64位版本的Windows上。 |
自助入口網站 | 自助入口網站伺服器需要:Windows Server 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 服務,該服務將無法啟動,且事件記錄檔中會寫入錯誤。 |
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 位元 Enterprise 和 Standard 版的支援。
注意
針對支援的 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 硬體效能的資訊。
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應