Partilhar via


Requisitos do sistema para o System Center Service Manager

Importante

O Service Provider Foundation (SPF) foi descontinuado do System Center 2025. No entanto, o SPF 2022 continuará a funcionar com 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 Analysis Management Object foi removido.

Requisitos do sistema para o System Center 2025 - Service Manager

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 escalável, os requisitos de hardware para cenários específicos podem diferir das diretrizes apresentadas aqui.

Limites de capacidade para o Service Manager

Leia Configurações para cenários de implantação para saber mais sobre os limites de capacidade testados do Service Manager.

Coexistência suportada

Para ajudar a simplificar as atualizações, você pode usar conectores do Service Manager 2025 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 (apenas durante o cenário de migração)
  • Lançamentos do System Center Configuration Manager versão CB
    • 1511, 1602, 1606, 1710, 1802, 1806 a 2103, 2107, 2111, 2203, 2207, 2211, 2303, 2309, 2403

Equipamento

Servidores Processador (min) Processador (rec) RAM (mínima) RAM (rec) Espaço no disco rígido (min) Espaço no disco rígido (rec)
Gestor de Serviços Servidor de Gestão CPU de 4 núcleos de 2,66 GHz CPU de 4 núcleos de 2,66 GHz 8 GB 8 GB 10 GB 10 GB
Service Manager Base de Dados CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 32 GB 80 GB 80 GB
Service Manager Servidor de Gestão de Data Warehouse CPU de 4 núcleos de 2,66 GHz CPU de 4 núcleos de 2,66 GHz 8 GB 16 GB 10 GB 10 GB
Service Manager bancos de dados do Data Warehouse CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 32 GB 400 GB 400 GB
Gestor de Serviços Consola CPU de 2 núcleos e 2 GHz CPU de 2 núcleos e 2 GHz 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (autónomo) CPU de 4 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Servidor de Gerenciamento Secundário (Recomendado) CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 16 GB 32 GB 80 GB 80 GB

Requisitos de software

Componente Exigência
servidor de gestão 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: SQL Server Native client

O servidor de gerenciamento de data warehouse deve ser instalado em uma edição de 64 bits do Windows.
bases de dados do Service Manager/armazém de dados 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.
Consola do Gestor de Serviços O console requer: Microsoft Excel para visualizar cubos de dados OLAP no computador de consola; a atualização dos Serviços de Dados ADO.NET para .NET Framework 3.5 SP1 no Windows Server.

O console pode ser instalado na edição de 64 bits do Windows.
Self-Service portal O servidor Self-Service Portal requer: servidor Windows 2016 ou posterior; a função IIS e o ASP.NET 4.5 habilitados.

Junte a máquina do servidor ao 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 de 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.

Notas adicionais

  • Operations Manager - Service Manager tem a capacidade de importar alertas e itens de configuração de um ambiente do Operations Manager. Leia sobre instalar o Service Manager e o Operations Manager no mesmo ambiente. Você pode criar um data mart para o Operations Manager.

  • Gestor de Configuração - O Gestor de Serviço pode importar itens de configuração de um ambiente do Gestor de Configuração.

  • Requisitos de rede - Para exibir conteúdo externo a partir de artigos de conhecimento, os computadores que hospedam o Service Manager Console 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 de notificação e para a criação de incidentes por e-mail.

  • de modo de segurança do Windows - o Service Manager não funciona e os serviços usados pelo Service Manager não sã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 falharão ao iniciar e um erro será gravado no log de eventos.

Requisitos do SQL Server

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 a relatórios do System Center 2025 - Service Manager.

Use essas informações para avaliar se seu ambiente do SQL Server está pronto para dar suporte à instalação ou atualização para o System Center 2025. Use essas informações se 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 e que hospedarão o Service Manager e os bancos de dados do data warehouse.

Suporte à versão do SQL Server

Observação

  • O SM não suporta o modo tabular do SSAS . Selecione o modo SSAS como Multidimensional durante a instalação do SQL Server.
  • Para as versões suportadas do SQL, use os service packs que estão atualmente em suporte pela Microsoft.
  • O Service Manager 2025 suporta SQL 2019 com CU8 ou posterior; no entanto, ele não suporta 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 a Atualização Cumulativa 8 do SQL Server 2022
Gestor de Serviços
de banco de dados do Data Warehouse

Observação

System Center 2025 - Service Manager não suporta o parâmetro MultiSubnetFailover. Este parâmetro não é usado nas cadeias de conexão do System Center 2025 - Service Manager.

Permitir atualizações

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. Esta tentativa de atualização falhou antes que modificações permanentes fossem 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 permitir atualizações no SQL Server executando o seguinte procedimento armazenado de dentro do SQL Server Management Studio:

sp_configure 'allow updates'

Na tabela de resultados, examine o valor para run_value. Se o valor de 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

Considerações sobre Grupos de Disponibilidade AlwaysOn para bancos de dados do Service Manager

A funcionalidade Grupos de Disponibilidade AlwaysOn do SQL Server é suportada pelo System Center 2025 - Service Manager.

Para obter mais informações sobre como instalar o Service Manager com grupos de disponibilidade AlwaysOn, consulte aqui.

Atualizar para o SQL 2019

As etapas a seguir fornecem informações sobre a atualização 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ório; certifique-se de migrar os relatórios necessários, como banco de dados de relatórios de backup e chaves de criptografia.

Use as seguintes etapas para atualizar do SQL Server 2017 para 2019:

  1. Atualize para o SQL 2019.
  2. 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 chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
  3. Use os mesmos valores para o diretório virtual do serviço Web do servidor de relatório e a URL do portal da Web que você tinha antes de iniciar o processo de atualização para o SQL 2019.
  4. Configure o SSRS conforme os detalhes aqui compartilhados .
  5. [opcional ] Para habilitar a segurança estrita do CLR, execute o seguinte de script 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.

Atualizar para o SQL 2022

As etapas a seguir fornecem informações sobre a atualização 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ório; certifique-se de migrar os relatórios necessários, como banco de dados de relatórios de backup e chaves de criptografia.

Use as seguintes etapas para atualizar da versão SQL 2019 para a versão 2022:

  1. Atualize para o SQL 2022.
  2. 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 chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
  3. Use os mesmos valores para o diretório virtual do serviço Web do servidor de relatório e a URL do portal da Web que você tinha antes de iniciar o processo de atualização para o SQL 2022.
  4. Configure o SSRS conforme os detalhes aqui compartilhados .
  5. [opcional ] Para habilitar a segurança estrita do CLR, execute o seguinte de script 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.

Habilite a segurança estrita do CLR

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

Sistema operacional do servidor

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 Núcleo de Servidor Windows Server 2025 Standard, Datacenter Núcleo do Windows Server 2025 Server
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse
Service Manager Base de Dados ou Armazém de Dados
Gestor de Serviços Self-Service Portal (HTML 5)

Sistema operacional cliente

As seguintes versões do sistema operacional cliente Windows são suportadas para o Service Manager Console.

Componentes do 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
Gestor de Serviços Consola

Versões .NET suportadas

As seguintes versões do .NET são suportadas para o 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
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse
Gerenciador de Serviços consola
Gestor de Serviços Self-Service Portal

Versões do PowerShell suportadas

As seguintes versões do PowerShell são suportadas para o Service Manager.

Componente do System Center Windows PowerShell 4.0 Windows PowerShell 5.0
Gestor de Serviços Consola
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse

Este artigo detalha os requisitos do sistema para o System Center 2022 - Service Manager (SM).

Observação

Ao contrário das versões anteriores, com o SM 2022, não é necessário instalar manualmente as ferramentas do Visualizador de Relatórios /Tipos de CLR da Microsoft para SQL Server 2014 como pré-requisito.

Requisitos do sistema para o System Center 2022 - Service Manager

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 escalável, os requisitos de hardware para cenários específicos podem diferir das diretrizes apresentadas aqui.

Limites de capacidade para o Service Manager

Leia Configurações para cenários de implantação para saber mais sobre os limites de capacidade testados do Service Manager.

Coexistência suportada

Para ajudar a simplificar as atualizações, você pode usar conectores do Service Manager 2022 com os seguintes componentes do System Center.

  • Gestor 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 (apenas durante o cenário de migração)
  • Lançamentos do System Center Configuration Manager versão CB
    • 1511, 1602, 1606, 1710, 1802, 1806 a 2103, 2107

Equipamento

Servidores Processador (min) Processador (rec) RAM (mínima) RAM (rec) Espaço no disco rígido (min) Espaço no disco rígido (rec)
Gestor de Serviços Servidor de Gestão CPU de 4 núcleos de 2,66 GHz CPU de 4 núcleos de 2,66 GHz 8 GB 8 GB 10 GB 10 GB
Service Manager Base de Dados CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 32 GB 80 GB 80 GB
Service Manager Servidor de Gestão de Data Warehouse CPU de 4 núcleos de 2,66 GHz CPU de 4 núcleos de 2,66 GHz 8 GB 16 GB 10 GB 10 GB
Service Manager bancos de dados do Data Warehouse CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 32 GB 400 GB 400 GB
Gestor de Serviços Consola CPU de 2 núcleos e 2 GHz CPU de 2 núcleos e 2 GHz 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (autónomo) CPU de 4 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Servidor de Gerenciamento Secundário (Recomendado) CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 16 GB 32 GB 80 GB 80 GB

Requisitos de software

Componente Exigência
servidor de gestão 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: SQL Server Native client

O servidor de gerenciamento de data warehouse deve ser instalado em uma edição de 64 bits do Windows.
bases de dados do Service Manager/armazém de dados 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.
Consola do Gestor de Serviços O console requer: Microsoft Excel para visualizar cubos de dados OLAP no computador do console; Atualização do ADO.NET Data Services para .NET Framework 3.5 SP1 para Windows Server; Objetos de Gestão de Análise do SQL Server.

O console pode ser instalado na edição de 64 bits do Windows.
Self-Service portal O servidor Self-Service Portal requer: servidor Windows 2016 ou posterior; a função IIS e o ASP.NET 4.5 habilitado; Objetos de gerenciamento de análise do SQL Server.

Junte a máquina do servidor ao 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 de 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.

Notas adicionais

  • Operations Manager - Service Manager tem a capacidade de importar alertas e itens de configuração de um ambiente do Operations Manager. Leia sobre instalar o Service Manager e o Operations Manager no mesmo ambiente. Você pode criar um data mart para o Operations Manager.

  • Gestor de Configuração - O Gestor de Serviço pode importar itens de configuração de um ambiente do Gestor de Configuração.

  • Requisitos de rede - Para exibir conteúdo externo a partir de artigos de conhecimento, os computadores que hospedam o Service Manager Console 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 de notificação e para a criação de incidentes por e-mail.

  • de modo de segurança do Windows - o Service Manager não funciona e os serviços usados pelo Service Manager não sã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 falharão ao iniciar e um erro será gravado no log de eventos.

Requisitos do SQL Server

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 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 a relatórios do System Center 2022 - Service Manager.

Use essas informações para avaliar se seu ambiente do SQL Server está pronto para dar suporte à instalação ou atualização para o System Center 2022. Use essas informações se 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 e que hospedarão o Service Manager e os bancos de dados do data warehouse.

Suporte à versão do SQL Server

Observação

  • O SM não suporta o modo tabular do SSAS . Selecione o modo SSAS como Multidimensional durante a instalação do SQL Server.
  • Para as versões suportadas do SQL, use os service packs que estão atualmente em suporte pela Microsoft.
  • O Service Manager 2022 suporta SQL 2019 com CU8 ou posterior; no entanto, ele não suporta 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.
Gestor de Serviços SQL Server 2017 SQL Server 2019 com a Atualização Cumulativa 8
Base de dados do Service Manager/Data Warehouse

Observação

O System Center 2022 - Service Manager não suporta o parâmetro MultiSubnetFailover. Este parâmetro não é usado nas cadeias de conexão do System Center 2022 - Service Manager.

Permitir atualizações

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. Esta tentativa de atualização falhou antes que modificações permanentes fossem 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 permitir atualizações no SQL Server executando o seguinte procedimento armazenado de dentro do SQL Server Management Studio:

sp_configure 'allow updates'

Na tabela de resultados, examine o valor para run_value. Se o valor de 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

Considerações sobre Grupos de Disponibilidade AlwaysOn para bancos de dados do Service Manager

A funcionalidade Grupos de Disponibilidade AlwaysOn do SQL Server é suportada pelo System Center 2022 - Service Manager.

Para obter mais informações sobre como instalar o Service Manager com grupos de disponibilidade AlwaysOn, consulte aqui.

Atualizar para o SQL 2017

As etapas a seguir fornecem informações sobre a atualização para o SQL 2017.

Observação

O processo de atualização para o SQL 2017 desinstala os serviços de relatório; certifique-se de migrar os relatórios necessários, como banco de dados de relatórios de backup e chaves de criptografia.

Use as seguintes etapas para atualizar do SQL 2016 para 2017:

  1. Atualize para o SQL 2017.
  2. 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.
  3. Use os mesmos valores para o diretório virtual do serviço Web do servidor de relatório e a URL do portal da Web que você tinha antes de iniciar o processo de atualização para o SQL 2017.
  4. Configure o SSRS conforme os detalhes aqui compartilhados .
  5. [opcional ] Para habilitar a segurança estrita do CLR, execute o seguinte de script 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.

Atualizar para o SQL 2019

As etapas a seguir fornecem informações sobre a atualização 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ório; certifique-se de migrar os relatórios necessários, como banco de dados de relatórios de backup e chaves de criptografia.

Use as seguintes etapas para atualizar do SQL Server 2017 para 2019:

  1. Atualize para o SQL 2019.
  2. 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 chaves de criptografia. Configure a URL do serviço Web e a URL do portal Web.
  3. Use os mesmos valores para o diretório virtual do serviço Web do servidor de relatório e a URL do portal da Web que você tinha antes de iniciar o processo de atualização para o SQL 2019.
  4. Configure o SSRS conforme os detalhes aqui compartilhados .
  5. [opcional ] Para habilitar a segurança estrita do CLR, execute o seguinte de script 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.

Habilite a segurança estrita do CLR

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

Sistema operacional do servidor

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
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse
Service Manager Base de Dados ou Armazém de Dados
Gestor de Serviços Self-Service Portal (HTML 5)

Sistema operacional cliente

As seguintes versões do sistema operacional cliente Windows são suportadas para o Service Manager Console.

Componentes do lado do cliente do System Center Windows Server® 2019 Standard, Datacenter Enterprise Windows Server® 2022 Standard, Datacenter Windows 10 Windows 11
Gestor de Serviços Consola

Versões .NET suportadas

As seguintes versões do .NET são suportadas para o 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
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse
Gerenciador de Serviços consola
Gestor de Serviços Self-Service Portal

Versões do PowerShell suportadas

As seguintes versões do PowerShell são suportadas para o Service Manager.

Componente do System Center Windows PowerShell 4.0 Windows PowerShell 5.0
Gestor de Serviços Consola
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse

Este artigo detalha os requisitos do sistema para o System Center 2019 - Service Manager (SM).

Requisitos do sistema para o System Center 2019 - Service Manager

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 escalável, os requisitos de hardware para cenários específicos podem diferir das diretrizes apresentadas aqui.

Limites de capacidade para o Service Manager

Leia Configurações para cenários de implantação para saber mais sobre os limites de capacidade testados do Service Manager.

Coexistência suportada

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)
  • Lançamentos do System Center Configuration Manager versão CB
    • 1511, 1602, 1606, 1710 e 1802 (compatível com o Service Manager 2019 RTM)
    • 1806 a 2103, 2107 (compatível com o Service Manager 2019 UR2 e posterior)

Equipamento

Servidores Processador (min) Processador (rec) RAM (mínima) RAM (rec) Espaço no disco rígido (min) Espaço no disco rígido (rec)
Gestor de Serviços Servidor de Gestão CPU de 4 núcleos de 2,66 GHz CPU de 4 núcleos de 2,66 GHz 8 GB 8 GB 10 GB 10 GB
Service Manager Base de Dados CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 32 GB 80 GB 80 GB
Service Manager Servidor de Gestão de Data Warehouse CPU de 4 núcleos de 2,66 GHz CPU de 4 núcleos de 2,66 GHz 8 GB 16 GB 10 GB 10 GB
Service Manager bancos de dados do Data Warehouse CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 32 GB 400 GB 400 GB
Gestor de Serviços Consola CPU de 2 núcleos e 2 GHz CPU de 2 núcleos e 2 GHz 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (autónomo) CPU de 4 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Servidor de Gerenciamento Secundário (Recomendado) CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 16 GB 32 GB 80 GB 80 GB

Requisitos de software

Componente Exigência
servidor de gestão do Service Manager O servidor de gestão precisa: Atualização do ADO.NET Data Services para o .NET Framework 3.5 SP1 para o 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: SQL Server Native client

O servidor de gerenciamento de data warehouse deve ser instalado em uma edição de 64 bits do Windows.
bases de dados do Service Manager/armazém de dados 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.
Consola do Gestor de Serviços 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.
Self-Service portal O servidor Self-Service Portal requer: servidor Windows 2012 R2 ou posterior; a função IIS e o ASP.NET 4.5 habilitado; Objetos de gerenciamento de análise do SQL Server.

Junte a máquina do servidor ao 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 de 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.

Notas adicionais

  • Operations Manager - Service Manager tem a capacidade de importar alertas e itens de configuração de um ambiente do Operations Manager. Leia sobre instalar o Service Manager e o Operations Manager no mesmo ambiente. Você pode criar um data mart para o Operations Manager.

  • Gestor de Configuração - O Gestor de Serviço pode importar itens de configuração de um ambiente do Gestor de Configuração.

  • Requisitos de rede - Para exibir conteúdo externo a partir de artigos de conhecimento, os computadores que hospedam o Service Manager Console 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 de notificação e para a criação de incidentes por e-mail.

  • de modo de segurança do Windows - o Service Manager não funciona e os serviços usados pelo Service Manager não sã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 falharão ao iniciar e um erro será gravado no log de eventos.

Requisitos do SQL Server

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 a relatórios do System Center 2019 - Service Manager.

Use essas informações para avaliar se seu ambiente do SQL Server está pronto para dar suporte à instalação ou atualização para o System Center 2019. Use essas informações se 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 e que hospedarão o Service Manager e os bancos de dados do data warehouse.

Suporte à versão do SQL Server

Observação

  • O SM não suporta o modo tabular do SSAS . Selecione o modo SSAS como Multidimensional durante a instalação do SQL Server.
  • Para as versões suportadas do SQL, use os service packs que estão atualmente em suporte pela Microsoft.
  • O Service Manager 2019 suporta SQL 2019 com CU8 ou posterior; no entanto, ele não suporta 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.
Gestor de Serviços SQL Server 2016 e SPs SQL Server 2017 SQL Server 2019 com a Atualização Cumulativa 8
Base de dados do Service Manager/Data Warehouse

Observação

O System Center 2019 - Service Manager não suporta o parâmetro MultiSubnetFailover. Este parâmetro não é usado nas cadeias de conexão do System Center 2019 - Service Manager.

Permitir atualizações

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. Esta tentativa de atualização falhou antes que modificações permanentes fossem 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 permitir atualizações no SQL Server executando o seguinte procedimento armazenado de dentro do SQL Server Management Studio:

sp_configure 'allow updates'

Na tabela de resultados, examine o valor para run_value. Se o valor de 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

Considerações sobre Grupos de Disponibilidade AlwaysOn para bancos de dados do Service Manager

A funcionalidade Grupos de Disponibilidade AlwaysOn do SQL Server é suportada pelo System Center 2019 - Service Manager.

Para obter mais informações sobre como instalar o Service Manager com grupos de disponibilidade AlwaysOn, consulte aqui.

Atualizar para o SQL 2017

As etapas a seguir fornecem informações sobre a atualização para o SQL 2017.

Observação

O processo de atualização para o SQL 2017 desinstala os serviços de relatório; certifique-se de migrar os relatórios necessários, como banco de dados de relatórios de backup e chaves de criptografia.

Use as seguintes etapas para atualizar do SQL 2016 para 2017:

  1. Atualize para o SQL 2017.
  2. 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.
  3. Use os mesmos valores para o diretório virtual do serviço Web do servidor de relatório e a URL do portal da Web que você tinha antes de iniciar o processo de atualização para o SQL 2017.
  4. Configure o SSRS conforme os detalhes aqui compartilhados .
  5. [opcional ] Para habilitar a segurança estrita do CLR, execute o seguinte de script 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.

Atualizar para o SQL 2019

As etapas a seguir fornecem informações sobre a atualização 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ório; certifique-se de migrar os relatórios necessários, como banco de dados de relatórios de backup e chaves de criptografia.

Use as seguintes etapas para atualizar do SQL Server 2017 para 2019:

  1. Atualize para o SQL 2019.
  2. 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.
  3. Use os mesmos valores para o diretório virtual do serviço Web do servidor de relatório e a URL do portal da Web que você tinha antes de iniciar o processo de atualização para o SQL 2019.
  4. Configure o SSRS conforme os detalhes aqui compartilhados .
  5. [opcional ] Para habilitar a segurança estrita do CLR, execute o seguinte de script 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.

Habilite a segurança estrita do CLR

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

Sistema operacional do servidor

As seguintes versões do sistema operacional Windows Server são suportadas.

Componente do System Center Windows Server 2016 Standard, Datacenter Núcleo do Windows Server 2016 Server Windows Server 2019 Standard, Datacenter Windows Server 2019 Server Core
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse
Service Manager Base de Dados ou Armazém de Dados
Gestor de Serviços Self-Service Portal (HTML 5)

Sistema operacional cliente

As seguintes versões do sistema operacional cliente Windows são suportadas para o Service Manager Console.

Componentes do lado do cliente do System Center Windows Server® 2016 Standard, Datacenter Enterprise Windows Server® 2019 Standard, Centro de Dados Windows 10 Windows 11
Gestor de Serviços Consola

Versões .NET suportadas

As seguintes versões do .NET são suportadas para o Service Manager.

Observação

System Center Service Manager 2019 UR4 e versões posteriores suporta .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
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse
Gerenciador de Serviços consola
Gestor de Serviços Self-Service Portal

Versões do PowerShell suportadas

As seguintes versões do PowerShell são suportadas para o Service Manager.

Componente do System Center Windows PowerShell 2.0 Windows PowerShell 3.0 Windows PowerShell 4.0 Windows PowerShell 5.0
Gestor de Serviços Consola
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse

Este artigo detalha os requisitos do sistema para o System Center 2016 - Service Manager (SM).

Requisitos do sistema para o System Center 2016 - Service Manager

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 escalável, os requisitos de hardware para cenários específicos podem diferir das diretrizes apresentadas aqui.

Limites de capacidade para o Service Manager

Saiba mais sobre os limites de capacidade testados para vários cenários de implementação do Service Manager.

Coexistência suportada

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áquinas virtuais do System Center 2012 R2
  • Orquestrador do System Center 2012 R2
  • Gerente de Operações do System Center 2012 R2
  • Gerenciador de configurações do System Center 2012 R2
  • Versões CB do System Center Configuration Manager (SCCM) - 1511, 1602, 1606 e 1710.
    • UR5 suporta 1802
    • UR9 e UR10 suportam 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

Equipamento

Servidor Processador (min) Processador (rec) RAM (mínima) RAM (rec) Espaço no disco rígido (min) Espaço no disco rígido (rec)
Gestor de Serviços Servidor de Gestão CPU de 4 núcleos de 2,66 GHz CPU de 4 núcleos de 2,66 GHz 8 GB 8 GB 10 GB 10 GB
Service Manager Base de Dados CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 32 GB 80 GB 80 GB
Service Manager Servidor de Gestão de Data Warehouse CPU de 4 núcleos de 2,66 GHz CPU de 4 núcleos de 2,66 GHz 8 GB 16 GB 10 GB 10 GB
Service Manager bancos de dados do Data Warehouse CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 32 GB 400 GB 400 GB
Gestor de Serviços Consola CPU de 2 núcleos e 2 GHz CPU de 2 núcleos e 2 GHz 4 GB 4 GB 10 GB 10 GB
Service Manager Self-Service Portal (autónomo) CPU de 4 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 8 GB 16 GB 80 GB 80 GB
Service Manager Self-Service Portal + Servidor de Gerenciamento Secundário (Recomendado) CPU de 8 núcleos de 2,66 GHz CPU de 8 núcleos de 2,66 GHz 16 GB 32 GB 80 GB 80 GB

Sistema operacional do servidor

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, Centro de Dados Windows Server 2016 Windows Server 2016 (Servidor com Experiência Desktop) Windows Server 2016 Nano Server
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse
Service Manager Base de Dados ou Armazém de Dados
Gestor de Serviços Self-Service Portal (HTML 5)  

Sistema operacional cliente

As seguintes versões do sistema operacional cliente Windows são suportadas para o Service Manager Console.

Componentes do 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, Centro de Dados Windows 10 Empresarial Windows Server® 2016 Standard, Datacenter
Gestor de Serviços Consola

Versões do .NET

As seguintes versões do .NET são suportadas para o 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
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse
Gerenciador de Serviços consola
Gestor de Serviços Self-Service Portal

Versões do PowerShell suportadas

As seguintes versões do PowerShell são suportadas para o Service Manager.

Componente do System Center Windows PowerShell 2.0 Windows PowerShell 3.0 Windows PowerShell 4.0 Windows PowerShell 5.0
Gestor de Serviços Consola
Gestor de Serviços Servidor de Gestão
Service Manager Servidor de Gestão de Data Warehouse

Requisitos de software

Componente Exigência
servidor de gestão do Service Manager O servidor de gestão precisa: Atualização do ADO.NET Data Services para o .NET Framework 3.5 SP1 para o 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: SQL Server Native client

O servidor de gerenciamento de data warehouse deve ser instalado em uma edição de 64 bits do Windows.
bases de dados do Service Manager/armazém de dados 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.
Consola do Gestor de Serviços O console requer: Microsoft Report Viewer Redistributable (disponível nos meios do System Center): 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; 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.
Self-Service portal O servidor Self-Service Portal requer: servidor Windows 2012 R2 ou posterior; a função IIS e o ASP.NET 4.5 habilitado; Objetos de gerenciamento de análise do SQL Server

Junte a máquina do servidor ao 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 utilizam 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.
Gestor de Operações O Service Manager tem a capacidade de importar alertas e itens de configuração de um ambiente do Operations Manager. Leia sobre instalar o Service Manager e o Operations Manager no mesmo ambiente.

Você pode criar um data mart para o Operations Manager.
Gestor de Configuração O Service Manager pode importar itens de configuração de um ambiente do Configuration Manager.
Requisitos de rede Para exibir conteúdo externo a partir de artigos de conhecimento, os computadores que hospedam o Service Manager Console 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 de 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 sã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 falharão ao iniciar e um erro será gravado no log de eventos.

O Microsoft SQL Server hospeda os bancos de dados criados pelo System Center 2016 - Service Manager. Além disso, o System Center 2016 - 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 a relatórios do System Center 2016 - Service Manager.

Use essas informações para avaliar se seu ambiente do SQL Server está pronto para dar suporte à instalação ou atualização para o System Center 2016. Use essas informações se estiver implantando um ou vários componentes do System Center.

Versões do SQL Server

A tabela a seguir resume o suporte para as versões Enterprise e Standard do SQL Server de 64 bits.

Observação

Para as versões suportadas do SQL, use os service packs que estão atualmente em suporte pela Microsoft.

Gestor de Serviços SQL Server 2012 SQL Server 2014 e SPs SQL Server 2016 e SPs
Base de dados do Service Manager/Data Warehouse
  • O System Center 2016 - Service Manager não suporta a definiçã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, as máquinas do SQL Server que hospedam bancos de dados devem ser configuradas para permitir atualizações. Caso contrário, um erro será exibido quando o Service Manager tentar criar um banco de dados:
    • Ocorreu um erro ao executar uma ação do cliente: _ExecuteSqlScripts. Esta tentativa de atualização falhou antes que modificações permanentes fossem 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 permitir atualizações no SQL Server executando o seguinte procedimento armazenado de dentro do SQL Server Management Studio:

      sp_configure 'allow updates'
      

      Na tabela de resultados, examine o valor para "run_value". Se o valor de "run value" for 1, resete-o para 0 com o seguinte procedimento armazenado e, em seguida, execute a configuração novamente.

      sp_configure 'allow updates',0 reconfigure with override
      

Próximos passos

  • Para saber mais sobre as edições de retalho e selecionadas do Service Manager e qual o impacto da seleção da instalação de avaliação de 180 dias tem nessas duas edições, consulte edições do Service Manager.
  • Para saber mais sobre os limites avaliados do Service Manager, consulte as Configurações para cenários de implantação.
  • Leia sobre o desempenho de hardware do Service Manager.