Requisiti di sistema per System Center Service Manager
Importante
Service Provider Foundation (SPF) non è più disponibile da System Center 2025. Tuttavia, SPF 2022 continuerà a funzionare con i componenti di System Center 2025.
Questo articolo descrive in dettaglio i requisiti di sistema per System Center 2025 - Service Manager (SM).
Nota
A differenza delle versioni precedenti, per SM 2025, l'oggetto Di gestione dell'analisi viene rimosso.
Requisiti di sistema per System Center 2025 - Service Manager
Le sezioni seguenti descrivono le linee guida generali sulle prestazioni e sulla scalabilità per SM 2025 e consigliano le configurazioni hardware per vari carichi di lavoro. Poiché System Center 2025 è progettato per essere flessibile e scalabile, i requisiti hardware per scenari specifici possono differire dalle linee guida presentate qui.
Limiti di capacità per Service Manager
Per informazioni sui limiti di capacità testati di Service Manager, vedere Configurazioni per scenari di distribuzione.
Coesistenza supportata
Per semplificare gli aggiornamenti, è possibile usare i connettori di Service Manager 2025 con i componenti di System Center seguenti.
- System Center 2022/2025 Virtual Machine Manager
- System Center 2022/2025 Operations Manager
- System Center 2022/2025 Configuration Manager (solo durante lo scenario di migrazione)
- Versioni CB di System Center Configuration Manager
- 1511, 1602, 1606, 1710, 1802, 1806 a 2103, 2107, 2111, 2203, 2207, 2211, 2303, 2309, 2403
Hardware
| Server | Processore (min.) | Processore (cons.) | RAM (min.) | RAM (cons.) | Spazio su disco rigido (min.) | Spazio su disco rigido (cons.) |
|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | CPU 4 core 2,66 GHz | CPU 4 core 2,66 GHz | 8 GB | 8 GB | 10 GB | 10 GB |
| Database di Service Manager | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 32 GB | 80 GB | 80 GB |
| Server di gestione del data warehouse di Service Manager | CPU 4 core 2,66 GHz | CPU 4 core 2,66 GHz | 8 GB | 16 GB | 10 GB | 10 GB |
| Database del data warehouse di Service Manager | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 32 GB | 400 GB | 400 GB |
| Console di Service Manager | CPU 2 core 2 GHz | CPU 2 core 2 GHz | 4 GB | 4 GB | 10 GB | 10 GB |
| Portale self-service di Service Manager (autonomo) | CPU 4 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 16 GB | 80 GB | 80 GB |
| Portale self-service di Service Manager + Server di gestione secondario (scelta consigliata) | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 16 GB | 32 GB | 80 GB | 80 GB |
Requisiti software
| Componente | Requisito |
|---|---|
| Server di gestione di Service Manager | Il server di gestione deve: ADO.NET Aggiornamento di Data Services per .NET Framework 3.5 SP1 per Windows Server; SQL Server Native Client Il server di gestione deve essere installato in un'edizione a 64 bit di Windows. |
| Server di gestione del data warehouse | Il server di gestione del warehouse richiede: SQL Server Native Client Il server di gestione del data warehouse deve essere installato in un'edizione a 64 bit di Windows. |
| Database di Service Manager/data warehouse | I database di Service Manager o data warehouse richiedono: SQL Server Reporting Services (SSRS). Le impostazioni delle regole di confronto di SQL Server e Analysis Services devono essere identiche per i computer che ospitano il database di Service Manager, il database del data warehouse, il database di Analysis Services e il database di Reporting Services. |
| Console di Service Manager | La console richiede: Microsoft Excel per visualizzare i cubi di dati OLAP nel computer console; ADO.NET Aggiornamento di Data Services per .NET Framework 3.5 SP1 per Windows Server. La console può essere installata nell'edizione a 64 bit di Windows. |
| Portale self-service | Il server portale self-service richiede: server Windows 2016 o versione successiva; ruolo IIS e ASP.NET 4.5 abilitato. Aggiungere il computer server allo stesso dominio in cui è in esecuzione il servizio SDK di Service Manager. Idealmente, nel server primario o secondario. |
| Computer che usano self-service | Il portale self-service richiede una risoluzione dello schermo superiore a 1024 x 768. Browser supportati: Microsoft Edge 121 e versioni successive; Microsoft Internet Explorer 10 e 11; Mozilla Firefox 42 e versioni successive; Google Chrome 121 e versioni successive. |
| SQL Server Reporting Services | In una topologia di distribuzione in cui il computer che ospita SSRS non si trova nello stesso computer che ospita il server di gestione del data warehouse, è necessario aggiungere Microsoft.EnterpriseManagement.Reporting.Code alla Global Assembly Cache. Informazioni sui passaggi manuali. |
Note aggiuntive
Operations Manager - Service Manager offre la possibilità di importare avvisi e elementi di configurazione da un ambiente Operations Manager. Informazioni sull'installazione sia di Service Manager che di Operations Manager nello stesso ambiente. È possibile creare un data mart per Operations Manager.
Configuration Manager : Service Manager può importare elementi di configurazione da un ambiente di Configuration Manager.
Requisiti di rete: per visualizzare il contenuto esterno dagli articoli della Knowledge Base, i computer che ospitano la console di Service Manager devono avere accesso a Internet, direttamente o tramite un server proxy.
Server SMTP: è necessario avere accesso a un server SMTP (Simple Mail Transfer Protocol) per utilizzare la funzionalità di notifica e per la creazione di eventi imprevisti tramite posta elettronica.
Modalità provvisoria di Windows: Service Manager non funziona e i servizi usati da Service Manager non vengono avviati se Windows Server è in esecuzione in modalità provvisoria. Se si tenta di avviare manualmente i servizi di Service Manager in modalità provvisoria, l'avvio dei servizi non riesce e viene scritto un errore nel registro eventi.
requisiti di SQL Server
Microsoft SQL Server ospita i database creati da System Center - Service Manager. System Center 2025 - Service Manager richiede inoltre che SQL Server Analysis Services (SSAS) funzioni con i cubi OLAP (Online Analytical Processing). SQL Server Reporting Services (SSRS) è necessario per supportare i report di System Center 2025 - Service Manager.
Usare queste informazioni per valutare se l'ambiente SQL Server è pronto per supportare l'installazione o l'aggiornamento a System Center 2025. Usare queste informazioni se si distribuiscono uno o più componenti di System Center.
Nota
Durante l'installazione selezionare Ricerca full-text di SQL Server nei computer che eseguono SQL Server che ospiteranno i database di Service Manager e del data warehouse.
Supporto della versione di SQL Server
Nota
- SM non supporta la modalità SSAS tabulare. Selezionare la modalità SSAS come multidimensionale durante l'installazione di SQL Server.
- Per le versioni supportate di SQL, usare i Service Pack attualmente supportati da Microsoft.
- Service Manager 2025 supporta SQL 2019 con CU8 o versione successiva; tuttavia, non supporta SQL 2019 RTM.
- Con SQL 2019 (CU8 o versione successiva), usare ODBC 17.3 a 17.10.6 e MSOLEDBSQL 18.2 a 18.7.2.
| Componente di System Center | SQL Server 2019 con aggiornamento cumulativo 8 | SQL Server 2022 |
|---|---|---|
| Service Manager | • | • |
| Database del data warehouse | • | • |
Nota
System Center 2025 - Service Manager non supporta il parametro MultiSubnetFailover . Questo parametro non viene usato in System Center 2025 - Service Manager stringa di connessione s.
Consenti aggiornamenti
Per installare o eseguire l'aggiornamento a System Center 2025 - Service Manager, i computer che eseguono SQL Server che ospitano i database devono essere configurati per consentire gli aggiornamenti. Se gli aggiornamenti non sono consentiti, l'installazione di System Center 2025 - Service Manager non verrà completata e nella fase Di creazione del database dell'installazione verrà visualizzato il messaggio di errore seguente:
Si è verificato un errore durante l'esecuzione di un'azione del cliente: _ExecuteSqlScripts. Il tentativo di aggiornamento non è riuscito prima di apportare modifiche permanenti. È stato eseguito il rollback allo stato originale del sistema. Dopo aver apportato le correzioni, è possibile ritentare l'aggiornamento per questo ruolo.
È possibile verificare lo stato di allow updates su SQL Server eseguendo la seguente stored procedure da SQL Server Management Studio:
sp_configure 'allow updates'
Nella tabella dei risultati esaminare il valore per run_value. Se il valore di esecuzione è 1, impostarlo su 0 con la stored procedure seguente e quindi eseguire di nuovo il programma di installazione.
sp_configure 'allow updates',0 reconfigure with override
Considerazioni sui gruppi di disponibilità AlwaysOn per i database di Service Manager
La funzionalità Gruppi di disponibilità AlwaysOn di SQL Server è supportata da System Center 2025 - Service Manager.
Per altre informazioni sull'installazione di Service Manager con i gruppi di disponibilità AlwaysOn, vedere qui.
Eseguire l'aggiornamento a SQL 2019
I passaggi seguenti forniscono informazioni sull'aggiornamento a SQL 2019.
Nota
- È necessario usare l'aggiornamento cumulativo 8 (CU8) o versione successiva con SQL 2019.
- Usare ODBC 17.3 da 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
- Il processo di aggiornamento a SQL 2019 disinstalla Reporting Services; assicurarsi di eseguire la migrazione dei report necessari, ad esempio il database di report di backup e le chiavi di crittografia.
Seguire questa procedura per eseguire l'aggiornamento da SQL 2017 a 2019:
- Eseguire l'aggiornamento a SQL 2019.
- Installare SQL 2019 Reporting Services (SSRS), avviare gestione configurazione reporting services per usare il database di report esistente e ripristinare le chiavi di crittografia. Configurare l'URL del servizio Web e l'URL del portale Web.
- Usare gli stessi valori per la directory virtuale del servizio Web reporting server e l'URL del portale Web precedente all'avvio del processo di aggiornamento per SQL 2019.
- Configurare SSRS in base ai dettagli condivisi qui.
- [Facoltativo] Per abilitare clr strict security, eseguire lo script seguente in ognuno dei database di Service Manager. Per impostazione predefinita, clr strict security è disabilitato dopo l'aggiornamento a SQL 2019.
Eseguire l'aggiornamento a SQL 2022
I passaggi seguenti forniscono informazioni sull'aggiornamento a SQL 2022.
Nota
- È necessario usare l'aggiornamento cumulativo 8 (CU8) o versione successiva con SQL 2022.
- Usare ODBC 17.3 da 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
- Il processo di aggiornamento a SQL 2022 disinstalla Reporting Services; assicurarsi di eseguire la migrazione dei report necessari, ad esempio il database di report di backup e le chiavi di crittografia.
Seguire questa procedura per eseguire l'aggiornamento da SQL 2019 a 2022:
- Eseguire l'aggiornamento a SQL 2022.
- Installare SQL 2022 Reporting Services (SSRS), avviare gestione configurazione reporting services per usare il database di report esistente e ripristinare le chiavi di crittografia. Configurare l'URL del servizio Web e l'URL del portale Web.
- Usare gli stessi valori per la directory virtuale del servizio Web reporting server e l'URL del portale Web precedente all'avvio del processo di aggiornamento per SQL 2022.
- Configurare SSRS in base ai dettagli condivisi qui.
- [Facoltativo] Per abilitare clr strict security, eseguire lo script seguente in ognuno dei database di Service Manager. Per impostazione predefinita, clr strict security è disabilitato dopo l'aggiornamento a SQL 2022.
Abilitare clr strict security
Facoltativo. Usare lo script seguente per abilitare clr strict security.
-- 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
Sistema operativo server
Sono supportate le versioni seguenti del sistema operativo Windows Server.
| Componente di System Center | Windows Server 2019 Standard, Datacenter | Windows Server 2019 Server Core | Windows Server 2022 Standard, Datacenter | Windows Server 2022 Server Core | Windows Server 2025 Standard, Datacenter | Windows Server 2025 Server Core |
|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | • | • | • | • | • | • |
| Server di gestione del data warehouse di Service Manager | • | • | • | • | • | • |
| Database di Service Manager o database del data warehouse | • | • | • | • | • | • |
| Portale self-service di Service Manager (HTML 5) | • | • | • | • | • | • |
Sistema operativo client
Le versioni seguenti del sistema operativo client Windows sono supportate per la console di Service Manager.
| Componenti lato client di System Center | Windows Server® 2019 Standard, Datacenter Enterprise | Windows Server® 2022 Standard, Datacenter Enterprise | Windows Server® 2025 Standard, Datacenter | Windows 10 | Windows 11 |
|---|---|---|---|---|---|
| Console di Service Manager | • | • | • | • | • |
Versioni di .NET supportate
Le versioni seguenti di .NET sono supportate per Service Manager.
| Componente di 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 |
|---|---|---|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | • | • | • | • | • | • | |||
| Server di gestione del data warehouse di Service Manager | • | • | • | • | • | • | |||
| Console di Service Manager | • | • | • | • | • | • | |||
| Portale self-service di Service Manager | • | • | • | • | • | • |
Versioni di PowerShell supportate
Le versioni seguenti di PowerShell sono supportate per Service Manager.
| Componente di System Center | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|
| Console di Service Manager | • | • |
| Server di gestione di Service Manager | • | • |
| Server di gestione del data warehouse di Service Manager | • | • |
Questo articolo descrive in dettaglio i requisiti di sistema per System Center 2022 - Service Manager (SM).
Nota
A differenza delle versioni precedenti, per SM 2022 non è necessario installare manualmente gli strumenti /di Visualizzatore report Microsoft CLR Types per SQL Server 2014 come prerequisito.
Requisiti di sistema per System Center 2022 - Service Manager
Le sezioni seguenti descrivono le linee guida generali sulle prestazioni e sulla scalabilità per SM 2022 e consigliano le configurazioni hardware per vari carichi di lavoro. Poiché System Center 2022 è progettato per essere flessibile e scalabile, i requisiti hardware per scenari specifici possono differire dalle linee guida presentate qui.
Limiti di capacità per Service Manager
Per informazioni sui limiti di capacità testati di Service Manager, vedere Configurazioni per scenari di distribuzione.
Coesistenza supportata
Per semplificare gli aggiornamenti, è possibile usare i connettori di Service Manager 2022 con i componenti di System Center seguenti.
- System Center 2019/2022 Virtual Machine Manager
- System Center 2019/2022 Orchestrator
- System Center 2019/2022 Operations Manager
- System Center 2019/2022 Configuration Manager (solo durante lo scenario di migrazione)
- Versioni CB di System Center Configuration Manager
- 1511, 1602, 1606, 1710, 1802, da 1806 a 2103, 2107
Hardware
| Server | Processore (min.) | Processore (cons.) | RAM (min.) | RAM (cons.) | Spazio su disco rigido (min.) | Spazio su disco rigido (cons.) |
|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | CPU 4 core 2,66 GHz | CPU 4 core 2,66 GHz | 8 GB | 8 GB | 10 GB | 10 GB |
| Database di Service Manager | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 32 GB | 80 GB | 80 GB |
| Server di gestione del data warehouse di Service Manager | CPU 4 core 2,66 GHz | CPU 4 core 2,66 GHz | 8 GB | 16 GB | 10 GB | 10 GB |
| Database del data warehouse di Service Manager | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 32 GB | 400 GB | 400 GB |
| Console di Service Manager | CPU 2 core 2 GHz | CPU 2 core 2 GHz | 4 GB | 4 GB | 10 GB | 10 GB |
| Portale self-service di Service Manager (autonomo) | CPU 4 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 16 GB | 80 GB | 80 GB |
| Portale self-service di Service Manager + Server di gestione secondario (scelta consigliata) | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 16 GB | 32 GB | 80 GB | 80 GB |
Requisiti software
| Componente | Requisito |
|---|---|
| Server di gestione di Service Manager | Il server di gestione deve: ADO.NET Aggiornamento di Data Services per .NET Framework 3.5 SP1 per Windows Server; SQL Server Native Client Il server di gestione deve essere installato in un'edizione a 64 bit di Windows. |
| Server di gestione del data warehouse | Il server di gestione del warehouse richiede: SQL Server Native Client Il server di gestione del data warehouse deve essere installato in un'edizione a 64 bit di Windows. |
| Database di Service Manager/data warehouse | I database di Service Manager o data warehouse richiedono: SQL Server Reporting Services (SSRS); SQL Server Analysis Management Objects. Le impostazioni delle regole di confronto di SQL Server e Analysis Services devono essere identiche per i computer che ospitano il database di Service Manager, il database del data warehouse, il database di Analysis Services e il database di Reporting Services. |
| Console di Service Manager | La console richiede: Microsoft Excel per visualizzare i cubi di dati OLAP nel computer console; ADO.NET Aggiornamento di Data Services per .NET Framework 3.5 SP1 per Windows Server; SQL Server Analysis Management Objects. La console può essere installata nell'edizione a 64 bit di Windows. |
| Portale self-service | Il server portale self-service richiede: server Windows 2016 o versione successiva; ruolo IIS e ASP.NET 4.5 abilitato; SQL Server Analysis Management Objects. Aggiungere il computer server allo stesso dominio in cui è in esecuzione il servizio SDK di Service Manager. Idealmente, nel server primario o secondario. |
| Computer che usano self-service | Il portale self-service richiede una risoluzione dello schermo superiore a 1024 x 768. Browser supportati: Microsoft Edge; Microsoft Internet Explorer 10 e 11; Mozilla Firefox 42 e versioni successive; Google Chrome 46 e versioni successive. |
| SQL Server Reporting Services | In una topologia di distribuzione in cui il computer che ospita SSRS non si trova nello stesso computer che ospita il server di gestione del data warehouse, è necessario aggiungere Microsoft.EnterpriseManagement.Reporting.Code alla Global Assembly Cache. Informazioni sui passaggi manuali. |
Note aggiuntive
Operations Manager - Service Manager offre la possibilità di importare avvisi e elementi di configurazione da un ambiente Operations Manager. Informazioni sull'installazione sia di Service Manager che di Operations Manager nello stesso ambiente. È possibile creare un data mart per Operations Manager.
Configuration Manager : Service Manager può importare elementi di configurazione da un ambiente di Configuration Manager.
Requisiti di rete: per visualizzare il contenuto esterno dagli articoli della Knowledge Base, i computer che ospitano la console di Service Manager devono avere accesso a Internet, direttamente o tramite un server proxy.
Server SMTP: è necessario avere accesso a un server SMTP (Simple Mail Transfer Protocol) per utilizzare la funzionalità di notifica e per la creazione di eventi imprevisti tramite posta elettronica.
Modalità provvisoria di Windows: Service Manager non funziona e i servizi usati da Service Manager non vengono avviati se Windows Server è in esecuzione in modalità provvisoria. Se si tenta di avviare manualmente i servizi di Service Manager in modalità provvisoria, l'avvio dei servizi non riesce e viene scritto un errore nel registro eventi.
requisiti di SQL Server
Microsoft SQL Server ospita i database creati da System Center - Service Manager. System Center 2022 - Service Manager richiede inoltre che SQL Server Analysis Services (SSAS) funzioni con cubi OLAP (Online Analytical Processing). SQL Server Reporting Services (SSRS) è necessario per supportare la creazione di report di System Center 2022 - Service Manager.
Usare queste informazioni per valutare se l'ambiente SQL Server è pronto per supportare l'installazione o l'aggiornamento a System Center 2022. Usare queste informazioni se si distribuiscono uno o più componenti di System Center.
Nota
Durante l'installazione selezionare Ricerca full-text di SQL Server nei computer che eseguono SQL Server che ospiteranno i database di Service Manager e del data warehouse.
Supporto della versione di SQL Server
Nota
- SM non supporta la modalità SSAS tabulare. Selezionare la modalità SSAS come multidimensionale durante l'installazione di SQL Server.
- Per le versioni supportate di SQL, usare i Service Pack attualmente supportati da Microsoft.
- Service Manager 2022 supporta SQL 2019 con CU8 o versione successiva; tuttavia, non supporta SQL 2019 RTM.
- Con SQL 2019 (CU8 o versione successiva), usare ODBC 17.3 a 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
| Service Manager | SQL Server 2017 | SQL Server 2019 con aggiornamento cumulativo 8 |
|---|---|---|
| Database di Service Manager/Data Warehouse | • | • |
Nota
System Center 2022 - Service Manager non supporta il parametro MultiSubnetFailover . Questo parametro non viene usato nei stringa di connessione di System Center 2022 - Service Manager.
Consenti aggiornamenti
Per installare o eseguire l'aggiornamento a System Center 2022 - Service Manager, i computer che eseguono SQL Server che ospitano i database devono essere configurati per consentire gli aggiornamenti. Se gli aggiornamenti non sono consentiti, l'installazione di System Center 2022 - Service Manager non verrà completata e nella fase Di creazione del database dell'installazione verrà visualizzato il messaggio di errore seguente:
Si è verificato un errore durante l'esecuzione di un'azione del cliente: _ExecuteSqlScripts. Il tentativo di aggiornamento non è riuscito prima di apportare modifiche permanenti. È stato eseguito il rollback allo stato originale del sistema. Dopo aver apportato le correzioni, è possibile ritentare l'aggiornamento per questo ruolo.
È possibile verificare lo stato di allow updates su SQL Server eseguendo la seguente stored procedure da SQL Server Management Studio:
sp_configure 'allow updates'
Nella tabella dei risultati esaminare il valore per run_value. Se il valore di esecuzione è 1, impostarlo su 0 con la stored procedure seguente e quindi eseguire di nuovo il programma di installazione.
sp_configure 'allow updates',0 reconfigure with override
Considerazioni sui gruppi di disponibilità AlwaysOn per i database di Service Manager
La funzionalità Gruppi di disponibilità AlwaysOn di SQL Server è supportata da System Center 2022 - Service Manager.
Per altre informazioni sull'installazione di Service Manager con i gruppi di disponibilità AlwaysOn, vedere qui.
Eseguire l'aggiornamento a SQL 2017
I passaggi seguenti forniscono informazioni sull'aggiornamento a SQL 2017.
Nota
Il processo di aggiornamento a SQL 2017 disinstalla Reporting Services; assicurarsi di eseguire la migrazione dei report necessari, ad esempio il database di report di backup e le chiavi di crittografia.
Seguire questa procedura per eseguire l'aggiornamento da SQL 2016 a 2017:
- Eseguire l'aggiornamento a SQL 2017.
- Installare SQL 2017 Reporting Services (SSRS), avviare gestione configurazione reporting services per usare il database di report esistente e ripristinare le chiavi di crittografia. Configurare l'URL del servizio Web e l'URL del portale Web.
- Usare gli stessi valori per la directory virtuale del servizio Web di Reporting Server e l'URL del portale Web precedente all'avvio del processo di aggiornamento per SQL 2017.
- Configurare SSRS in base ai dettagli condivisi qui.
- [Facoltativo] Per abilitare clr strict security, eseguire lo script seguente in ognuno dei database di Service Manager. Per impostazione predefinita, clr strict security è disabilitato dopo l'aggiornamento a SQL 2017.
Eseguire l'aggiornamento a SQL 2019
I passaggi seguenti forniscono informazioni sull'aggiornamento a SQL 2019.
Nota
- È necessario usare l'aggiornamento cumulativo 8 (CU8) o versione successiva con SQL 2019.
- Usare ODBC 17.3 da 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
- Il processo di aggiornamento a SQL 2019 disinstalla Reporting Services; assicurarsi di eseguire la migrazione dei report necessari, ad esempio il database di report di backup e le chiavi di crittografia.
Seguire questa procedura per eseguire l'aggiornamento da SQL 2017 a 2019:
- Eseguire l'aggiornamento a SQL 2019.
- Installare SQL 2019 Reporting Services (SSRS), avviare gestione configurazione reporting services per usare il database di report esistente e ripristinare le chiavi di crittografia. Configurare l'URL del servizio Web e l'URL del portale Web.
- Usare gli stessi valori per la directory virtuale del servizio Web reporting server e l'URL del portale Web precedente all'avvio del processo di aggiornamento per SQL 2019.
- Configurare SSRS in base ai dettagli condivisi qui.
- [Facoltativo] Per abilitare clr strict security, eseguire lo script seguente in ognuno dei database di Service Manager. Per impostazione predefinita, clr strict security è disabilitato dopo l'aggiornamento a SQL 2019.
Abilitare clr strict security
Facoltativo. Usare lo script seguente per abilitare clr strict security.
-- 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
Sistema operativo server
Sono supportate le versioni seguenti del sistema operativo Windows Server.
| Componente di System Center | Windows Server 2019 Standard, Datacenter | Windows Server 2019 Server Core | Windows Server 2022 Standard, Datacenter | Windows Server 2022 Server Core |
|---|---|---|---|---|
| Server di gestione di Service Manager | • | • | • | • |
| Server di gestione del data warehouse di Service Manager | • | • | • | • |
| Database di Service Manager o database del data warehouse | • | • | • | • |
| Portale self-service di Service Manager (HTML 5) | • | • | • | • |
Sistema operativo client
Le versioni seguenti del sistema operativo client Windows sono supportate per la console di Service Manager.
| Componenti lato client di System Center | Windows Server® 2019 Standard, Datacenter Enterprise | Windows Server® 2022 Standard, Datacenter | Windows 10 | Windows 11 |
|---|---|---|---|---|
| Console di Service Manager | • | • | • | • |
Versioni di .NET supportate
Le versioni seguenti di .NET sono supportate per Service Manager.
| Componente di 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 |
|---|---|---|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | • | • | • | • | • | • | |||
| Server di gestione del data warehouse di Service Manager | • | • | • | • | • | • | |||
| Console di Service Manager | • | • | • | • | • | • | |||
| Portale self-service di Service Manager | • | • | • | • | • | • |
Versioni di PowerShell supportate
Le versioni seguenti di PowerShell sono supportate per Service Manager.
| Componente di System Center | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|
| Console di Service Manager | • | • |
| Server di gestione di Service Manager | • | • |
| Server di gestione del data warehouse di Service Manager | • | • |
Questo articolo descrive in dettaglio i requisiti di sistema per System Center 2019 - Service Manager (SM).
Requisiti di sistema per System Center 2019 - Service Manager
Le sezioni seguenti descrivono le linee guida generali sulle prestazioni e sulla scalabilità per SM 2019 e consigliano le configurazioni hardware per vari carichi di lavoro. Poiché System Center 2019 è progettato per essere flessibile e scalabile, i requisiti hardware per scenari specifici possono differire dalle linee guida presentate qui.
Limiti di capacità per Service Manager
Per informazioni sui limiti di capacità testati di Service Manager, vedere Configurazioni per scenari di distribuzione.
Coesistenza supportata
Per semplificare gli aggiornamenti, è possibile usare i connettori di Service Manager 2019 con i componenti di System Center seguenti.
- System Center 2016/2019 Virtual Machine Manager
- System Center 2016/2019 Orchestrator
- System Center 2016/2019 Operations Manager
- System Center 2016 Configuration Manager (solo durante lo scenario di migrazione)
- Versioni CB di System Center Configuration Manager
- 1511, 1602, 1606, 1710 e 1802 (supportato con Service Manager 2019 RTM)
- Da 1806 a 2103, 2107 (supportato con Service Manager 2019 UR2 e versioni successive)
Hardware
| Server | Processore (min.) | Processore (cons.) | RAM (min.) | RAM (cons.) | Spazio su disco rigido (min.) | Spazio su disco rigido (cons.) |
|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | CPU 4 core 2,66 GHz | CPU 4 core 2,66 GHz | 8 GB | 8 GB | 10 GB | 10 GB |
| Database di Service Manager | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 32 GB | 80 GB | 80 GB |
| Server di gestione del data warehouse di Service Manager | CPU 4 core 2,66 GHz | CPU 4 core 2,66 GHz | 8 GB | 16 GB | 10 GB | 10 GB |
| Database del data warehouse di Service Manager | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 32 GB | 400 GB | 400 GB |
| Console di Service Manager | CPU 2 core 2 GHz | CPU 2 core 2 GHz | 4 GB | 4 GB | 10 GB | 10 GB |
| Portale self-service di Service Manager (autonomo) | CPU 4 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 16 GB | 80 GB | 80 GB |
| Portale self-service di Service Manager + Server di gestione secondario (scelta consigliata) | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 16 GB | 32 GB | 80 GB | 80 GB |
Requisiti software
| Componente | Requisito |
|---|---|
| Server di gestione di Service Manager | Il server di gestione deve: ADO.NET Aggiornamento di Data Services per .NET Framework 3.5 SP1 per Windows Server; SQL Server Native Client; Microsoft Report Viewer Redistributable, disponibile con il supporto di Service Manager. Il server di gestione deve essere installato in un'edizione a 64 bit di Windows. |
| Server di gestione del data warehouse | Il server di gestione del warehouse richiede: SQL Server Native Client Il server di gestione del data warehouse deve essere installato in un'edizione a 64 bit di Windows. |
| Database di Service Manager/data warehouse | I database di Service Manager o data warehouse richiedono: SQL Server Reporting Services (SSRS); SQL Server Analysis Management Objects. Le impostazioni delle regole di confronto di SQL Server e Analysis Services devono essere identiche per i computer che ospitano il database di Service Manager, il database del data warehouse, il database di Analysis Services e il database di Reporting Services. |
| Console di Service Manager | La console richiede: Microsoft Report Viewer Redistributable (disponibile nel supporto di System Center): Microsoft Excel per visualizzare i cubi di dati OLAP nel computer console; ADO.NET Data Services Update for.NET Framework 3.5 SP1 per Windows Server; SQL Server Analysis Management Objects. La console può essere installata nelle edizioni a 32 bit e a 64 bit di Windows. |
| Portale self-service | Il server Portale self-service richiede: server Windows 2012 R2 o versione successiva; ruolo IIS e ASP.NET 4.5 abilitato; SQL Server Analysis Management Objects. Aggiungere il computer server allo stesso dominio in cui è in esecuzione il servizio SDK di Service Manager. Idealmente, nel server primario o secondario. |
| Computer che usano self-service | Il portale self-service richiede una risoluzione dello schermo superiore a 1024 x 768. Browser supportati: Microsoft Edge; Microsoft Internet Explorer 10 e 11; Mozilla Firefox 42 e versioni successive; Google Chrome 46 e versioni successive. |
| SQL Server Reporting Services | In una topologia di distribuzione in cui il computer che ospita SSRS non si trova nello stesso computer che ospita il server di gestione del data warehouse, è necessario aggiungere Microsoft.EnterpriseManagement.Reporting.Code alla Global Assembly Cache. Informazioni sui passaggi manuali. |
Note aggiuntive
Operations Manager - Service Manager offre la possibilità di importare avvisi e elementi di configurazione da un ambiente Operations Manager. Informazioni sull'installazione sia di Service Manager che di Operations Manager nello stesso ambiente. È possibile creare un data mart per Operations Manager.
Configuration Manager : Service Manager può importare elementi di configurazione da un ambiente di Configuration Manager.
Requisiti di rete: per visualizzare il contenuto esterno dagli articoli della Knowledge Base, i computer che ospitano la console di Service Manager devono avere accesso a Internet, direttamente o tramite un server proxy.
Server SMTP: è necessario avere accesso a un server SMTP (Simple Mail Transfer Protocol) per utilizzare la funzionalità di notifica e per la creazione di eventi imprevisti tramite posta elettronica.
Modalità provvisoria di Windows: Service Manager non funziona e i servizi usati da Service Manager non vengono avviati se Windows Server è in esecuzione in modalità provvisoria. Se si tenta di avviare manualmente i servizi di Service Manager in modalità provvisoria, l'avvio dei servizi non riesce e viene scritto un errore nel registro eventi.
requisiti di SQL Server
Microsoft SQL Server ospita i database creati da System Center - Service Manager. System Center 2019 - Service Manager richiede inoltre che SQL Server Analysis Services (SSAS) funzioni con cubi OLAP (Online Analytical Processing). SQL Server Reporting Services (SSRS) è necessario per supportare la creazione di report di System Center 2019 - Service Manager.
Usare queste informazioni per valutare se l'ambiente SQL Server è pronto per supportare l'installazione o l'aggiornamento a System Center 2019. Usare queste informazioni se si distribuiscono uno o più componenti di System Center.
Nota
Durante l'installazione selezionare Ricerca full-text di SQL Server nei computer che eseguono SQL Server che ospiteranno i database di Service Manager e del data warehouse.
Supporto della versione di SQL Server
Nota
- SM non supporta la modalità SSAS tabulare. Selezionare la modalità SSAS come multidimensionale durante l'installazione di SQL Server.
- Per le versioni supportate di SQL, usare i Service Pack attualmente supportati da Microsoft.
- Service Manager 2019 supporta SQL 2019 con CU8 o versione successiva; tuttavia, non supporta SQL 2019 RTM.
- Con SQL 2019 (CU8 o versione successiva), usare ODBC 17.3 a 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
| Service Manager | SQL Server 2016 e provider di servizi di configurazione | SQL Server 2017 | SQL Server 2019 con aggiornamento cumulativo 8 |
|---|---|---|---|
| Database di Service Manager/Data Warehouse | • | • | • |
Nota
System Center 2019 - Service Manager non supporta il parametro MultiSubnetFailover . Questo parametro non viene usato nelle stringa di connessione di System Center 2019 - Service Manager.
Consenti aggiornamenti
Per installare o aggiornare System Center 2019 - Service Manager, i computer che eseguono SQL Server che ospitano i database devono essere configurati per consentire gli aggiornamenti. Se gli aggiornamenti non sono consentiti, l'installazione di System Center 2019 - Service Manager non verrà completata e nella fase Di creazione del database dell'installazione verrà visualizzato il messaggio di errore seguente:
Si è verificato un errore durante l'esecuzione di un'azione del cliente: _ExecuteSqlScripts. Il tentativo di aggiornamento non è riuscito prima di apportare modifiche permanenti. È stato eseguito il rollback allo stato originale del sistema. Dopo aver apportato le correzioni, è possibile ritentare l'aggiornamento per questo ruolo.
È possibile verificare lo stato di allow updates su SQL Server eseguendo la seguente stored procedure da SQL Server Management Studio:
sp_configure 'allow updates'
Nella tabella dei risultati esaminare il valore per run_value. Se il valore di esecuzione è 1, impostarlo su 0 con la stored procedure seguente e quindi eseguire di nuovo il programma di installazione.
sp_configure 'allow updates',0 reconfigure with override
Considerazioni sui gruppi di disponibilità AlwaysOn per i database di Service Manager
La funzionalità Gruppi di disponibilità AlwaysOn di SQL Server è supportata da System Center 2019 - Service Manager.
Per altre informazioni sull'installazione di Service Manager con i gruppi di disponibilità AlwaysOn, vedere qui.
Eseguire l'aggiornamento a SQL 2017
I passaggi seguenti forniscono informazioni sull'aggiornamento a SQL 2017.
Nota
Il processo di aggiornamento a SQL 2017 disinstalla Reporting Services; assicurarsi di eseguire la migrazione dei report necessari, ad esempio il database di report di backup e le chiavi di crittografia.
Seguire questa procedura per eseguire l'aggiornamento da SQL 2016 a 2017:
- Eseguire l'aggiornamento a SQL 2017.
- Installare SQL 2017 Reporting Services (SSRS), avviare gestione configurazione reporting services per usare il database di report esistente e ripristinare le chiavi di crittografia. Configurare l'URL del servizio Web e l'URL del portale Web.
- Usare gli stessi valori per la directory virtuale del servizio Web di Reporting Server e l'URL del portale Web precedente all'avvio del processo di aggiornamento per SQL 2017.
- Configurare SSRS in base ai dettagli condivisi qui.
- [Facoltativo] Per abilitare clr strict security, eseguire lo script seguente in ognuno dei database di Service Manager. Per impostazione predefinita, clr strict security è disabilitato dopo l'aggiornamento a SQL 2017.
Eseguire l'aggiornamento a SQL 2019
I passaggi seguenti forniscono informazioni sull'aggiornamento a SQL 2019.
Nota
- È necessario usare l'aggiornamento cumulativo 8 (CU8) o versione successiva con SQL 2019.
- Usare ODBC 17.3 da 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
- Il processo di aggiornamento a SQL 2019 disinstalla Reporting Services; assicurarsi di eseguire la migrazione dei report necessari, ad esempio il database di report di backup e le chiavi di crittografia.
Seguire questa procedura per eseguire l'aggiornamento da SQL 2017 a 2019:
- Eseguire l'aggiornamento a SQL 2019.
- Installare SQL 2019 Reporting Services (SSRS) e avviare gestione configurazione reporting services per usare il database di report esistente, ripristinare le chiavi di crittografia. Configurare l'URL del servizio Web e l'URL del portale Web.
- Usare gli stessi valori per la directory virtuale del servizio Web reporting server e l'URL del portale Web precedente all'avvio del processo di aggiornamento per SQL 2019.
- Configurare SSRS in base ai dettagli condivisi qui.
- [Facoltativo] Per abilitare clr strict security, eseguire lo script seguente in ognuno dei database di Service Manager. Per impostazione predefinita, clr strict security è disabilitato dopo l'aggiornamento a SQL 2019.
Abilitare clr strict security
Facoltativo. Usare lo script seguente per abilitare clr strict security.
-- 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
Sistema operativo server
Sono supportate le versioni seguenti del sistema operativo Windows Server.
| Componente di System Center | Windows Server 2016 Standard, Datacenter | Windows Server 2016 Server Core | Windows Server 2019 Standard, Datacenter | Windows Server 2019 Server Core |
|---|---|---|---|---|
| Server di gestione di Service Manager | • | • | • | • |
| Server di gestione del data warehouse di Service Manager | • | • | • | • |
| Database di Service Manager o database del data warehouse | • | • | • | • |
| Portale self-service di Service Manager (HTML 5) | • | • | • | • |
Sistema operativo client
Le versioni seguenti del sistema operativo client Windows sono supportate per la console di Service Manager.
| Componenti lato client di System Center | Windows Server® 2016 Standard, Datacenter Enterprise | Windows Server® 2019 Standard, Data Center | Windows 10 | Windows 11 |
|---|---|---|---|---|
| Console di Service Manager | • | • | • | • |
Versioni di .NET supportate
Le versioni seguenti di .NET sono supportate per Service Manager.
Nota
System Center Service Manager 2019 UR4 e versioni successive supporta .NET 4.8
| Componente di 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 |
|---|---|---|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | • | • | • | • | • | • | |||
| Server di gestione del data warehouse di Service Manager | • | • | • | • | • | • | |||
| Console di Service Manager | • | • | • | • | • | • | |||
| Portale self-service di Service Manager | • | • | • | • | • | • |
Versioni di PowerShell supportate
Le versioni seguenti di PowerShell sono supportate per Service Manager.
| Componente di System Center | Windows PowerShell 2.0 | Windows PowerShell 3.0 | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|---|---|
| Console di Service Manager | • | • | ||
| Server di gestione di Service Manager | • | • | ||
| Server di gestione del data warehouse di Service Manager | • | • |
Questo articolo descrive in dettaglio i requisiti di sistema per System Center 2016 - Service Manager (SM).
Requisiti di sistema per System Center 2016 - Service Manager
Le sezioni seguenti descrivono le linee guida generali sulle prestazioni e sulla scalabilità per SM 2016 e consigliano le configurazioni hardware per vari carichi di lavoro. Poiché System Center 2016 è progettato per essere flessibile e scalabile, i requisiti hardware per scenari specifici possono differire dalle linee guida presentate qui.
Limiti di capacità per Service Manager
Informazioni sui limiti di capacità testati per diversi scenari di distribuzione di Service Manager.
Coesistenza supportata
Per semplificare gli aggiornamenti, è possibile usare i connettori di Service Manager 2016 seguenti con i componenti System Center 2012 R2.
- System Center 2012 R2 Virtual Machine Manager
- System Center 2012 R2 Orchestrator
- System Center 2012 R2 Operations Manager
- System Center 2012 R2 Configuration Manager
- Versioni CB di System Center Configuration Manager (SCCM): 1511, 1602, 1606 e 1710.
- UR5 supporta 1802
- UR9 e UR10 supportano da 1806 a 2103. Tuttavia, esiste una limitazione che le dimensioni dei dispositivi supportati da SCCM devono essere inferiori a 2 PB.
- UR10 supporta 2107
Hardware
| Server | Processore (min.) | Processore (cons.) | RAM (min.) | RAM (cons.) | Spazio su disco rigido (min.) | Spazio su disco rigido (cons.) |
|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | CPU 4 core 2,66 GHz | CPU 4 core 2,66 GHz | 8 GB | 8 GB | 10 GB | 10 GB |
| Database di Service Manager | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 32 GB | 80 GB | 80 GB |
| Server di gestione del data warehouse di Service Manager | CPU 4 core 2,66 GHz | CPU 4 core 2,66 GHz | 8 GB | 16 GB | 10 GB | 10 GB |
| Database del data warehouse di Service Manager | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 32 GB | 400 GB | 400 GB |
| Console di Service Manager | CPU 2 core 2 GHz | CPU 2 core 2 GHz | 4 GB | 4 GB | 10 GB | 10 GB |
| Portale self-service di Service Manager (autonomo) | CPU 4 core 2,66 GHz | CPU 8 core 2,66 GHz | 8 GB | 16 GB | 80 GB | 80 GB |
| Portale self-service di Service Manager + Server di gestione secondario (scelta consigliata) | CPU 8 core 2,66 GHz | CPU 8 core 2,66 GHz | 16 GB | 32 GB | 80 GB | 80 GB |
Sistema operativo server
Sono supportate le versioni seguenti del sistema operativo Windows Server.
| Componente di System Center | Windows Server 2012 Standard, Datacenter | Windows Server 2012 R2 Standard, Datacenter | Windows Server 2016 | Windows Server 2016 (Server con Esperienza desktop) | Windows Server 2016 Nano Server |
|---|---|---|---|---|---|
| Server di gestione di Service Manager | • | • | • | ||
| Server di gestione del data warehouse di Service Manager | • | • | • | ||
| Database di Service Manager o database del data warehouse | • | • | • | ||
| Portale self-service di Service Manager (HTML 5) | • | • | • |
Sistema operativo client
Le versioni seguenti del sistema operativo client Windows sono supportate per la console di Service Manager.
| Componenti lato client di 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 |
|---|---|---|---|---|---|---|---|---|
| Console di Service Manager | • | • | • | • | • | • |
Versioni di .NET
Le versioni seguenti di .NET sono supportate per Service Manager.
| Componente di 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 |
|---|---|---|---|---|---|---|---|---|
| Server di gestione di Service Manager | • | • | • | • | • | |||
| Server di gestione del data warehouse di Service Manager | • | • | • | • | • | |||
| Console di Service Manager | • | • | • | • | • | |||
| Portale self-service di Service Manager | • | • | • | • | • |
Versioni di PowerShell supportate
Le versioni seguenti di PowerShell sono supportate per Service Manager.
| Componente di System Center | Windows PowerShell 2.0 | Windows PowerShell 3.0 | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|---|---|
| Console di Service Manager | • | • | ||
| Server di gestione di Service Manager | • | • | ||
| Server di gestione del data warehouse di Service Manager | • | • |
Requisiti software
| Componente | Requisito |
|---|---|
| Server di gestione di Service Manager | Il server di gestione deve: ADO.NET Aggiornamento di Data Services per .NET Framework 3.5 SP1 per Windows Server; SQL Server Native Client; Microsoft Report Viewer Redistributable, disponibile con il supporto di Service Manager. Il server di gestione deve essere installato in un'edizione a 64 bit di Windows. |
| Server di gestione del data warehouse | Il server di gestione del warehouse richiede: SQL Server Native Client Il server di gestione del data warehouse deve essere installato in un'edizione a 64 bit di Windows. |
| Database di Service Manager/data warehouse | I database di Service Manager o data warehouse richiedono: SQL Server Reporting Services (SSRS); SQL Server Analysis Management Objects. Le impostazioni delle regole di confronto di SQL Server e Analysis Services devono essere identiche per i computer che ospitano il database di Service Manager, il database del data warehouse, il database di Analysis Services e il database di Reporting Services. |
| Console di Service Manager | La console richiede: Microsoft Report Viewer Redistributable (disponibile nel supporto di System Center): Microsoft Excel per visualizzare i cubi di dati OLAP nel computer console; ADO.NET Aggiornamento di Data Services per .NET Framework 3.5 SP1 per Windows Server; SQL Server Analysis Management Objects La console può essere installata nelle edizioni a 32 bit e a 64 bit di Windows. |
| Portale self-service | Il server Portale self-service richiede: server Windows 2012 R2 o versione successiva; ruolo IIS e ASP.NET 4.5 abilitato; SQL Server Analysis Management Objects Aggiungere il computer server allo stesso dominio in cui è in esecuzione il servizio SDK di Service Manager. Idealmente, nel server primario o secondario. |
| Computer che usano self-service | Il portale self-service richiede una risoluzione dello schermo superiore a 1024 x 768. Browser supportati: Microsoft Edge; Microsoft Internet Explorer 10 e 11; Mozilla Firefox 42 e versioni successive; Google Chrome 46 e versioni successive |
| SQL Server Reporting Services | In una topologia di distribuzione in cui il computer che ospita SSRS non si trova nello stesso computer che ospita il server di gestione del data warehouse, è necessario aggiungere Microsoft.EnterpriseManagement.Reporting.Code alla Global Assembly Cache. Informazioni sui passaggi manuali. |
| Operations Manager | Service Manager offre la possibilità di importare avvisi ed elementi di configurazione da un ambiente Operations Manager. Informazioni sull'installazione sia di Service Manager che di Operations Manager nello stesso ambiente. È possibile creare un data mart per Operations Manager. |
| Configuration Manager | Service Manager può importare elementi di configurazione da un ambiente di Configuration Manager. |
| Requisiti di rete | Per visualizzare il contenuto esterno dagli articoli della Knowledge Base, i computer che ospitano la console di Service Manager devono avere accesso a Internet, direttamente o tramite un server proxy. |
| Server SMTP | Per utilizzare la funzionalità di notifica e per la creazione di eventi imprevisti tramite posta elettronica, è necessario avere accesso a un server Simple Mail Transfer Protocol (SMTP). |
| Modalità provvisoria di Windows | Service Manager non funziona e i servizi usati da Service Manager non vengono avviati se Windows Server è in esecuzione in modalità provvisoria. Se si tenta di avviare manualmente i servizi di Service Manager in modalità provvisoria, l'avvio dei servizi non riesce e viene scritto un errore nel registro eventi. |
Microsoft SQL Server ospita i database creati da System Center 2016 - Service Manager. System Center 2016 - Service Manager richiede inoltre che SQL Server Analysis Services (SSAS) funzioni con cubi OLAP (Microsoft Online Analytical Processing). SQL Server Reporting Services (SSRS) è necessario per supportare la creazione di report di System Center 2016 - Service Manager.
Usare queste informazioni per valutare se l'ambiente SQL Server è pronto per supportare l'installazione o l'aggiornamento a System Center 2016. Usare queste informazioni se si distribuiscono uno o più componenti di System Center.
Versioni di SQL Server
La tabella seguente riepiloga il supporto per le versioni Enterprise e Standard di SQL Server a 64 bit.
Nota
Per le versioni supportate di SQL, usare i Service Pack attualmente supportati da Microsoft.
| Service Manager | SQL Server 2012 | SQL Server 2014 e provider di servizi di configurazione | SQL Server 2016 e provider di servizi di configurazione |
|---|---|---|---|
| Database di Service Manager/Data Warehouse | • | • |
- System Center 2016 - Service Manager non supporta l'impostazione del parametro MultiSubnetFailover. Questo parametro non viene usato nelle stringa di connessione di Service Manager.
- I gruppi di disponibilità AlwaysOn di SQL Server sono supportati in System Center 2016 - Service Manager. Altre informazioni.
- Per installare o aggiornare Service Manager, i computer SQL Server che ospitano i database devono essere configurati per consentire gli aggiornamenti. In caso contrario, viene visualizzato un errore quando Service Manager tenta di creare un database:
Si è verificato un errore durante l'esecuzione di un'azione del cliente: _ExecuteSqlScripts. Il tentativo di aggiornamento non è riuscito prima di apportare modifiche permanenti. È stato eseguito il rollback allo stato originale del sistema. Dopo aver apportato le correzioni, è possibile riprovare a eseguire l'aggiornamento per questo ruolo.
È possibile verificare lo stato di allow updates su SQL Server eseguendo la seguente stored procedure da SQL Server Management Studio:
sp_configure 'allow updates'Nella tabella dei risultati, esaminare il valore per "run_value". Se il valore di "valore esecuzione" è 1, reimpostarlo su 0 utilizzando la seguente stored procedure ed eseguire nuovamente l'installazione.
sp_configure 'allow updates',0 reconfigure with override
Passaggi successivi
- Per informazioni sulla vendita al dettaglio e sulle edizioni selezionate di Service Manager e sull'effetto della selezione dell'installazione di valutazione di 180 giorni in queste due edizioni, vedere Edizioni di Service Manager.
- Per informazioni sui limiti testati di Service Manager, vedere Configurazioni per gli scenari di distribuzione.
- Informazioni sulle prestazioni hardware di Service Manager.