Eventos
29 de abr., 14 - 30 de abr., 19
Participe do evento virtual definitivo do Windows Server de 29 a 30 de abril para sessões técnicas aprofundadas e perguntas e respostas ao vivo com engenheiros da Microsoft.
Inscreva-se agora mesmoRequisitos do sistema para o System Center Service Manager
Importante
O SPF (Service Provider Foundation) foi descontinuado do System Center 2025. No entanto, o SPF 2022 continuará a funcionar com os componentes do System Center 2025.
Este artigo detalha os requisitos do sistema para o System Center 2025 – Service Manager (SM).
Observação
Ao contrário das versões anteriores, para o SM 2025, o Objeto de Gerenciamento de Análise foi removido.
As seções a seguir descrevem as diretrizes gerais de desempenho e escalabilidade para o SM 2025 e recomendam as configurações de hardware para várias cargas de trabalho. Como o System Center 2025 foi criado para ser flexível e escalonável, os requisitos de hardware para cenários específicos podem ser diferentes das diretrizes apresentadas aqui.
Leia Configurações para cenários de implantação para saber mais sobre os limites de capacidade testados do Service Manager.
Para ajudar a simplificar as atualizações, você pode usar Service Manager 2025 conectores com os seguintes componentes do System Center.
- Gerenciador de máquinas virtuais do System Center 2022/2025
- Gerente de Operações do System Center 2022/2025
- System Center 2022/2025 Configuration Manager (somente durante o cenário de migração)
- Versões do System Center Configuration Manager CB
- 1511, 1602, 1606, 1710, 1802, 1806 a 2103, 2107, 2111, 2203, 2207, 2211, 2303, 2309, 2403
| Servidores | Processador (min) | Processador (rec) | RAM (min) | RAM (rec) | Espaço em disco rígido (mín.) | Espaço em disco rígido (rec) |
|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | CPU 4-core de 2,66 GHz | CPU 4-core de 2,66 GHz | 8 GB | 8 GB | 10 GB | 10 GB |
| Banco de dados do Service Manager | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 32 GB | 80 GB | 80 GB |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | CPU 4-core de 2,66 GHz | CPU 4-core de 2,66 GHz | 8 GB | 16 GB | 10 GB | 10 GB |
| Bancos de dados de data warehouse do Service Manager | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 32 GB | 400 GB | 400 GB |
| Console do Service Manager | CPU 2-core de 2 GHz | CPU 2-core de 2 GHz | 4 GB | 4 GB | 10 GB | 10 GB |
| Portal de Autoatendimento do Service Manager (autônomo) | CPU 4-core de 2,66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 16 GB | 80 GB | 80 GB |
| Portal de Autoatendimento do Service Manager + Servidor de Gerenciamento Secundário (recomendado) | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 16 GB | 32 GB | 80 GB | 80 GB |
| Componente | Requisito |
|---|---|
| Servidor de gerenciamento do Service Manager | O servidor de gerenciamento precisa: Atualização do ADO.NET Data Services para .NET Framework 3.5 SP1 para Windows Server; Cliente nativo do SQL Server O servidor de gerenciamento deve ser instalado em uma edição de 64 bits do Windows. |
| Servidor de gerenciamento de data warehouse | O servidor de gerenciamento de depósito requer: Cliente nativo do SQL Server O servidor de gerenciamento do data warehouse deve ser instalado em uma edição de 64 bits do Windows. |
| Bancos de dados do Service Manager/data warehouse | Os bancos de dados do Service Manager ou do data warehouse exigem: SQL Server Reporting Services (SSRS). As configurações de agrupamento do SQL Server e do Analysis Services devem ser as mesmas para os computadores que hospedam o banco de dados do Service Manager, o banco de dados do data warehouse, o banco de dados do Analysis Services e o banco de dados do Reporting Services. |
| Console do Service Manager | O console requer: Microsoft Excel para exibir cubos de dados OLAP no computador do console; Atualização do ADO.NET Data Services para .NET Framework 3.5 SP1 para Windows Server. O console pode ser instalado na edição de 64 bits do Windows. |
| Portal de autoatendimento | O servidor do Portal de Autoatendimento requer: Servidor Windows 2016 ou posterior; a função do IIS e o ASP.NET 4.5 habilitado. Ingresse o computador do servidor no mesmo domínio em que o Serviço SDK do Service Manager está em execução. Idealmente, no servidor primário ou secundário. |
| Máquinas que usam autoatendimento | O portal de Autoatendimento precisa de uma resolução de tela acima de 1024 X 768. Navegadores suportados: Microsoft Edge 121 e posterior; Microsoft Internet Explorer 10 e 11; Mozilla Firefox 42 e posterior; Google Chrome 121 e posterior. |
| SQL Server Reporting Services | Em uma topologia de implantação em que o computador que hospeda o SSRS não está no mesmo computador que hospeda o servidor de gerenciamento do data warehouse, você precisa adicionar Microsoft.EnterpriseManagement.Reporting.Code ao cache de assembly global. Saiba mais sobre as etapas manuais. |
Operations Manager – Service Manager tem a capacidade de importar alertas e itens de configuração de um ambiente do Operations Manager. Leia sobre como instalar o Service Manager e o Operations Manager no mesmo ambiente. É possível criar um armazém de dados do Operations manager.
Configuration Manager – o Service Manager pode importar itens de configuração de um ambiente do Configuration Manager.
Requisitos de rede – para exibir conteúdo externo de artigos de conhecimento, os computadores que hospedam o console do Service Manager devem ter acesso à Internet, diretamente ou por meio de um servidor proxy.
Servidor SMTP - Você deve ter acesso a um servidor SMTP (Simple Mail Transfer Protocol) para usar o recurso Notificação e para a criação de incidentes por e-mail.
Modo de segurança do Windows – o Service Manager não funciona e os serviços usados pelo Service Manager não serão iniciados se o Windows Server estiver sendo executado no modo de segurança. Se você tentar iniciar os serviços do Service Manager manualmente enquanto estiver no modo de segurança, os serviços não serão iniciados e um erro será gravado no log de eventos.
O Microsoft SQL Server hospeda os bancos de dados criados pelo System Center – Service Manager. Além disso, o System Center 2025 – Service Manager requer o SQL Server Analysis Services (SSAS) para trabalhar com cubos OLAP (Processamento Analítico Online) da Microsoft. O SQL Server Reporting Services (SSRS) é necessário para dar suporte aos relatórios do System Center 2025 – Service Manager.
Use essas informações para avaliar se o ambiente do SQL Server está pronto para dar suporte à instalação ou atualização para o System Center 2025. Use essas informações se você estiver implantando um ou vários componentes do System Center.
Observação
Durante a instalação, selecione Pesquisa de texto completo do SQL Server nos computadores que executam o SQL Server que hospedarão o Service Manager e os bancos de dados do data warehouse.
Observação
- O SM não dá suporte ao modo SSAS Tabular. Selecione o modo SSAS como Multidimensional durante a instalação do SQL Server.
- Para as versões com suporte do SQL, use os service packs que estão atualmente com suporte da Microsoft.
- Service Manager 2025 dá suporte ao SQL 2019 com CU8 ou posterior; no entanto, ele não dá suporte ao SQL 2019 RTM.
- Com o SQL 2019 (CU8 ou posterior), use ODBC 17.3 a 17.10.6 e MSOLEDBSQL 18.2 a 18.7.2.
| Componente do System Center | SQL Server 2019 com Atualização Cumulativa 8 | SQL Server 2022 |
|---|---|---|
| Service Manager | • | • |
| Banco de dados do Data Warehouse | • | • |
Observação
O System Center 2025 – Service Manager não dá suporte ao parâmetro MultiSubnetFailover . Esse parâmetro não é usado em cadeias de conexão do System Center 2025 – Service Manager.
Para instalar ou atualizar para o System Center 2025 – Service Manager, os computadores que executam o SQL Server que hospedam bancos de dados devem ser configurados para permitir atualizações. Se as atualizações não forem permitidas, a instalação do System Center 2025 – Service Manager não será concluída e a seguinte mensagem de erro será exibida no estágio Criar banco de dados da instalação:
Ocorreu um erro ao executar uma ação do cliente: _ExecuteSqlScripts. Essa tentativa de atualização falhou antes que as modificações permanentes tenham sido feitas. A atualização foi revertida com êxito para o estado original do sistema. Depois que as correções forem feitas, você poderá repetir a atualização para essa função.
Você pode verificar o status de allow updates no SQL Server executando o seguinte procedimento armazenado no SQL Server Management Studio:
sp_configure 'allow updates'
Na tabela de resultados, examine o valor de run_value. Se o valor do valor de execução for 1, defina-o novamente como 0 com o procedimento armazenado a seguir e execute a Instalação novamente.
sp_configure 'allow updates',0 reconfigure with override
A funcionalidade de Grupos de Disponibilidade AlwaysOn do SQL Server é compatível com o System Center 2025 – Service Manager.
Para obter mais informações sobre como instalar o Service Manager com grupos de disponibilidade AlwaysOn, consulte aqui.
As etapas a seguir fornecem informações sobre como atualizar para o SQL 2019.
Observação
- Você deve usar a Atualização Cumulativa 8 (CU8) ou posterior com o SQL 2019.
- Use ODBC 17.3 a 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
- O processo de atualização para o SQL 2019 desinstala os serviços de relatórios; Certifique-se de migrar os relatórios necessários, como backup de relatórios, banco de dados e chaves de criptografia.
Use as seguintes etapas para atualizar do SQL 2017 para 2019:
- Atualize para o SQL 2019.
- Instale o SQL 2019 Reporting Services (SSRS), inicie o gerenciador de configuração do Reporting Services para usar o banco de dados de relatórios existente e restaure as chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
- Use os mesmos valores para o servidor de relatórios, o diretório virtual do serviço Web e a URL do portal da Web que você tinha antes de iniciar o processo de atualização do SQL 2019.
- Configure o SSRS de acordo com os detalhes compartilhados aqui.
- [Opcional] Para habilitar a segurança estrita do CLR, execute o script a seguir em cada um dos bancos de dados do Service Manager. Por padrão, a segurança estrita do CLR é desabilitada após a atualização para o SQL 2019.
As etapas a seguir fornecem informações sobre como atualizar para o SQL 2022.
Observação
- Você deve usar a Atualização Cumulativa 8 (CU8) ou posterior com o SQL 2022.
- Use ODBC 17.3 a 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
- O processo de atualização para o SQL 2022 desinstala os serviços de relatórios; Certifique-se de migrar os relatórios necessários, como backup de relatórios, banco de dados e chaves de criptografia.
Use as seguintes etapas para atualizar do SQL 2019 para 2022:
- Atualize para o SQL 2022.
- Instale o SQL 2022 Reporting Services (SSRS), inicie o gerenciador de configuração do Reporting Services para usar o banco de dados de relatórios existente e restaure as chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
- Use os mesmos valores para o servidor de relatórios, o diretório virtual do serviço Web e a URL do portal da Web que você tinha antes de iniciar o processo de atualização do SQL 2022.
- Configure o SSRS de acordo com os detalhes compartilhados aqui.
- [Opcional] Para habilitar a segurança estrita do CLR, execute o script a seguir em cada um dos bancos de dados do Service Manager. Por padrão, a segurança estrita do CLR é desabilitada após a atualização para o SQL 2022.
Opcional. Use o script a seguir para habilitar a segurança estrita do CLR.
-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash1 BINARY(64), @ClrName1 NVARCHAR(4000);
set @Hash1 = HASHBYTES(N'SHA2_512', 0x4d5a90000300000004000000ffff0000b800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000e1fba0e00b409cd21b8014ccd21546869732070726f6772616d2063616e6e6f742062652072756e20696e20444f53206d6f64652e0d0d0a2400000000000000504500004c010300cdef7c440000000000000000e0000e210b010800000c000000080000000000005e2b000000200000004000000000ec560020000000020000040000000000000004000000000000000080000000020000f2f10000030000040000100000100000000010000010000000000000100000000000000000000000042b000057000000004000001005000000000000000000000000000000000000006000000c0000008c2a00001c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002e74657874000000640b000000200000000c000000020000000000000000000000000000200000602e72737263000000100500000040000000060000000e0000000000000000000000000000400000402e72656c6f6300000c0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000402b0000000000004800000002000500082100008409000009000000000000000000000000000000502000008000000000000000000000000000000000000000000000000000000000000000000000000c506f2ef337d14f0bc66e27fa02006623253f6655697a25078f76132dfd4cf9ec02d54581a9310a12538c2a82f19f230bbe2ac6017a095a82147a15f65488b5b38c9612cfc2c228f748d5519b4981a836189698e99b7f54961091fbb404afb93ab9d8110f22652ab16e7ff50f9dfb4236d78f61e93555018ba85d95c28cb5452a02281000000a0000002a00133003001e00000001000011000214fe0116fe010b072d0500160a2b0b02031e281200000a0a2b00062a000042534a4201000100000000000c00000076322e302e35303732370000000005006c0000001c020000237e0000880200003c03000023537472696e677300000000c40500000800000023555300cc050000100000002347554944000000dc050000a803000023426c6f620000000000000002000001471502000900000000fa0133001600000100000014000000020000000200000002000000120000000e00000001000000010000000300000000000a00010000000000060084007d000600c900aa000600d700aa000600fd00eb0006001601eb0006003101eb0006005001eb0006006d01eb0006008401eb0006009f01eb000600b801eb000600d101eb000600ee01eb0006001a0207023b002e02000006005d023d0206007d023d020a00df02c4020e00210302030e00270302030000000001000000000001000100010110002b004600050001000100d0200000000081188b000a000100dc2000000000960091000e00010000000100f40200000200fa0211008b00140019008b00190021008b00140029008b00140031008b00140039008b00140041008b00140049008b00140051008b00140059008b00140061008b00140069008b00140071008b001e0081008b00240089008b000a0009008b000a0091008b000a009900340336022e003b00ac022e000b0043022e0013006d022e0023006d022e002b006d022e00330073022e0053004a032e004300e4022e004b0025032e006b0075032e007b0087032e005b0065032e0073007e0340008b00cb003e020480000006000000f50f00000100000029009b02000002000000000000000000000001007400000000000200000000000000000000000100b8020000000002000000000000000000000001007d00000000000000003c4d6f64756c653e004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e646c6c00526567756c617245787072657373696f6e4576616c7561746f72004d6963726f736f66742e456e74657270726973654d616e6167656d656e742e446174614163636573732e53716c006d73636f726c69620053797374656d004f626a656374002e63746f72004d617463686573526567756c617245787072657373696f6e0053797374656d2e52756e74696d652e496e7465726f705365727669636573004775696441747472696275746500436f6d56697369626c654174747269627574650053797374656d2e5265666c656374696f6e00417373656d626c7943756c7475726541747472696275746500417373656d626c7954726164656d61726b41747472696275746500417373656d626c79436f6e66696775726174696f6e41747472696275746500417373656d626c794465736372697074696f6e41747472696275746500417373656d626c795469746c6541747472696275746500417373656d626c79436f7079726967687441747472696275746500417373656d626c7950726f6475637441747472696275746500417373656d626c79436f6d70616e7941747472696275746500417373656d626c7946696c6556657273696f6e41747472696275746500417373656d626c7956657273696f6e4174747269627574650053797374656d2e446961676e6f73746963730044656275676761626c6541747472696275746500446562756767696e674d6f6465730053797374656d2e52756e74696d652e436f6d70696c6572536572766963657300436f6d70696c6174696f6e52656c61786174696f6e734174747269627574650052756e74696d65436f6d7061746962696c697479417474726962757465004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c0053797374656d2e44617461004d6963726f736f66742e53716c5365727665722e5365727665720053716c46756e6374696f6e41747472696275746500696e707574007061747465726e0053797374656d2e546578742e526567756c617245787072657373696f6e730052656765780052656765784f7074696f6e730049734d61746368000003200000000000a79e22af2016204a81c804d4f9bce8010008b77a5c561934e08903200001050002020e0e042001010e042001010205200101113d042001010880a000240000048000009400000006020000002400005253413100040000010001004ddb14fd25fa54ef1fe05516d69c0bb19c86956e2d5245e728300417e6a018daac56b61ee215e4c096dba942368bb4aa76956042bb3efb709cda847d7396839f57a40b90829fe5f347a5d2e2c198367cbc1092aa9762ae9776e59fed16703887329ffeb6d6cbf44853c496a22bc79bb3ce00f29760995dafa6aa97779983e0b48169010005005455794d6963726f736f66742e53716c5365727665722e5365727665722e446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038390a446174614163636573730000000054020f497344657465726d696e69737469630154020949735072656369736501540e044e616d651b666e5f4d617463686573526567756c617245787072657373696f6e54557f4d6963726f736f66742e53716c5365727665722e5365727665722e53797374656d446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038391053797374656d4461746141636365737300000000070003020e0e115104070202022901002433333532323533352d393332652d346130342d623965302d30616330383630353137663300000501000000003801003353716c436c722066756e6374696f6e616c697479207573656420627920746865206461746120616363657373206c617965722e0000370100324d6963726f736f66742e456e74657270726973654d616e6167656d656e742e53716c2e446174614163636573734c6179657200004001003b436f707972696768742032303035204d6963726f736f667420436f72706f726174696f6e2e2020416c6c207269676874732072657365727665642e00002401001f4d6963726f736f6674204f7065726174696f6e73204d616e6167657220763300001a0100154d6963726f736f667420436f72706f726174696f6e00000f01000a362e302e343038352e3000000801000701000000000801000800000000001e01000100540216577261704e6f6e457863657074696f6e5468726f777301000000000000cdef7c44000000000200000059000000a82a0000a80c000052534453165649e3ed4a514990cc3fb2ca36648a01000000643a5c6d6f6d76332e6d61696e5c7461726765745c64656275675c693338365c4d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e706462000000002c2b000000000000000000004e2b0000002000000000000000000000000000000000000000000000402b00000000000000000000000000000000000000005f436f72446c6c4d61696e006d73636f7265652e646c6c0000000000ff250020ec5600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000b80400000000000000000000b80434000000560053005f00560045005200530049004f004e005f0049004e0046004f0000000000bd04effe00000100000006000000f50f000006000000f50f3f000000000000000400000002000000000000000000000000000000440000000100560061007200460069006c00650049006e0066006f00000000002400040000005400720061006e0073006c006100740069006f006e00000000000000b00418040000010053007400720069006e006700460069006c00650049006e0066006f000000f4030000010030003000300030003000340062003000000080003400010043006f006d006d0065006e00740073000000530071006c0043006c0072002000660075006e006300740069006f006e0061006c0069007400790020007500730065006400200062007900200074006800650020006400610074006100200061006300630065007300730020006c0061007900650072002e0000004c001600010043006f006d00700061006e0079004e0061006d006500000000004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e000000900033000100460069006c0065004400650073006300720069007000740069006f006e00000000004d006900630072006f0073006f00660074002e0045006e00740065007200700072006900730065004d0061006e006100670065006d0065006e0074002e00530071006c002e0044006100740061004100630063006500730073004c0061007900650072000000000038000b000100460069006c006500560065007200730069006f006e000000000036002e0030002e0034003000380035002e0030000000000064002100010049006e007400650072006e0061006c004e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c00000000009c003c0001004c006500670061006c0043006f007000790072006900670068007400000043006f0070007900720069006700680074002000320030003000350020004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e002e002000200041006c006c0020007200690067006800740073002000720065007300650072007600650064002e0000006c00210001004f0072006900670069006e0061006c00460069006c0065006e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c0000000000600020000100500072006f0064007500630074004e0061006d006500000000004d006900630072006f0073006f006600740020004f007000650072006100740069006f006e00730020004d0061006e00610067006500720020007600330000003c000b000100500072006f006400750063007400560065007200730069006f006e00000036002e0030002e0034003000380035002e0030000000000040000b00010041007300730065006d0062006c0079002000560065007200730069006f006e00000036002e0030002e0034003000380035002e00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000c000000603b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set @ClrName1 = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.DataAccessLayer');
-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName1)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash1
END
--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash1, @ClrName1
END
GO
-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash BINARY(64), @ClrName NVARCHAR(4000);
set @Hash = HASHBYTES(N'SHA2_512', 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006182CF4B0000000000000000E00002210B010800001600000008000000000000BE3400000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000006834000053000000004000006004000000000000000000000000000000000000006000000C000000B83300001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000C4140000002000000016000000020000000000000000000000000000200000602E7273726300000060040000004000000006000000180000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001E00000000000000000000000000004000004200000000000000000000000000000000A0340000000000004800000002000500DC250000DC0D00000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000360002731000000A7D010000042A0000133002002D00000001000011000F01281100000A16FE010A062D03002B1A027B010000040F01281200000A6F1300000A1F2C6F1400000A262A5200027B01000004037B010000046F1500000A262A0000133004004C00000002000011007E1600000A0A027B010000042C13027B010000046F1700000A16FE0216FE012B01170C082D1A027B0100000416027B010000046F1700000A17596F1800000A0A06731900000A0B2B00072A133003002900000001000011000314FE0116FE010A062D0B7201000070731A00000A7A02036F1B00000A731C00000A7D010000042A000000133002002A00000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03027B010000046F1D00000A6F1E00000A002A1E02281F00000A2A5602281F00000A000002732100000A7D02000004002A133002002F000000010000110228080000060000032C0E036F2200000A16FE0216FE012B01170A062D0F00027B02000004036F2300000A0000002A001B3003007600000003000011007E1600000A0A00027B020000046F2400000A0D2B1C1203282500000A0B00067209000070076F1D00000A282600000A0A001203282700000A130411042DD7DE0F1203FE160300001B6F2800000A00DC0006282900000A16FE01130411042D09007E1600000A0C2B0B0006176F2A00000A0C2B00082A000001100000020014002D41000F0000000013300200140000000100001100027B020000046F2B00000A16FE010A2B00062A133001000B000000040000110073080000060A2B00062A00133004008100000005000011000F00281200000A0A0F00281100000A2D10066F2C00000A282900000A16FE012B0116130411042D08280C0000060D2B4E06178D2100000113051105161F2C9D1105176F2D00000A0B160C2B1600070807089A6F2C00000A6F2E00000AA2000817580C08078E69FE04130411042DDE07280100002B000773090000060D2B00092A00000013300100110000000600001100027B020000046F2B00000A0A2B00062A0000001B300300560000000700001100160A00027B020000046F2400000A0D2B1F1203282500000A0B0007031B283100000A0A0616FE01130411042D022B0E001203282700000A130411042DD4DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010003040000F000000001B300200520000000700001100170A00037B020000046F2400000A0D2B1B1203282500000A0B000207280F0000060A06130411042D022B0E001203282700000A130411042DD8DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010002C3C000F0000000013300200170000000800001100020328130000060A066F0B00000616FE010B2B00072A001B300200670000000900001100027B0200000473090000060A00037B020000046F2400000A0D2B261203282500000A0B0006076F0F000006130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCDDE0F1203FE160300001B6F2800000A00DC00060C2B00082A000110000002001A003751000F000000001B30020064000000090000110073080000060A00037B020000046F2400000A0D2B291203282500000A0B0002076F0F00000616FE01130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCADE0F1203FE160300001B6F2800000A00DC00060C2B00082A01100000020014003A4E000F0000000013300400410000000A000011000314FE0116FE010C082D0B7201000070731A00000A7A036F1B00000A0A06178D210000010D09161F2C9D09176F2D00000A0B027B02000004076F2300000A002A000000133002002500000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03026F1D00000A6F1E00000A002A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000014050000237E000080050000A805000023537472696E677300000000280B00001000000023555300380B0000100000002347554944000000480B00009402000023426C6F6200000000000000020000015717A2090908000000FA01330016000001000000250000000300000002000000150000000F0000000300000032000000110000000A0000000100000002000000020000000300000001000000020000000100000000000A0001000000000006009C0095000A00CA00AF000A00F000DB0006000601FA000A002C01DB0006005B01510106006D0151010600A10186010600B001860106006902570206008002570206009D0257020600BC0257020600D50257020600EE02570206000903570206002403570206005C033D0306007003570206009C0389035300B00300000600DF03BF030600FF03BF0306001D0495000A003304AF000A005404AF0006006C0495000600840495000A00A504AF000600CB0486012300E204000006001705950006004805950006004D05950006006E0595000A007905AF0006008C059500000000000100000000000100010001201000450051000500010001000120100088005100050002000800010014010A000100A8012F00502000000000860027010E00010060200000000086003601120001009920000000008600410118000200B02000000000860047011E000300082100000000E601680123000300402100000000E6017A0129000400762100000000861880010E0005007E2100000000861880010E0005009421000000008618800136000500D02100000000C600BE013F000600642200000000E609C701430006008422000000009608D201470006009C22000000009600DB014C0006002C23000000008600E101530007004C23000000008600E70157000700C023000000008600EB015C0008003024000000008600F4015C0009005424000000009600FD0162000A00D824000000009600030262000C00582500000000E601680123000E00A82500000000E6017A0129000F00000001001902000001001F02000001002502000001002702000001002902000001003102000001003302000001003B02000001004202000001004A02000002005002000001004A020000020050020000010025020000010027020200090003000D0003000900510080017400590080017400610080017400690080017400710080017400790080017400810080017400890080017400910080017900990080017400A10080017E00B10080018400B90080010E00C10080010E00C90080018900210080010E002900C701430029005B043F0021006504F10021006504F700210065040101D900730407012100790453002100BE010A01290080017400E1008001740031009A043F002100800174000900BE013F0039007A017400090080010E00E900800189000C0080010E001400C10453000C00D9044F010C00ED0459011C00FB046801D90007056D011C000E054300010123050E00D9002B057401D900390579010C00C1045300D90043053F00D90060058F01D90066053F00190174059901210180010E00D9009D05DA010C00A405F5012E001B002B022E006B0073022E000B0012022E0013002B022E00230031022E002B0012022E00330040022E003B002B022E004B002B022E005B0061022E0063006A0243007B008F00630003011701C0018301B101E0018301B10100028301B10120028301B101FD0010017E018A01A501D601E301EF01FB0109020300010000000D026B00000014026F0002000B00030002000C0005004301490162010480000001000000B30EF0680000000000005100000002000000000000000000000001008C00000000000200000000000000000000000100A300000000005F00A10100000000003C4D6F64756C653E004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E646C6C00436F6E636174656E617465004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E6564446174615479706500536574006D73636F726C69620053797374656D004F626A6563740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E446174612E53716C547970657300494E756C6C61626C650053797374656D2E5465787400537472696E674275696C64657200696E7465726D656469617465526573756C7400496E69740053716C537472696E6700416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465002E63746F720053797374656D2E436F6C6C656374696F6E732E47656E65726963004C6973746031006D656D626572730049436F6C6C656374696F6E603100546F537472696E67006765745F49734E756C6C006765745F4E756C6C00506172736500436F756E740048617300496E636C7564657300496E436F6D6D6F6E00556E696F6E00496E746572736563740049734E756C6C004E756C6C0076616C7565006F7468657200720077006F626A65637473007300656C656D656E740073756273657400616E6F74686572006669727374007365636F6E640053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174006765745F56616C756500417070656E6400537472696E6700456D707479006765745F4C656E67746800417267756D656E744E756C6C457863657074696F6E0052656164537472696E670053716C55736572446566696E656454797065417474726962757465006765745F436F756E740049456E756D657261626C6560310041646452616E676500456E756D657261746F7200476574456E756D657261746F72006765745F43757272656E7400436F6E636174004D6F76654E6578740049446973706F7361626C6500446973706F73650049734E756C6C4F72456D70747900537562737472696E67005472696D004368617200537472696E6753706C69744F7074696F6E730053706C697400546F4C6F77657200417272617900536F72740053716C4D6574686F6441747472696275746500537472696E67436F6D70617269736F6E00457175616C730041646400000372000003770000032C0000000000988CD7764C980A49A3DB04E0EFC50A160008B77A5C561934E0890306121103200001052001011115052001011208042000111505200101121905200101121D0606151221010E08200101151225010E0320000E03200002040000120C060001120C111503200008042001020E05200102120C080002120C120C120C03280002040800120C042001010E042001010205200101115504200101080520010111696101000200000004005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F000005200112110E0520011211030307010205200112111C02060E0520020E08080607030E1115022B010002000000020054080B4D61784279746553697A65401F000054020D4973427974654F7264657265640105151221010E05151225010E0920010115127901130008200015117D0113000515117D010E04200013000600030E0E0E0E040001020E0420010E080B07050E0E0E15117D010E02040701120C0920021D0E1D0311808907100101011D1E00030A010E0B07060E1D0E08120C021D03240100020054020F497344657465726D696E6973746963015402094973507265636973650103070108080003020E0E1180950B0705020E0215117D010E02050702120C020520010113000D0705120C0E120C15117D010E020807040E1D0E021D031801001355736572446566696E6564446174615479706500000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313000000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000006182CF4B000000000200000091000000D4330000D415000052534453E34F9E44F81FB94E95CF281C5235867A01000000443A5C50726F6A656374735C55736572446566696E656444617461547970655C55736572446566696E656444617461547970655C6F626A5C44656275675C4D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E70646200000000903400000000000000000000AE340000002000000000000000000000000000000000000000000000A034000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000080400000000000000000000080434000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE0000010000000100F068B30E00000100F068B30E3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00468030000010053007400720069006E006700460069006C00650049006E0066006F00000044030000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000500014000100460069006C0065004400650073006300720069007000740069006F006E0000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0033003700360033002E00320036003800360034000000000098003B00010049006E007400650072006E0061006C004E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C00000000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F00660074002000320030003100300000000000A0003B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C0000000000480014000100500072006F0064007500630074004E0061006D00650000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0033003700360033002E00320036003800360034000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0033003700360033002E0032003600380036003400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000C03400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set @ClrName = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.UserDefinedDataType');
-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash
END
--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash, @ClrName
END
GO
As seguintes versões do sistema operacional Windows Server são suportadas.
| Componente do 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 |
|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | • | • | • | • | • | • |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • | • | • | • | • |
| Banco de dados do Service Manager ou banco de dados do data warehouse | • | • | • | • | • | • |
| Portal de Autoatendimento do Service Manager (HTML 5) | • | • | • | • | • | • |
As seguintes versões do sistema operacional cliente Windows têm suporte para o console do Service Manager.
| Componentes no lado do cliente do System Center | Windows Server® 2019 Standard, Datacenter Enterprise | Windows Server® 2022 Standard, Datacenter Enterprise | Windows Server® 2025 Standard, Datacenter | Windows 10 | Windows 11 |
|---|---|---|---|---|---|
| Console do Service Manager | • | • | • | • | • |
As versões a seguir do .NET têm suporte para Service Manager.
| Componente do 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 |
|---|---|---|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | • | • | • | • | • | • | |||
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • | • | • | • | • | |||
| Console do Service Manager | • | • | • | • | • | • | |||
| Portal de autoatendimento do Service Manager | • | • | • | • | • | • |
As seguintes versões do PowerShell têm suporte para Service Manager.
| Componente do System Center | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|
| Console do Service Manager | • | • |
| Servidor de Gerenciamento do Service Manager | • | • |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • |
Este artigo detalha os requisitos do sistema para o System Center 2022 – Service Manager (SM).
Observação
Ao contrário das versões anteriores, para o SM 2022, você não precisa instalar manualmente as ferramentas /do Visualizador de Relatórios Microsoft CLR Types para SQL Server 2014 como pré-requisito.
As seções a seguir descrevem as diretrizes gerais de desempenho e escalabilidade para o SM 2022 e recomendam as configurações de hardware para várias cargas de trabalho. Como o System Center 2022 foi criado para ser flexível e escalonável, os requisitos de hardware para cenários específicos podem ser diferentes das diretrizes apresentadas aqui.
Leia Configurações para cenários de implantação para saber mais sobre os limites de capacidade testados do Service Manager.
Para ajudar a simplificar as atualizações, você pode usar Service Manager 2022 conectores com os seguintes componentes do System Center.
- Gerenciador de máquinas virtuais do System Center 2019/2022
- Orquestrador do System Center 2019/2022
- Gerente de Operações do System Center 2019/2022
- System Center 2019/2022 Configuration Manager (somente durante o cenário de migração)
- Versões do System Center Configuration Manager CB
- 1511, 1602, 1606, 1710, 1802, 1806 a 2103, 2107
| Servidores | Processador (min) | Processador (rec) | RAM (min) | RAM (rec) | Espaço em disco rígido (mín.) | Espaço em disco rígido (rec) |
|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | CPU 4-core de 2,66 GHz | CPU 4-core de 2,66 GHz | 8 GB | 8 GB | 10 GB | 10 GB |
| Banco de dados do Service Manager | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 32 GB | 80 GB | 80 GB |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | CPU 4-core de 2,66 GHz | CPU 4-core de 2,66 GHz | 8 GB | 16 GB | 10 GB | 10 GB |
| Bancos de dados de data warehouse do Service Manager | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 32 GB | 400 GB | 400 GB |
| Console do Service Manager | CPU 2-core de 2 GHz | CPU 2-core de 2 GHz | 4 GB | 4 GB | 10 GB | 10 GB |
| Portal de Autoatendimento do Service Manager (autônomo) | CPU 4-core de 2,66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 16 GB | 80 GB | 80 GB |
| Portal de Autoatendimento do Service Manager + Servidor de Gerenciamento Secundário (recomendado) | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 16 GB | 32 GB | 80 GB | 80 GB |
| Componente | Requisito |
|---|---|
| Servidor de gerenciamento do Service Manager | O servidor de gerenciamento precisa: Atualização do ADO.NET Data Services para .NET Framework 3.5 SP1 para Windows Server; Cliente nativo do SQL Server O servidor de gerenciamento deve ser instalado em uma edição de 64 bits do Windows. |
| Servidor de gerenciamento de data warehouse | O servidor de gerenciamento de depósito requer: Cliente nativo do SQL Server O servidor de gerenciamento do data warehouse deve ser instalado em uma edição de 64 bits do Windows. |
| Bancos de dados do Service Manager/data warehouse | Os bancos de dados do Service Manager ou do data warehouse exigem: SQL Server Reporting Services (SSRS); Objetos de gerenciamento de análise do SQL Server. As configurações de agrupamento do SQL Server e do Analysis Services devem ser as mesmas para os computadores que hospedam o banco de dados do Service Manager, o banco de dados do data warehouse, o banco de dados do Analysis Services e o banco de dados do Reporting Services. |
| Console do Service Manager | O console requer: Microsoft Excel para exibir cubos de dados OLAP no computador do console; Atualização de Serviços de Dados do ADO.NET para .NET Framework 3.5 SP1 para Windows Server; Objetos de gerenciamento de análise do SQL Server. O console pode ser instalado na edição de 64 bits do Windows. |
| Portal de autoatendimento | O servidor do Portal de Autoatendimento requer: Servidor Windows 2016 ou posterior; a função do IIS e o ASP.NET 4.5 habilitados; Objetos de gerenciamento de análise do SQL Server. Ingresse o computador do servidor no mesmo domínio em que o Serviço SDK do Service Manager está em execução. Idealmente, no servidor primário ou secundário. |
| Máquinas que usam autoatendimento | O portal de Autoatendimento precisa de uma resolução de tela acima de 1024 X 768. Navegadores suportados: Microsoft Edge; Microsoft Internet Explorer 10 e 11; Mozilla Firefox 42 e posterior; Google Chrome 46 e posterior. |
| SQL Server Reporting Services | Em uma topologia de implantação em que o computador que hospeda o SSRS não está no mesmo computador que hospeda o servidor de gerenciamento do data warehouse, você precisa adicionar Microsoft.EnterpriseManagement.Reporting.Code ao cache de assembly global. Saiba mais sobre as etapas manuais. |
Operations Manager – Service Manager tem a capacidade de importar alertas e itens de configuração de um ambiente do Operations Manager. Leia sobre como instalar o Service Manager e o Operations Manager no mesmo ambiente. É possível criar um armazém de dados do Operations manager.
Configuration Manager – o Service Manager pode importar itens de configuração de um ambiente do Configuration Manager.
Requisitos de rede – para exibir conteúdo externo de artigos de conhecimento, os computadores que hospedam o console do Service Manager devem ter acesso à Internet, diretamente ou por meio de um servidor proxy.
Servidor SMTP - Você deve ter acesso a um servidor SMTP (Simple Mail Transfer Protocol) para usar o recurso Notificação e para a criação de incidentes por e-mail.
Modo de segurança do Windows – o Service Manager não funciona e os serviços usados pelo Service Manager não serão iniciados se o Windows Server estiver sendo executado no modo de segurança. Se você tentar iniciar os serviços do Service Manager manualmente enquanto estiver no modo de segurança, os serviços não serão iniciados e um erro será gravado no log de eventos.
O Microsoft SQL Server hospeda os bancos de dados criados pelo System Center – Service Manager. Além disso, o System Center 2022 – Service Manager requer o SSAS (SQL Server Analysis Services) para trabalhar com cubos OLAP (Processamento Analítico Online) da Microsoft. O SQL Server Reporting Services (SSRS) é necessário para dar suporte aos relatórios do System Center 2022 – Service Manager.
Use essas informações para avaliar se o ambiente do SQL Server está pronto para dar suporte à instalação ou atualização para o System Center 2022. Use essas informações se você estiver implantando um ou vários componentes do System Center.
Observação
Durante a instalação, selecione Pesquisa de texto completo do SQL Server nos computadores que executam o SQL Server que hospedarão o Service Manager e os bancos de dados do data warehouse.
Observação
- O SM não dá suporte ao modo SSAS Tabular. Selecione o modo SSAS como Multidimensional durante a instalação do SQL Server.
- Para as versões com suporte do SQL, use os service packs que estão atualmente com suporte da Microsoft.
- Service Manager 2022 dá suporte ao SQL 2019 com CU8 ou posterior; no entanto, ele não dá suporte ao SQL 2019 RTM.
- Com o SQL 2019 (CU8 ou posterior), use ODBC 17.3 a 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
| Service Manager | SQL Server 2017 | SQL Server 2019 com Atualização Cumulativa 8 |
|---|---|---|
| Banco de dados do Service Manager/Data Warehouse | • | • |
Observação
O System Center 2022 – Service Manager não dá suporte ao parâmetro MultiSubnetFailover . Esse parâmetro não é usado nas cadeias de conexão do System Center 2022 – Service Manager.
Para instalar ou atualizar para o System Center 2022 – Service Manager, os computadores que executam o SQL Server que hospedam bancos de dados devem ser configurados para permitir atualizações. Se as atualizações não forem permitidas, a Instalação do System Center 2022 – Service Manager não será concluída e a seguinte mensagem de erro será exibida no estágio Criar banco de dados da instalação:
Ocorreu um erro ao executar uma ação do cliente: _ExecuteSqlScripts. Essa tentativa de atualização falhou antes que as modificações permanentes tenham sido feitas. A atualização foi revertida com êxito para o estado original do sistema. Depois que as correções forem feitas, você poderá repetir a atualização para essa função.
Você pode verificar o status de allow updates no SQL Server executando o seguinte procedimento armazenado no SQL Server Management Studio:
sp_configure 'allow updates'
Na tabela de resultados, examine o valor de run_value. Se o valor do valor de execução for 1, defina-o novamente como 0 com o procedimento armazenado a seguir e execute a Instalação novamente.
sp_configure 'allow updates',0 reconfigure with override
A funcionalidade de Grupos de Disponibilidade AlwaysOn do SQL Server é compatível com o System Center 2022 – Service Manager.
Para obter mais informações sobre como instalar o Service Manager com grupos de disponibilidade AlwaysOn, consulte aqui.
As etapas a seguir fornecem informações sobre como atualizar para o SQL 2017.
Observação
O processo de atualização para o SQL 2017 desinstala os serviços de relatórios; Certifique-se de migrar os relatórios necessários, como backup de relatórios, banco de dados e chaves de criptografia.
Use as seguintes etapas para atualizar do SQL 2016 para o 2017:
- Atualize para o SQL 2017.
- Instale o SQL 2017 Reporting Services (SSRS), inicie o gerenciador de configuração do Reporting Services para usar o banco de dados de relatórios existente e restaure as chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
- Use os mesmos valores para o servidor de relatórios, o diretório virtual do serviço Web e a URL do portal da Web que você tinha antes de iniciar o processo de atualização do SQL 2017.
- Configure o SSRS de acordo com os detalhes compartilhados aqui.
- [Opcional] Para habilitar a segurança estrita do CLR, execute o script a seguir em cada um dos bancos de dados do Service Manager. Por padrão, a segurança estrita do CLR é desabilitada após a atualização para o SQL 2017.
As etapas a seguir fornecem informações sobre como atualizar para o SQL 2019.
Observação
- Você deve usar a Atualização Cumulativa 8 (CU8) ou posterior com o SQL 2019.
- Use ODBC 17.3 a 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
- O processo de atualização para o SQL 2019 desinstala os serviços de relatórios; Certifique-se de migrar os relatórios necessários, como backup de relatórios, banco de dados e chaves de criptografia.
Use as seguintes etapas para atualizar do SQL 2017 para 2019:
- Atualize para o SQL 2019.
- Instale o SQL 2019 Reporting Services (SSRS), inicie o gerenciador de configuração do Reporting Services para usar o banco de dados de relatórios existente e restaure as chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
- Use os mesmos valores para o servidor de relatórios, o diretório virtual do serviço Web e a URL do portal da Web que você tinha antes de iniciar o processo de atualização do SQL 2019.
- Configure o SSRS de acordo com os detalhes compartilhados aqui.
- [Opcional] Para habilitar a segurança estrita do CLR, execute o script a seguir em cada um dos bancos de dados do Service Manager. Por padrão, a segurança estrita do CLR é desabilitada após a atualização para o SQL 2019.
Opcional. Use o script a seguir para habilitar a segurança estrita do CLR.
-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash1 BINARY(64), @ClrName1 NVARCHAR(4000);
set @Hash1 = HASHBYTES(N'SHA2_512', 0x4d5a90000300000004000000ffff0000b800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000e1fba0e00b409cd21b8014ccd21546869732070726f6772616d2063616e6e6f742062652072756e20696e20444f53206d6f64652e0d0d0a2400000000000000504500004c010300cdef7c440000000000000000e0000e210b010800000c000000080000000000005e2b000000200000004000000000ec560020000000020000040000000000000004000000000000000080000000020000f2f10000030000040000100000100000000010000010000000000000100000000000000000000000042b000057000000004000001005000000000000000000000000000000000000006000000c0000008c2a00001c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002e74657874000000640b000000200000000c000000020000000000000000000000000000200000602e72737263000000100500000040000000060000000e0000000000000000000000000000400000402e72656c6f6300000c0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000402b0000000000004800000002000500082100008409000009000000000000000000000000000000502000008000000000000000000000000000000000000000000000000000000000000000000000000c506f2ef337d14f0bc66e27fa02006623253f6655697a25078f76132dfd4cf9ec02d54581a9310a12538c2a82f19f230bbe2ac6017a095a82147a15f65488b5b38c9612cfc2c228f748d5519b4981a836189698e99b7f54961091fbb404afb93ab9d8110f22652ab16e7ff50f9dfb4236d78f61e93555018ba85d95c28cb5452a02281000000a0000002a00133003001e00000001000011000214fe0116fe010b072d0500160a2b0b02031e281200000a0a2b00062a000042534a4201000100000000000c00000076322e302e35303732370000000005006c0000001c020000237e0000880200003c03000023537472696e677300000000c40500000800000023555300cc050000100000002347554944000000dc050000a803000023426c6f620000000000000002000001471502000900000000fa0133001600000100000014000000020000000200000002000000120000000e00000001000000010000000300000000000a00010000000000060084007d000600c900aa000600d700aa000600fd00eb0006001601eb0006003101eb0006005001eb0006006d01eb0006008401eb0006009f01eb000600b801eb000600d101eb000600ee01eb0006001a0207023b002e02000006005d023d0206007d023d020a00df02c4020e00210302030e00270302030000000001000000000001000100010110002b004600050001000100d0200000000081188b000a000100dc2000000000960091000e00010000000100f40200000200fa0211008b00140019008b00190021008b00140029008b00140031008b00140039008b00140041008b00140049008b00140051008b00140059008b00140061008b00140069008b00140071008b001e0081008b00240089008b000a0009008b000a0091008b000a009900340336022e003b00ac022e000b0043022e0013006d022e0023006d022e002b006d022e00330073022e0053004a032e004300e4022e004b0025032e006b0075032e007b0087032e005b0065032e0073007e0340008b00cb003e020480000006000000f50f00000100000029009b02000002000000000000000000000001007400000000000200000000000000000000000100b8020000000002000000000000000000000001007d00000000000000003c4d6f64756c653e004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e646c6c00526567756c617245787072657373696f6e4576616c7561746f72004d6963726f736f66742e456e74657270726973654d616e6167656d656e742e446174614163636573732e53716c006d73636f726c69620053797374656d004f626a656374002e63746f72004d617463686573526567756c617245787072657373696f6e0053797374656d2e52756e74696d652e496e7465726f705365727669636573004775696441747472696275746500436f6d56697369626c654174747269627574650053797374656d2e5265666c656374696f6e00417373656d626c7943756c7475726541747472696275746500417373656d626c7954726164656d61726b41747472696275746500417373656d626c79436f6e66696775726174696f6e41747472696275746500417373656d626c794465736372697074696f6e41747472696275746500417373656d626c795469746c6541747472696275746500417373656d626c79436f7079726967687441747472696275746500417373656d626c7950726f6475637441747472696275746500417373656d626c79436f6d70616e7941747472696275746500417373656d626c7946696c6556657273696f6e41747472696275746500417373656d626c7956657273696f6e4174747269627574650053797374656d2e446961676e6f73746963730044656275676761626c6541747472696275746500446562756767696e674d6f6465730053797374656d2e52756e74696d652e436f6d70696c6572536572766963657300436f6d70696c6174696f6e52656c61786174696f6e734174747269627574650052756e74696d65436f6d7061746962696c697479417474726962757465004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c0053797374656d2e44617461004d6963726f736f66742e53716c5365727665722e5365727665720053716c46756e6374696f6e41747472696275746500696e707574007061747465726e0053797374656d2e546578742e526567756c617245787072657373696f6e730052656765780052656765784f7074696f6e730049734d61746368000003200000000000a79e22af2016204a81c804d4f9bce8010008b77a5c561934e08903200001050002020e0e042001010e042001010205200101113d042001010880a000240000048000009400000006020000002400005253413100040000010001004ddb14fd25fa54ef1fe05516d69c0bb19c86956e2d5245e728300417e6a018daac56b61ee215e4c096dba942368bb4aa76956042bb3efb709cda847d7396839f57a40b90829fe5f347a5d2e2c198367cbc1092aa9762ae9776e59fed16703887329ffeb6d6cbf44853c496a22bc79bb3ce00f29760995dafa6aa97779983e0b48169010005005455794d6963726f736f66742e53716c5365727665722e5365727665722e446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038390a446174614163636573730000000054020f497344657465726d696e69737469630154020949735072656369736501540e044e616d651b666e5f4d617463686573526567756c617245787072657373696f6e54557f4d6963726f736f66742e53716c5365727665722e5365727665722e53797374656d446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038391053797374656d4461746141636365737300000000070003020e0e115104070202022901002433333532323533352d393332652d346130342d623965302d30616330383630353137663300000501000000003801003353716c436c722066756e6374696f6e616c697479207573656420627920746865206461746120616363657373206c617965722e0000370100324d6963726f736f66742e456e74657270726973654d616e6167656d656e742e53716c2e446174614163636573734c6179657200004001003b436f707972696768742032303035204d6963726f736f667420436f72706f726174696f6e2e2020416c6c207269676874732072657365727665642e00002401001f4d6963726f736f6674204f7065726174696f6e73204d616e6167657220763300001a0100154d6963726f736f667420436f72706f726174696f6e00000f01000a362e302e343038352e3000000801000701000000000801000800000000001e01000100540216577261704e6f6e457863657074696f6e5468726f777301000000000000cdef7c44000000000200000059000000a82a0000a80c000052534453165649e3ed4a514990cc3fb2ca36648a01000000643a5c6d6f6d76332e6d61696e5c7461726765745c64656275675c693338365c4d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e706462000000002c2b000000000000000000004e2b0000002000000000000000000000000000000000000000000000402b00000000000000000000000000000000000000005f436f72446c6c4d61696e006d73636f7265652e646c6c0000000000ff250020ec5600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000b80400000000000000000000b80434000000560053005f00560045005200530049004f004e005f0049004e0046004f0000000000bd04effe00000100000006000000f50f000006000000f50f3f000000000000000400000002000000000000000000000000000000440000000100560061007200460069006c00650049006e0066006f00000000002400040000005400720061006e0073006c006100740069006f006e00000000000000b00418040000010053007400720069006e006700460069006c00650049006e0066006f000000f4030000010030003000300030003000340062003000000080003400010043006f006d006d0065006e00740073000000530071006c0043006c0072002000660075006e006300740069006f006e0061006c0069007400790020007500730065006400200062007900200074006800650020006400610074006100200061006300630065007300730020006c0061007900650072002e0000004c001600010043006f006d00700061006e0079004e0061006d006500000000004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e000000900033000100460069006c0065004400650073006300720069007000740069006f006e00000000004d006900630072006f0073006f00660074002e0045006e00740065007200700072006900730065004d0061006e006100670065006d0065006e0074002e00530071006c002e0044006100740061004100630063006500730073004c0061007900650072000000000038000b000100460069006c006500560065007200730069006f006e000000000036002e0030002e0034003000380035002e0030000000000064002100010049006e007400650072006e0061006c004e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c00000000009c003c0001004c006500670061006c0043006f007000790072006900670068007400000043006f0070007900720069006700680074002000320030003000350020004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e002e002000200041006c006c0020007200690067006800740073002000720065007300650072007600650064002e0000006c00210001004f0072006900670069006e0061006c00460069006c0065006e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c0000000000600020000100500072006f0064007500630074004e0061006d006500000000004d006900630072006f0073006f006600740020004f007000650072006100740069006f006e00730020004d0061006e00610067006500720020007600330000003c000b000100500072006f006400750063007400560065007200730069006f006e00000036002e0030002e0034003000380035002e0030000000000040000b00010041007300730065006d0062006c0079002000560065007200730069006f006e00000036002e0030002e0034003000380035002e00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000c000000603b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set @ClrName1 = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.DataAccessLayer');
-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName1)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash1
END
--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash1, @ClrName1
END
GO
-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash BINARY(64), @ClrName NVARCHAR(4000);
set @Hash = HASHBYTES(N'SHA2_512', 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006182CF4B0000000000000000E00002210B010800001600000008000000000000BE3400000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000006834000053000000004000006004000000000000000000000000000000000000006000000C000000B83300001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000C4140000002000000016000000020000000000000000000000000000200000602E7273726300000060040000004000000006000000180000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001E00000000000000000000000000004000004200000000000000000000000000000000A0340000000000004800000002000500DC250000DC0D00000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000360002731000000A7D010000042A0000133002002D00000001000011000F01281100000A16FE010A062D03002B1A027B010000040F01281200000A6F1300000A1F2C6F1400000A262A5200027B01000004037B010000046F1500000A262A0000133004004C00000002000011007E1600000A0A027B010000042C13027B010000046F1700000A16FE0216FE012B01170C082D1A027B0100000416027B010000046F1700000A17596F1800000A0A06731900000A0B2B00072A133003002900000001000011000314FE0116FE010A062D0B7201000070731A00000A7A02036F1B00000A731C00000A7D010000042A000000133002002A00000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03027B010000046F1D00000A6F1E00000A002A1E02281F00000A2A5602281F00000A000002732100000A7D02000004002A133002002F000000010000110228080000060000032C0E036F2200000A16FE0216FE012B01170A062D0F00027B02000004036F2300000A0000002A001B3003007600000003000011007E1600000A0A00027B020000046F2400000A0D2B1C1203282500000A0B00067209000070076F1D00000A282600000A0A001203282700000A130411042DD7DE0F1203FE160300001B6F2800000A00DC0006282900000A16FE01130411042D09007E1600000A0C2B0B0006176F2A00000A0C2B00082A000001100000020014002D41000F0000000013300200140000000100001100027B020000046F2B00000A16FE010A2B00062A133001000B000000040000110073080000060A2B00062A00133004008100000005000011000F00281200000A0A0F00281100000A2D10066F2C00000A282900000A16FE012B0116130411042D08280C0000060D2B4E06178D2100000113051105161F2C9D1105176F2D00000A0B160C2B1600070807089A6F2C00000A6F2E00000AA2000817580C08078E69FE04130411042DDE07280100002B000773090000060D2B00092A00000013300100110000000600001100027B020000046F2B00000A0A2B00062A0000001B300300560000000700001100160A00027B020000046F2400000A0D2B1F1203282500000A0B0007031B283100000A0A0616FE01130411042D022B0E001203282700000A130411042DD4DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010003040000F000000001B300200520000000700001100170A00037B020000046F2400000A0D2B1B1203282500000A0B000207280F0000060A06130411042D022B0E001203282700000A130411042DD8DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010002C3C000F0000000013300200170000000800001100020328130000060A066F0B00000616FE010B2B00072A001B300200670000000900001100027B0200000473090000060A00037B020000046F2400000A0D2B261203282500000A0B0006076F0F000006130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCDDE0F1203FE160300001B6F2800000A00DC00060C2B00082A000110000002001A003751000F000000001B30020064000000090000110073080000060A00037B020000046F2400000A0D2B291203282500000A0B0002076F0F00000616FE01130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCADE0F1203FE160300001B6F2800000A00DC00060C2B00082A01100000020014003A4E000F0000000013300400410000000A000011000314FE0116FE010C082D0B7201000070731A00000A7A036F1B00000A0A06178D210000010D09161F2C9D09176F2D00000A0B027B02000004076F2300000A002A000000133002002500000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03026F1D00000A6F1E00000A002A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000014050000237E000080050000A805000023537472696E677300000000280B00001000000023555300380B0000100000002347554944000000480B00009402000023426C6F6200000000000000020000015717A2090908000000FA01330016000001000000250000000300000002000000150000000F0000000300000032000000110000000A0000000100000002000000020000000300000001000000020000000100000000000A0001000000000006009C0095000A00CA00AF000A00F000DB0006000601FA000A002C01DB0006005B01510106006D0151010600A10186010600B001860106006902570206008002570206009D0257020600BC0257020600D50257020600EE02570206000903570206002403570206005C033D0306007003570206009C0389035300B00300000600DF03BF030600FF03BF0306001D0495000A003304AF000A005404AF0006006C0495000600840495000A00A504AF000600CB0486012300E204000006001705950006004805950006004D05950006006E0595000A007905AF0006008C059500000000000100000000000100010001201000450051000500010001000120100088005100050002000800010014010A000100A8012F00502000000000860027010E00010060200000000086003601120001009920000000008600410118000200B02000000000860047011E000300082100000000E601680123000300402100000000E6017A0129000400762100000000861880010E0005007E2100000000861880010E0005009421000000008618800136000500D02100000000C600BE013F000600642200000000E609C701430006008422000000009608D201470006009C22000000009600DB014C0006002C23000000008600E101530007004C23000000008600E70157000700C023000000008600EB015C0008003024000000008600F4015C0009005424000000009600FD0162000A00D824000000009600030262000C00582500000000E601680123000E00A82500000000E6017A0129000F00000001001902000001001F02000001002502000001002702000001002902000001003102000001003302000001003B02000001004202000001004A02000002005002000001004A020000020050020000010025020000010027020200090003000D0003000900510080017400590080017400610080017400690080017400710080017400790080017400810080017400890080017400910080017900990080017400A10080017E00B10080018400B90080010E00C10080010E00C90080018900210080010E002900C701430029005B043F0021006504F10021006504F700210065040101D900730407012100790453002100BE010A01290080017400E1008001740031009A043F002100800174000900BE013F0039007A017400090080010E00E900800189000C0080010E001400C10453000C00D9044F010C00ED0459011C00FB046801D90007056D011C000E054300010123050E00D9002B057401D900390579010C00C1045300D90043053F00D90060058F01D90066053F00190174059901210180010E00D9009D05DA010C00A405F5012E001B002B022E006B0073022E000B0012022E0013002B022E00230031022E002B0012022E00330040022E003B002B022E004B002B022E005B0061022E0063006A0243007B008F00630003011701C0018301B101E0018301B10100028301B10120028301B101FD0010017E018A01A501D601E301EF01FB0109020300010000000D026B00000014026F0002000B00030002000C0005004301490162010480000001000000B30EF0680000000000005100000002000000000000000000000001008C00000000000200000000000000000000000100A300000000005F00A10100000000003C4D6F64756C653E004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E646C6C00436F6E636174656E617465004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E6564446174615479706500536574006D73636F726C69620053797374656D004F626A6563740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E446174612E53716C547970657300494E756C6C61626C650053797374656D2E5465787400537472696E674275696C64657200696E7465726D656469617465526573756C7400496E69740053716C537472696E6700416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465002E63746F720053797374656D2E436F6C6C656374696F6E732E47656E65726963004C6973746031006D656D626572730049436F6C6C656374696F6E603100546F537472696E67006765745F49734E756C6C006765745F4E756C6C00506172736500436F756E740048617300496E636C7564657300496E436F6D6D6F6E00556E696F6E00496E746572736563740049734E756C6C004E756C6C0076616C7565006F7468657200720077006F626A65637473007300656C656D656E740073756273657400616E6F74686572006669727374007365636F6E640053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174006765745F56616C756500417070656E6400537472696E6700456D707479006765745F4C656E67746800417267756D656E744E756C6C457863657074696F6E0052656164537472696E670053716C55736572446566696E656454797065417474726962757465006765745F436F756E740049456E756D657261626C6560310041646452616E676500456E756D657261746F7200476574456E756D657261746F72006765745F43757272656E7400436F6E636174004D6F76654E6578740049446973706F7361626C6500446973706F73650049734E756C6C4F72456D70747900537562737472696E67005472696D004368617200537472696E6753706C69744F7074696F6E730053706C697400546F4C6F77657200417272617900536F72740053716C4D6574686F6441747472696275746500537472696E67436F6D70617269736F6E00457175616C730041646400000372000003770000032C0000000000988CD7764C980A49A3DB04E0EFC50A160008B77A5C561934E0890306121103200001052001011115052001011208042000111505200101121905200101121D0606151221010E08200101151225010E0320000E03200002040000120C060001120C111503200008042001020E05200102120C080002120C120C120C03280002040800120C042001010E042001010205200101115504200101080520010111696101000200000004005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F000005200112110E0520011211030307010205200112111C02060E0520020E08080607030E1115022B010002000000020054080B4D61784279746553697A65401F000054020D4973427974654F7264657265640105151221010E05151225010E0920010115127901130008200015117D0113000515117D010E04200013000600030E0E0E0E040001020E0420010E080B07050E0E0E15117D010E02040701120C0920021D0E1D0311808907100101011D1E00030A010E0B07060E1D0E08120C021D03240100020054020F497344657465726D696E6973746963015402094973507265636973650103070108080003020E0E1180950B0705020E0215117D010E02050702120C020520010113000D0705120C0E120C15117D010E020807040E1D0E021D031801001355736572446566696E6564446174615479706500000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313000000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000006182CF4B000000000200000091000000D4330000D415000052534453E34F9E44F81FB94E95CF281C5235867A01000000443A5C50726F6A656374735C55736572446566696E656444617461547970655C55736572446566696E656444617461547970655C6F626A5C44656275675C4D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E70646200000000903400000000000000000000AE340000002000000000000000000000000000000000000000000000A034000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000080400000000000000000000080434000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE0000010000000100F068B30E00000100F068B30E3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00468030000010053007400720069006E006700460069006C00650049006E0066006F00000044030000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000500014000100460069006C0065004400650073006300720069007000740069006F006E0000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0033003700360033002E00320036003800360034000000000098003B00010049006E007400650072006E0061006C004E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C00000000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F00660074002000320030003100300000000000A0003B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C0000000000480014000100500072006F0064007500630074004E0061006D00650000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0033003700360033002E00320036003800360034000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0033003700360033002E0032003600380036003400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000C03400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set @ClrName = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.UserDefinedDataType');
-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash
END
--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash, @ClrName
END
GO
As seguintes versões do sistema operacional Windows Server são suportadas.
| Componente do System Center | Windows Server 2019 Standard, Datacenter | Windows Server 2019 Server Core | Windows Server 2022 Standard, Datacenter | Windows Server 2022 Server Core |
|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | • | • | • | • |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • | • | • |
| Banco de dados do Service Manager ou banco de dados do data warehouse | • | • | • | • |
| Portal de Autoatendimento do Service Manager (HTML 5) | • | • | • | • |
As seguintes versões do sistema operacional cliente Windows têm suporte para o console do Service Manager.
| Componentes no lado do cliente do System Center | Windows Server® 2019 Standard, Datacenter Enterprise | Windows Server® 2022 Standard, Datacenter | Windows 10 | Windows 11 |
|---|---|---|---|---|
| Console do Service Manager | • | • | • | • |
As versões a seguir do .NET têm suporte para Service Manager.
| Componente do 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 |
|---|---|---|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | • | • | • | • | • | • | |||
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • | • | • | • | • | |||
| Console do Service Manager | • | • | • | • | • | • | |||
| Portal de autoatendimento do Service Manager | • | • | • | • | • | • |
As seguintes versões do PowerShell têm suporte para Service Manager.
| Componente do System Center | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|
| Console do Service Manager | • | • |
| Servidor de Gerenciamento do Service Manager | • | • |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • |
Este artigo detalha os requisitos do sistema para o System Center 2019 – Service Manager (SM).
As seções a seguir descrevem as diretrizes gerais de desempenho e escalabilidade para o SM 2019 e recomendam as configurações de hardware para várias cargas de trabalho. Como o System Center 2019 foi criado para ser flexível e escalonável, os requisitos de hardware para cenários específicos podem ser diferentes das diretrizes apresentadas aqui.
Leia Configurações para cenários de implantação para saber mais sobre os limites de capacidade testados do Service Manager.
Para ajudar a simplificar as atualizações, você pode usar conectores do Service Manager 2019 com os seguintes componentes do System Center.
- Gerenciador de máquinas virtuais do System Center 2016/2019
- Orquestrador do System Center 2016/2019
- Gerente de Operações do System Center 2016/2019
- System Center 2016 Configuration Manager (somente durante o cenário de migração)
- Versões do System Center Configuration Manager CB
- 1511, 1602, 1606, 1710 e 1802 (com suporte do Service Manager 2019 RTM)
- 1806 a 2103, 2107 (com suporte do Service Manager 2019 UR2 e posterior)
| Servidores | Processador (min) | Processador (rec) | RAM (min) | RAM (rec) | Espaço em disco rígido (mín.) | Espaço em disco rígido (rec) |
|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | CPU 4-core de 2,66 GHz | CPU 4-core de 2,66 GHz | 8 GB | 8 GB | 10 GB | 10 GB |
| Banco de dados do Service Manager | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 32 GB | 80 GB | 80 GB |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | CPU 4-core de 2,66 GHz | CPU 4-core de 2,66 GHz | 8 GB | 16 GB | 10 GB | 10 GB |
| Bancos de dados de data warehouse do Service Manager | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 32 GB | 400 GB | 400 GB |
| Console do Service Manager | CPU 2-core de 2 GHz | CPU 2-core de 2 GHz | 4 GB | 4 GB | 10 GB | 10 GB |
| Portal de Autoatendimento do Service Manager (autônomo) | CPU 4-core de 2,66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 16 GB | 80 GB | 80 GB |
| Portal de Autoatendimento do Service Manager + Servidor de Gerenciamento Secundário (recomendado) | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 16 GB | 32 GB | 80 GB | 80 GB |
| Componente | Requisito |
|---|---|
| Servidor de gerenciamento do Service Manager | O servidor de gerenciamento precisa: Atualização do ADO.NET Data Services para .NET Framework 3.5 SP1 para Windows Server; Cliente nativo do SQL Server; Microsoft Report Viewer Redistributable, que está disponível com a mídia do Service Manager. O servidor de gerenciamento deve ser instalado em uma edição de 64 bits do Windows. |
| Servidor de gerenciamento de data warehouse | O servidor de gerenciamento de depósito requer: Cliente nativo do SQL Server O servidor de gerenciamento do data warehouse deve ser instalado em uma edição de 64 bits do Windows. |
| Bancos de dados do Service Manager/data warehouse | Os bancos de dados do Service Manager ou do data warehouse exigem: SQL Server Reporting Services (SSRS); Objetos de gerenciamento de análise do SQL Server. As configurações de agrupamento do SQL Server e do Analysis Services devem ser as mesmas para os computadores que hospedam o banco de dados do Service Manager, o banco de dados do data warehouse, o banco de dados do Analysis Services e o banco de dados do Reporting Services. |
| Console do Service Manager | O console requer: Microsoft Report Viewer Redistributable (disponível na mídia do System Center): Microsoft Excel para exibir cubos de dados OLAP no computador do console; Atualização do ADO.NET Data Services for.NET Framework 3.5 SP1 para Windows Server; Objetos de gerenciamento de análise do SQL Server. O console pode ser instalado nas edições de 32 bits e 64 bits do Windows. |
| Portal de autoatendimento | O servidor do Portal de Autoatendimento requer: Servidor Windows 2012 R2 ou posterior; a função do IIS e o ASP.NET 4.5 habilitados; Objetos de gerenciamento de análise do SQL Server. Ingresse o computador do servidor no mesmo domínio em que o Serviço SDK do Service Manager está em execução. Idealmente, no servidor primário ou secundário. |
| Máquinas que usam autoatendimento | O portal de Autoatendimento precisa de uma resolução de tela acima de 1024 X 768. Navegadores suportados: Microsoft Edge; Microsoft Internet Explorer 10 e 11; Mozilla Firefox 42 e posterior; Google Chrome 46 e posterior. |
| SQL Server Reporting Services | Em uma topologia de implantação em que o computador que hospeda o SSRS não está no mesmo computador que hospeda o servidor de gerenciamento do data warehouse, você precisa adicionar Microsoft.EnterpriseManagement.Reporting.Code ao cache de assembly global. Saiba mais sobre as etapas manuais. |
Operations Manager – Service Manager tem a capacidade de importar alertas e itens de configuração de um ambiente do Operations Manager. Leia sobre como instalar o Service Manager e o Operations Manager no mesmo ambiente. É possível criar um armazém de dados do Operations manager.
Configuration Manager – o Service Manager pode importar itens de configuração de um ambiente do Configuration Manager.
Requisitos de rede – para exibir conteúdo externo de artigos de conhecimento, os computadores que hospedam o console do Service Manager devem ter acesso à Internet, diretamente ou por meio de um servidor proxy.
Servidor SMTP - Você deve ter acesso a um servidor SMTP (Simple Mail Transfer Protocol) para usar o recurso Notificação e para a criação de incidentes por e-mail.
Modo de segurança do Windows – o Service Manager não funciona e os serviços usados pelo Service Manager não serão iniciados se o Windows Server estiver sendo executado no modo de segurança. Se você tentar iniciar os serviços do Service Manager manualmente enquanto estiver no modo de segurança, os serviços não serão iniciados e um erro será gravado no log de eventos.
O Microsoft SQL Server hospeda os bancos de dados criados pelo System Center – Service Manager. Além disso, o System Center 2019 – Service Manager requer o SQL Server Analysis Services (SSAS) para trabalhar com cubos OLAP (Processamento Analítico Online) da Microsoft. O SQL Server Reporting Services (SSRS) é necessário para dar suporte aos relatórios do System Center 2019 – Service Manager.
Use essas informações para avaliar se o ambiente do SQL Server está pronto para dar suporte à instalação ou atualização para o System Center 2019. Use essas informações se você estiver implantando um ou vários componentes do System Center.
Observação
Durante a instalação, selecione Pesquisa de texto completo do SQL Server nos computadores que executam o SQL Server que hospedarão o Service Manager e os bancos de dados do data warehouse.
Observação
- O SM não dá suporte ao modo SSAS Tabular. Selecione o modo SSAS como Multidimensional durante a instalação do SQL Server.
- Para as versões com suporte do SQL, use os service packs que estão atualmente com suporte da Microsoft.
- Service Manager 2019 dá suporte ao SQL 2019 com CU8 ou posterior; no entanto, ele não dá suporte ao SQL 2019 RTM.
- Com o SQL 2019 (CU8 ou posterior), use ODBC 17.3 a 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
| Service Manager | SQL Server 2016 e SPs | SQL Server 2017 | SQL Server 2019 com Atualização Cumulativa 8 |
|---|---|---|---|
| Banco de dados do Service Manager/Data Warehouse | • | • | • |
Observação
O System Center 2019 – Service Manager não dá suporte ao parâmetro MultiSubnetFailover . Esse parâmetro não é usado nas cadeias de conexão do System Center 2019 – Service Manager.
Para instalar ou atualizar o System Center 2019 – Service Manager, os computadores que executam o SQL Server que hospedam bancos de dados devem ser configurados para permitir atualizações. Se as atualizações não forem permitidas, a instalação do System Center 2019 – Service Manager não será concluída e a seguinte mensagem de erro será exibida no estágio Criar banco de dados da instalação:
Ocorreu um erro ao executar uma ação do cliente: _ExecuteSqlScripts. Essa tentativa de atualização falhou antes que as modificações permanentes tenham sido feitas. A atualização foi revertida com êxito para o estado original do sistema. Depois que as correções forem feitas, você poderá repetir a atualização para essa função.
Você pode verificar o status de allow updates no SQL Server executando o seguinte procedimento armazenado no SQL Server Management Studio:
sp_configure 'allow updates'
Na tabela de resultados, examine o valor de run_value. Se o valor do valor de execução for 1, defina-o novamente como 0 com o procedimento armazenado a seguir e execute a Instalação novamente.
sp_configure 'allow updates',0 reconfigure with override
A funcionalidade de Grupos de Disponibilidade AlwaysOn do SQL Server é compatível com o System Center 2019 – Service Manager.
Para obter mais informações sobre como instalar o Service Manager com grupos de disponibilidade AlwaysOn, consulte aqui.
As etapas a seguir fornecem informações sobre como atualizar para o SQL 2017.
Observação
O processo de atualização para o SQL 2017 desinstala os serviços de relatórios; Certifique-se de migrar os relatórios necessários, como backup de relatórios, banco de dados e chaves de criptografia.
Use as seguintes etapas para atualizar do SQL 2016 para o 2017:
- Atualize para o SQL 2017.
- Instale o SQL 2017 Reporting Services (SSRS), inicie o gerenciador de configuração do Reporting Services para usar o banco de dados de relatórios existente e restaure as chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
- Use os mesmos valores para o servidor de relatórios, o diretório virtual do serviço Web e a URL do portal da Web que você tinha antes de iniciar o processo de atualização do SQL 2017.
- Configure o SSRS de acordo com os detalhes compartilhados aqui.
- [Opcional] Para habilitar a segurança estrita do CLR, execute o script a seguir em cada um dos bancos de dados do Service Manager. Por padrão, a segurança estrita do CLR é desabilitada após a atualização para o SQL 2017.
As etapas a seguir fornecem informações sobre como atualizar para o SQL 2019.
Observação
- Você deve usar a Atualização Cumulativa 8 (CU8) ou posterior com o SQL 2019.
- Use ODBC 17.3 a 17.10.4.1 e MSOLEDBSQL 18.2 a 18.6.6.
- O processo de atualização para o SQL 2019 desinstala os serviços de relatórios; Certifique-se de migrar os relatórios necessários, como backup de relatórios, banco de dados e chaves de criptografia.
Use as seguintes etapas para atualizar do SQL 2017 para 2019:
- Atualize para o SQL 2019.
- Instale o SQL 2019 Reporting Services (SSRS) e inicie o gerenciador de configuração do Reporting Services para usar o banco de dados de relatórios existente, restaurar chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
- Use os mesmos valores para o servidor de relatórios, o diretório virtual do serviço Web e a URL do portal da Web que você tinha antes de iniciar o processo de atualização do SQL 2019.
- Configure o SSRS de acordo com os detalhes compartilhados aqui.
- [Opcional] Para habilitar a segurança estrita do CLR, execute o script a seguir em cada um dos bancos de dados do Service Manager. Por padrão, a segurança estrita do CLR é desabilitada após a atualização para o SQL 2019.
Opcional. Use o script a seguir para habilitar a segurança estrita do CLR.
-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash1 BINARY(64), @ClrName1 NVARCHAR(4000);
set @Hash1 = HASHBYTES(N'SHA2_512', 0x4d5a90000300000004000000ffff0000b800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000e1fba0e00b409cd21b8014ccd21546869732070726f6772616d2063616e6e6f742062652072756e20696e20444f53206d6f64652e0d0d0a2400000000000000504500004c010300cdef7c440000000000000000e0000e210b010800000c000000080000000000005e2b000000200000004000000000ec560020000000020000040000000000000004000000000000000080000000020000f2f10000030000040000100000100000000010000010000000000000100000000000000000000000042b000057000000004000001005000000000000000000000000000000000000006000000c0000008c2a00001c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002e74657874000000640b000000200000000c000000020000000000000000000000000000200000602e72737263000000100500000040000000060000000e0000000000000000000000000000400000402e72656c6f6300000c0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000402b0000000000004800000002000500082100008409000009000000000000000000000000000000502000008000000000000000000000000000000000000000000000000000000000000000000000000c506f2ef337d14f0bc66e27fa02006623253f6655697a25078f76132dfd4cf9ec02d54581a9310a12538c2a82f19f230bbe2ac6017a095a82147a15f65488b5b38c9612cfc2c228f748d5519b4981a836189698e99b7f54961091fbb404afb93ab9d8110f22652ab16e7ff50f9dfb4236d78f61e93555018ba85d95c28cb5452a02281000000a0000002a00133003001e00000001000011000214fe0116fe010b072d0500160a2b0b02031e281200000a0a2b00062a000042534a4201000100000000000c00000076322e302e35303732370000000005006c0000001c020000237e0000880200003c03000023537472696e677300000000c40500000800000023555300cc050000100000002347554944000000dc050000a803000023426c6f620000000000000002000001471502000900000000fa0133001600000100000014000000020000000200000002000000120000000e00000001000000010000000300000000000a00010000000000060084007d000600c900aa000600d700aa000600fd00eb0006001601eb0006003101eb0006005001eb0006006d01eb0006008401eb0006009f01eb000600b801eb000600d101eb000600ee01eb0006001a0207023b002e02000006005d023d0206007d023d020a00df02c4020e00210302030e00270302030000000001000000000001000100010110002b004600050001000100d0200000000081188b000a000100dc2000000000960091000e00010000000100f40200000200fa0211008b00140019008b00190021008b00140029008b00140031008b00140039008b00140041008b00140049008b00140051008b00140059008b00140061008b00140069008b00140071008b001e0081008b00240089008b000a0009008b000a0091008b000a009900340336022e003b00ac022e000b0043022e0013006d022e0023006d022e002b006d022e00330073022e0053004a032e004300e4022e004b0025032e006b0075032e007b0087032e005b0065032e0073007e0340008b00cb003e020480000006000000f50f00000100000029009b02000002000000000000000000000001007400000000000200000000000000000000000100b8020000000002000000000000000000000001007d00000000000000003c4d6f64756c653e004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e646c6c00526567756c617245787072657373696f6e4576616c7561746f72004d6963726f736f66742e456e74657270726973654d616e6167656d656e742e446174614163636573732e53716c006d73636f726c69620053797374656d004f626a656374002e63746f72004d617463686573526567756c617245787072657373696f6e0053797374656d2e52756e74696d652e496e7465726f705365727669636573004775696441747472696275746500436f6d56697369626c654174747269627574650053797374656d2e5265666c656374696f6e00417373656d626c7943756c7475726541747472696275746500417373656d626c7954726164656d61726b41747472696275746500417373656d626c79436f6e66696775726174696f6e41747472696275746500417373656d626c794465736372697074696f6e41747472696275746500417373656d626c795469746c6541747472696275746500417373656d626c79436f7079726967687441747472696275746500417373656d626c7950726f6475637441747472696275746500417373656d626c79436f6d70616e7941747472696275746500417373656d626c7946696c6556657273696f6e41747472696275746500417373656d626c7956657273696f6e4174747269627574650053797374656d2e446961676e6f73746963730044656275676761626c6541747472696275746500446562756767696e674d6f6465730053797374656d2e52756e74696d652e436f6d70696c6572536572766963657300436f6d70696c6174696f6e52656c61786174696f6e734174747269627574650052756e74696d65436f6d7061746962696c697479417474726962757465004d6963726f736f66742e4d6f6d2e446174614163636573732e53716c0053797374656d2e44617461004d6963726f736f66742e53716c5365727665722e5365727665720053716c46756e6374696f6e41747472696275746500696e707574007061747465726e0053797374656d2e546578742e526567756c617245787072657373696f6e730052656765780052656765784f7074696f6e730049734d61746368000003200000000000a79e22af2016204a81c804d4f9bce8010008b77a5c561934e08903200001050002020e0e042001010e042001010205200101113d042001010880a000240000048000009400000006020000002400005253413100040000010001004ddb14fd25fa54ef1fe05516d69c0bb19c86956e2d5245e728300417e6a018daac56b61ee215e4c096dba942368bb4aa76956042bb3efb709cda847d7396839f57a40b90829fe5f347a5d2e2c198367cbc1092aa9762ae9776e59fed16703887329ffeb6d6cbf44853c496a22bc79bb3ce00f29760995dafa6aa97779983e0b48169010005005455794d6963726f736f66742e53716c5365727665722e5365727665722e446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038390a446174614163636573730000000054020f497344657465726d696e69737469630154020949735072656369736501540e044e616d651b666e5f4d617463686573526567756c617245787072657373696f6e54557f4d6963726f736f66742e53716c5365727665722e5365727665722e53797374656d446174614163636573734b696e642c2053797374656d2e446174612c2056657273696f6e3d322e302e302e302c2043756c747572653d6e65757472616c2c205075626c69634b6579546f6b656e3d623737613563353631393334653038391053797374656d4461746141636365737300000000070003020e0e115104070202022901002433333532323533352d393332652d346130342d623965302d30616330383630353137663300000501000000003801003353716c436c722066756e6374696f6e616c697479207573656420627920746865206461746120616363657373206c617965722e0000370100324d6963726f736f66742e456e74657270726973654d616e6167656d656e742e53716c2e446174614163636573734c6179657200004001003b436f707972696768742032303035204d6963726f736f667420436f72706f726174696f6e2e2020416c6c207269676874732072657365727665642e00002401001f4d6963726f736f6674204f7065726174696f6e73204d616e6167657220763300001a0100154d6963726f736f667420436f72706f726174696f6e00000f01000a362e302e343038352e3000000801000701000000000801000800000000001e01000100540216577261704e6f6e457863657074696f6e5468726f777301000000000000cdef7c44000000000200000059000000a82a0000a80c000052534453165649e3ed4a514990cc3fb2ca36648a01000000643a5c6d6f6d76332e6d61696e5c7461726765745c64656275675c693338365c4d6963726f736f66742e4d6f6d2e446174614163636573732e53716c2e706462000000002c2b000000000000000000004e2b0000002000000000000000000000000000000000000000000000402b00000000000000000000000000000000000000005f436f72446c6c4d61696e006d73636f7265652e646c6c0000000000ff250020ec5600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000b80400000000000000000000b80434000000560053005f00560045005200530049004f004e005f0049004e0046004f0000000000bd04effe00000100000006000000f50f000006000000f50f3f000000000000000400000002000000000000000000000000000000440000000100560061007200460069006c00650049006e0066006f00000000002400040000005400720061006e0073006c006100740069006f006e00000000000000b00418040000010053007400720069006e006700460069006c00650049006e0066006f000000f4030000010030003000300030003000340062003000000080003400010043006f006d006d0065006e00740073000000530071006c0043006c0072002000660075006e006300740069006f006e0061006c0069007400790020007500730065006400200062007900200074006800650020006400610074006100200061006300630065007300730020006c0061007900650072002e0000004c001600010043006f006d00700061006e0079004e0061006d006500000000004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e000000900033000100460069006c0065004400650073006300720069007000740069006f006e00000000004d006900630072006f0073006f00660074002e0045006e00740065007200700072006900730065004d0061006e006100670065006d0065006e0074002e00530071006c002e0044006100740061004100630063006500730073004c0061007900650072000000000038000b000100460069006c006500560065007200730069006f006e000000000036002e0030002e0034003000380035002e0030000000000064002100010049006e007400650072006e0061006c004e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c00000000009c003c0001004c006500670061006c0043006f007000790072006900670068007400000043006f0070007900720069006700680074002000320030003000350020004d006900630072006f0073006f0066007400200043006f00720070006f0072006100740069006f006e002e002000200041006c006c0020007200690067006800740073002000720065007300650072007600650064002e0000006c00210001004f0072006900670069006e0061006c00460069006c0065006e0061006d00650000004d006900630072006f0073006f00660074002e004d006f006d002e0044006100740061004100630063006500730073002e00530071006c002e0064006c006c0000000000600020000100500072006f0064007500630074004e0061006d006500000000004d006900630072006f0073006f006600740020004f007000650072006100740069006f006e00730020004d0061006e00610067006500720020007600330000003c000b000100500072006f006400750063007400560065007200730069006f006e00000036002e0030002e0034003000380035002e0030000000000040000b00010041007300730065006d0062006c0079002000560065007200730069006f006e00000036002e0030002e0034003000380035002e00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000c000000603b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set @ClrName1 = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.DataAccessLayer');
-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName1)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash1
END
--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash1, @ClrName1
END
GO
-- Do this only for SQL server version 2017 and more
IF( convert(int, SERVERPROPERTY('ProductMajorVersion')) > 13 )
BEGIN
DECLARE @Hash BINARY(64), @ClrName NVARCHAR(4000);
set @Hash = HASHBYTES(N'SHA2_512', 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006182CF4B0000000000000000E00002210B010800001600000008000000000000BE3400000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000006834000053000000004000006004000000000000000000000000000000000000006000000C000000B83300001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000C4140000002000000016000000020000000000000000000000000000200000602E7273726300000060040000004000000006000000180000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001E00000000000000000000000000004000004200000000000000000000000000000000A0340000000000004800000002000500DC250000DC0D00000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000360002731000000A7D010000042A0000133002002D00000001000011000F01281100000A16FE010A062D03002B1A027B010000040F01281200000A6F1300000A1F2C6F1400000A262A5200027B01000004037B010000046F1500000A262A0000133004004C00000002000011007E1600000A0A027B010000042C13027B010000046F1700000A16FE0216FE012B01170C082D1A027B0100000416027B010000046F1700000A17596F1800000A0A06731900000A0B2B00072A133003002900000001000011000314FE0116FE010A062D0B7201000070731A00000A7A02036F1B00000A731C00000A7D010000042A000000133002002A00000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03027B010000046F1D00000A6F1E00000A002A1E02281F00000A2A5602281F00000A000002732100000A7D02000004002A133002002F000000010000110228080000060000032C0E036F2200000A16FE0216FE012B01170A062D0F00027B02000004036F2300000A0000002A001B3003007600000003000011007E1600000A0A00027B020000046F2400000A0D2B1C1203282500000A0B00067209000070076F1D00000A282600000A0A001203282700000A130411042DD7DE0F1203FE160300001B6F2800000A00DC0006282900000A16FE01130411042D09007E1600000A0C2B0B0006176F2A00000A0C2B00082A000001100000020014002D41000F0000000013300200140000000100001100027B020000046F2B00000A16FE010A2B00062A133001000B000000040000110073080000060A2B00062A00133004008100000005000011000F00281200000A0A0F00281100000A2D10066F2C00000A282900000A16FE012B0116130411042D08280C0000060D2B4E06178D2100000113051105161F2C9D1105176F2D00000A0B160C2B1600070807089A6F2C00000A6F2E00000AA2000817580C08078E69FE04130411042DDE07280100002B000773090000060D2B00092A00000013300100110000000600001100027B020000046F2B00000A0A2B00062A0000001B300300560000000700001100160A00027B020000046F2400000A0D2B1F1203282500000A0B0007031B283100000A0A0616FE01130411042D022B0E001203282700000A130411042DD4DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010003040000F000000001B300200520000000700001100170A00037B020000046F2400000A0D2B1B1203282500000A0B000207280F0000060A06130411042D022B0E001203282700000A130411042DD8DE0F1203FE160300001B6F2800000A00DC00060C2B00082A000001100000020010002C3C000F0000000013300200170000000800001100020328130000060A066F0B00000616FE010B2B00072A001B300200670000000900001100027B0200000473090000060A00037B020000046F2400000A0D2B261203282500000A0B0006076F0F000006130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCDDE0F1203FE160300001B6F2800000A00DC00060C2B00082A000110000002001A003751000F000000001B30020064000000090000110073080000060A00037B020000046F2400000A0D2B291203282500000A0B0002076F0F00000616FE01130411042D0F00067B02000004076F3200000A0000001203282700000A130411042DCADE0F1203FE160300001B6F2800000A00DC00060C2B00082A01100000020014003A4E000F0000000013300400410000000A000011000314FE0116FE010C082D0B7201000070731A00000A7A036F1B00000A0A06178D210000010D09161F2C9D09176F2D00000A0B027B02000004076F2300000A002A000000133002002500000001000011000314FE0116FE010A062D0B7205000070731A00000A7A03026F1D00000A6F1E00000A002A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000014050000237E000080050000A805000023537472696E677300000000280B00001000000023555300380B0000100000002347554944000000480B00009402000023426C6F6200000000000000020000015717A2090908000000FA01330016000001000000250000000300000002000000150000000F0000000300000032000000110000000A0000000100000002000000020000000300000001000000020000000100000000000A0001000000000006009C0095000A00CA00AF000A00F000DB0006000601FA000A002C01DB0006005B01510106006D0151010600A10186010600B001860106006902570206008002570206009D0257020600BC0257020600D50257020600EE02570206000903570206002403570206005C033D0306007003570206009C0389035300B00300000600DF03BF030600FF03BF0306001D0495000A003304AF000A005404AF0006006C0495000600840495000A00A504AF000600CB0486012300E204000006001705950006004805950006004D05950006006E0595000A007905AF0006008C059500000000000100000000000100010001201000450051000500010001000120100088005100050002000800010014010A000100A8012F00502000000000860027010E00010060200000000086003601120001009920000000008600410118000200B02000000000860047011E000300082100000000E601680123000300402100000000E6017A0129000400762100000000861880010E0005007E2100000000861880010E0005009421000000008618800136000500D02100000000C600BE013F000600642200000000E609C701430006008422000000009608D201470006009C22000000009600DB014C0006002C23000000008600E101530007004C23000000008600E70157000700C023000000008600EB015C0008003024000000008600F4015C0009005424000000009600FD0162000A00D824000000009600030262000C00582500000000E601680123000E00A82500000000E6017A0129000F00000001001902000001001F02000001002502000001002702000001002902000001003102000001003302000001003B02000001004202000001004A02000002005002000001004A020000020050020000010025020000010027020200090003000D0003000900510080017400590080017400610080017400690080017400710080017400790080017400810080017400890080017400910080017900990080017400A10080017E00B10080018400B90080010E00C10080010E00C90080018900210080010E002900C701430029005B043F0021006504F10021006504F700210065040101D900730407012100790453002100BE010A01290080017400E1008001740031009A043F002100800174000900BE013F0039007A017400090080010E00E900800189000C0080010E001400C10453000C00D9044F010C00ED0459011C00FB046801D90007056D011C000E054300010123050E00D9002B057401D900390579010C00C1045300D90043053F00D90060058F01D90066053F00190174059901210180010E00D9009D05DA010C00A405F5012E001B002B022E006B0073022E000B0012022E0013002B022E00230031022E002B0012022E00330040022E003B002B022E004B002B022E005B0061022E0063006A0243007B008F00630003011701C0018301B101E0018301B10100028301B10120028301B101FD0010017E018A01A501D601E301EF01FB0109020300010000000D026B00000014026F0002000B00030002000C0005004301490162010480000001000000B30EF0680000000000005100000002000000000000000000000001008C00000000000200000000000000000000000100A300000000005F00A10100000000003C4D6F64756C653E004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E646C6C00436F6E636174656E617465004D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E6564446174615479706500536574006D73636F726C69620053797374656D004F626A6563740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E446174612E53716C547970657300494E756C6C61626C650053797374656D2E5465787400537472696E674275696C64657200696E7465726D656469617465526573756C7400496E69740053716C537472696E6700416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465002E63746F720053797374656D2E436F6C6C656374696F6E732E47656E65726963004C6973746031006D656D626572730049436F6C6C656374696F6E603100546F537472696E67006765745F49734E756C6C006765745F4E756C6C00506172736500436F756E740048617300496E636C7564657300496E436F6D6D6F6E00556E696F6E00496E746572736563740049734E756C6C004E756C6C0076616C7565006F7468657200720077006F626A65637473007300656C656D656E740073756273657400616E6F74686572006669727374007365636F6E640053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174006765745F56616C756500417070656E6400537472696E6700456D707479006765745F4C656E67746800417267756D656E744E756C6C457863657074696F6E0052656164537472696E670053716C55736572446566696E656454797065417474726962757465006765745F436F756E740049456E756D657261626C6560310041646452616E676500456E756D657261746F7200476574456E756D657261746F72006765745F43757272656E7400436F6E636174004D6F76654E6578740049446973706F7361626C6500446973706F73650049734E756C6C4F72456D70747900537562737472696E67005472696D004368617200537472696E6753706C69744F7074696F6E730053706C697400546F4C6F77657200417272617900536F72740053716C4D6574686F6441747472696275746500537472696E67436F6D70617269736F6E00457175616C730041646400000372000003770000032C0000000000988CD7764C980A49A3DB04E0EFC50A160008B77A5C561934E0890306121103200001052001011115052001011208042000111505200101121905200101121D0606151221010E08200101151225010E0320000E03200002040000120C060001120C111503200008042001020E05200102120C080002120C120C120C03280002040800120C042001010E042001010205200101115504200101080520010111696101000200000004005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F000005200112110E0520011211030307010205200112111C02060E0520020E08080607030E1115022B010002000000020054080B4D61784279746553697A65401F000054020D4973427974654F7264657265640105151221010E05151225010E0920010115127901130008200015117D0113000515117D010E04200013000600030E0E0E0E040001020E0420010E080B07050E0E0E15117D010E02040701120C0920021D0E1D0311808907100101011D1E00030A010E0B07060E1D0E08120C021D03240100020054020F497344657465726D696E6973746963015402094973507265636973650103070108080003020E0E1180950B0705020E0215117D010E02050702120C020520010113000D0705120C0E120C15117D010E020807040E1D0E021D031801001355736572446566696E6564446174615479706500000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313000000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000000000006182CF4B000000000200000091000000D4330000D415000052534453E34F9E44F81FB94E95CF281C5235867A01000000443A5C50726F6A656374735C55736572446566696E656444617461547970655C55736572446566696E656444617461547970655C6F626A5C44656275675C4D6963726F736F66742E456E74657270726973654D616E6167656D656E742E53716C2E55736572446566696E656444617461547970652E70646200000000903400000000000000000000AE340000002000000000000000000000000000000000000000000000A034000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000080400000000000000000000080434000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE0000010000000100F068B30E00000100F068B30E3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00468030000010053007400720069006E006700460069006C00650049006E0066006F00000044030000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000500014000100460069006C0065004400650073006300720069007000740069006F006E0000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0033003700360033002E00320036003800360034000000000098003B00010049006E007400650072006E0061006C004E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C00000000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F00660074002000320030003100300000000000A0003B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004D006900630072006F0073006F00660074002E0045006E00740065007200700072006900730065004D0061006E006100670065006D0065006E0074002E00530071006C002E00550073006500720044006500660069006E0065006400440061007400610054007900700065002E0064006C006C0000000000480014000100500072006F0064007500630074004E0061006D00650000000000550073006500720044006500660069006E006500640044006100740061005400790070006500000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0033003700360033002E00320036003800360034000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0033003700360033002E0032003600380036003400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000C03400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000);
set @ClrName = CONVERT(NVARCHAR(4000), 'Microsoft.EnterpriseManagement.Sql.UserDefinedDataType');
-- Drop trusted assembly if exists
IF EXISTS (select * from sys.trusted_assemblies where description = @ClrName)
BEGIN
EXEC SYS.sp_drop_trusted_assembly @Hash
END
--Add to trusted assembly
EXEC SYS.SP_ADD_TRUSTED_ASSEMBLY @Hash, @ClrName
END
GO
As seguintes versões do sistema operacional Windows Server são suportadas.
| Componente do System Center | Windows Server 2016 Standard, Datacenter | Windows Server 2016 Server Core | Windows Server 2019 Standard, Datacenter | Windows Server 2019 Server Core |
|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | • | • | • | • |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • | • | • |
| Banco de dados do Service Manager ou banco de dados do data warehouse | • | • | • | • |
| Portal de Autoatendimento do Service Manager (HTML 5) | • | • | • | • |
As seguintes versões do sistema operacional cliente Windows têm suporte para o console do Service Manager.
| Componentes no lado do cliente do System Center | Windows Server® 2016 Standard, Datacenter Enterprise | Windows Server® 2019 Standard, Data Center | Windows 10 | Windows 11 |
|---|---|---|---|---|
| Console do Service Manager | • | • | • | • |
As versões a seguir do .NET têm suporte para Service Manager.
Observação
O System Center Service Manager 2019 UR4 e posterior dá suporte ao .NET 4.8
| Componente do 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 |
|---|---|---|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | • | • | • | • | • | • | |||
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • | • | • | • | • | |||
| Console do Service Manager | • | • | • | • | • | • | |||
| Portal de autoatendimento do Service Manager | • | • | • | • | • | • |
As seguintes versões do PowerShell têm suporte para Service Manager.
| Componente do System Center | Windows PowerShell 2.0 | Windows PowerShell 3.0 | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|---|---|
| Console do Service Manager | • | • | ||
| Servidor de Gerenciamento do Service Manager | • | • | ||
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • |
Este artigo detalha os requisitos do sistema para o System Center 2016 – Service Manager (SM).
As seções a seguir descrevem as diretrizes gerais de desempenho e escalabilidade para o SM 2016 e recomendam as configurações de hardware para várias cargas de trabalho. Como o System Center 2016 foi criado para ser flexível e escalonável, os requisitos de hardware para cenários específicos podem ser diferentes das diretrizes apresentadas aqui.
Saiba mais sobre os limites de capacidade testados para vários cenários de implantação do Service Manager.
Para ajudar a simplificar as atualizações, você pode usar os seguintes conectores do Service Manager 2016 com componentes do System Center 2012 R2.
- Gerenciador de máquina virtual do System Center 2012 R2
- System Center 2012 R2 Orchestrator
- System Center 2012 R2 Operations Manager
- System Center 2012 R2 Configuration Manager
- Versões CB do System Center Configuration Manager (SCCM) - 1511, 1602, 1606 e 1710.
- UR5 suporta 1802
- Suporta UR9 e UR10 de 1806 a 2103. No entanto, há uma limitação de que o tamanho dos dispositivos suportados pelo SCCM deve ser inferior a 2 PB.
- UR10 suporta 2107
| Servidor | Processador (min) | Processador (rec) | RAM (min) | RAM (rec) | Espaço em disco rígido (mín.) | Espaço em disco rígido (rec) |
|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | CPU 4-core de 2,66 GHz | CPU 4-core de 2,66 GHz | 8 GB | 8 GB | 10 GB | 10 GB |
| Banco de dados do Service Manager | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 32 GB | 80 GB | 80 GB |
| Servidor de Gerenciamento de Data Warehouse do Service Manager | CPU 4-core de 2,66 GHz | CPU 4-core de 2,66 GHz | 8 GB | 16 GB | 10 GB | 10 GB |
| Bancos de dados de data warehouse do Service Manager | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 32 GB | 400 GB | 400 GB |
| Console do Service Manager | CPU 2-core de 2 GHz | CPU 2-core de 2 GHz | 4 GB | 4 GB | 10 GB | 10 GB |
| Portal de Autoatendimento do Service Manager (autônomo) | CPU 4-core de 2,66 GHz | CPU 8-core de 2.66 GHz | 8 GB | 16 GB | 80 GB | 80 GB |
| Portal de Autoatendimento do Service Manager + Servidor de Gerenciamento Secundário (recomendado) | CPU 8-core de 2.66 GHz | CPU 8-core de 2.66 GHz | 16 GB | 32 GB | 80 GB | 80 GB |
As seguintes versões do sistema operacional Windows Server são suportadas.
| Componente do System Center | Windows Server 2012 Standard, Datacenter | Windows Server 2012 R2 Standard, Datacenter | Windows Server 2016 | Windows Server 2016 (Servidor com Experiência Desktop) | Windows Server 2016 Nano Server |
|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | • | • | • | ||
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • | • | ||
| Banco de dados do Service Manager ou banco de dados do data warehouse | • | • | • | ||
| Portal de Autoatendimento do Service Manager (HTML 5) | • | • | • |
As seguintes versões do sistema operacional cliente Windows têm suporte para o console do Service Manager.
| Componentes no lado do cliente do 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 do Service Manager | • | • | • | • | • | • |
As versões a seguir do .NET têm suporte para Service Manager.
| Componente do 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 |
|---|---|---|---|---|---|---|---|---|
| Servidor de Gerenciamento do Service Manager | • | • | • | • | • | |||
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • | • | • | • | |||
| Console do Service Manager | • | • | • | • | • | |||
| Portal de autoatendimento do Service Manager | • | • | • | • | • |
As seguintes versões do PowerShell têm suporte para Service Manager.
| Componente do System Center | Windows PowerShell 2.0 | Windows PowerShell 3.0 | Windows PowerShell 4.0 | Windows PowerShell 5.0 |
|---|---|---|---|---|
| Console do Service Manager | • | • | ||
| Servidor de Gerenciamento do Service Manager | • | • | ||
| Servidor de Gerenciamento de Data Warehouse do Service Manager | • | • |
| Componente | Requisito |
|---|---|
| Servidor de gerenciamento do Service Manager | O servidor de gerenciamento precisa: Atualização do ADO.NET Data Services para .NET Framework 3.5 SP1 para Windows Server; Cliente nativo do SQL Server; Microsoft Report Viewer Redistributable, que está disponível com a mídia do Service Manager. O servidor de gerenciamento deve ser instalado em uma edição de 64 bits do Windows. |
| Servidor de gerenciamento de data warehouse | O servidor de gerenciamento de depósito requer: Cliente nativo do SQL Server O servidor de gerenciamento do data warehouse deve ser instalado em uma edição de 64 bits do Windows. |
| Bancos de dados do Service Manager/data warehouse | Os bancos de dados do Service Manager ou do data warehouse exigem: SQL Server Reporting Services (SSRS); Objetos de gerenciamento de análise do SQL Server. As configurações de agrupamento do SQL Server e do Analysis Services devem ser as mesmas para os computadores que hospedam o banco de dados do Service Manager, o banco de dados do data warehouse, o banco de dados do Analysis Services e o banco de dados do Reporting Services. |
| Console do Service Manager | O console requer: Microsoft Report Viewer Redistributable (disponível na mídia do System Center): Microsoft Excel para exibir cubos de dados OLAP no computador do console; Atualização de Serviços de Dados do ADO.NET para .NET Framework 3.5 SP1 para Windows Server; Objetos de gerenciamento de análise do SQL Server O console pode ser instalado nas edições de 32 bits e 64 bits do Windows. |
| Portal de autoatendimento | O servidor do Portal de Autoatendimento requer: Servidor Windows 2012 R2 ou posterior; a função do IIS e o ASP.NET 4.5 habilitados; Objetos de gerenciamento de análise do SQL Server Ingresse o computador do servidor no mesmo domínio em que o Serviço SDK do Service Manager está em execução. Idealmente, no servidor primário ou secundário. |
| Máquinas que usam autoatendimento | O portal de Autoatendimento precisa de uma resolução de tela acima de 1024 X 768. Navegadores suportados: Microsoft Edge; Microsoft Internet Explorer 10 e 11; Mozilla Firefox 42 e posterior; Google Chrome 46 e posterior |
| SQL Server Reporting Services | Em uma topologia de implantação em que o computador que hospeda o SSRS não está no mesmo computador que hospeda o servidor de gerenciamento do data warehouse, você precisa adicionar Microsoft.EnterpriseManagement.Reporting.Code ao cache de assembly global. Saiba mais sobre as etapas manuais. |
| Operations Manager | Service Manager tem a capacidade de importar alertas e itens de configuração de um ambiente do Operations Manager. Leia sobre como instalar o Service Manager e o Operations Manager no mesmo ambiente. É possível criar um armazém de dados do Operations manager. |
| Configuration Manager | Service Manager pode importar itens de configuração de um ambiente do Configuration Manager. |
| Requisitos de rede | Para exibir conteúdo externo de artigos de conhecimento, os computadores que hospedam o console do Service Manager devem ter acesso à Internet, diretamente ou por meio de um servidor proxy. |
| Servidor SMTP | É necessário ter acesso a um servidor SMTP (protocolo de transferência simples de e-mail) para usar o recurso Notificação e para a criação de incidentes por e-mail. |
| Modo de segurança do Windows | Service Manager não funciona e os serviços usados pelo Service Manager não serão iniciados se o Windows Server estiver sendo executado no modo de segurança. Se você tentar iniciar os serviços do Service Manager manualmente enquanto estiver no modo de segurança, os serviços não serão iniciados e um erro será gravado no log de eventos. |
O Microsoft SQL Server hospeda os bancos de dados que o System Center 2016 – Service Manager cria. Além disso, o System Center 2016 – Service Manager requer o SSAS (SQL Server Analysis Services) para trabalhar com cubos OLAP (Processamento Analítico Online) da Microsoft. O SQL Server Reporting Services (SSRS) é necessário para dar suporte aos relatórios do System Center 2016 – Service Manager.
Use essas informações para avaliar se o ambiente do SQL Server está pronto para dar suporte à instalação ou atualização para o System Center 2016. Use essas informações se você estiver implantando um ou vários componentes do System Center.
A tabela a seguir resume o suporte para as versões Enterprise e Standard de 64 bits do SQL Server.
Observação
Para as versões com suporte do SQL, use os service packs que estão atualmente com suporte da Microsoft.
| Service Manager | SQL Server 2012 | SQL Server 2014 e SPs | SQL Server 2016 e SPs |
|---|---|---|---|
| Banco de dados do Service Manager/Data Warehouse | • | • |
- O System Center 2016 – Service Manager não dá suporte à configuração do parâmetro MultiSubnetFailover. Esse parâmetro não é usado em cadeias de conexão do Service Manager.
- Os Grupos de Disponibilidade AlwaysOn do SQL Server têm suporte no System Center 2016 – Service Manager. Saiba mais.
- Para instalar ou atualizar o Service Manager, os computadores do SQL Server que hospedam bancos de dados devem ser configurados para permitir atualizações. Caso contrário, um erro será exibido quando Service Manager tentar criar um banco de dados:
Ocorreu um erro ao executar uma ação do cliente: _ExecuteSqlScripts. Essa tentativa de atualização falhou antes que as modificações permanentes tenham sido feitas. A atualização foi revertida com êxito para o estado original do sistema. Depois que as correções forem feitas, você poderá tentar atualizar novamente para essa função.
Você pode verificar o status de allow updates no SQL Server executando o seguinte procedimento armazenado no SQL Server Management Studio:
sp_configure 'allow updates'Na tabela de resultados, examine o valor "run_value". Se o valor de "valor de execução" for 1, configure de volta para 0 com o seguinte procedimento armazenado e, em seguida, execute novamente a Instalação.
sp_configure 'allow updates',0 reconfigure with override
- Para saber mais sobre as edições de varejo e selecionadas do Service Manager e qual o efeito da seleção da instalação de avaliação de 180 dias nessas duas edições, examine as edições do Service Manager.
- Para saber mais sobre os limites testados do Service Manager, leia Configurações para cenários de implantação.
- Leia sobre o desempenho de hardware do Service Manager.