{"id":792,"date":"2022-10-14T20:23:51","date_gmt":"2022-10-14T23:23:51","guid":{"rendered":"https:\/\/ederlelis.com.br\/blog\/?p=792"},"modified":"2022-10-14T21:14:28","modified_gmt":"2022-10-15T00:14:28","slug":"falha-envio-database-mail-tls-1-2-netframework-smtp-microsoft-365","status":"publish","type":"post","link":"https:\/\/ederlelis.com.br\/blog\/falha-envio-database-mail-tls-1-2-netframework-smtp-microsoft-365\/","title":{"rendered":"Falha envio Database-mail TLS 1.2 \/ .NETFramework SMTP Microsoft 365."},"content":{"rendered":"<p>Ol\u00e1, espero que voc\u00ea esteja bem! \ud83d\ude09<\/p>\n<p>A configura\u00e7\u00e3o do Database mail nem sempre \u00e9 algo trivial, pois possui v\u00e1rios fatores agregados fazendo com que algo simples se torne trabalhoso.<\/p>\n<p><strong>Escrevi um post recentemente<\/strong> <strong>sobre<\/strong> o tema, e nele abordo a <strong><a href=\"https:\/\/ederlelis.com.br\/blog\/configurar-database-mail-no-sql-server-utilizando-uma-conta-do-gmail\/\" target=\"_blank\" rel=\"noopener\">configura\u00e7\u00e3o do Database Mail no Microsoft SQL Server Management Studio<\/a>,<\/strong> desde o b\u00e1sico com a cria\u00e7\u00e3o do Profile e depois a cria\u00e7\u00e3o de uma conta (que no caso foi usado do GMAIL), abordando tamb\u00e9m a autentica\u00e7\u00e3o de 2 fatores.<\/p>\n<p><\/p>\n<p>Portanto dando continua\u00e7\u00e3o no tema, neste post vou abordar sobre os <strong>erros<\/strong> que encontro no meu dia a dia como DBA, de empresas que usam o <strong>SMTP do office<\/strong>, e precisamos atuar para resolver a <strong>falha no envio do e-mail<\/strong>.<\/p>\n<p><\/p>\n<p>Ap\u00f3s a atualiza\u00e7\u00e3o da Microsoft (<strong>transi\u00e7\u00e3o para o TLS 1.2<\/strong>), o Database-mail passou a apresentar v\u00e1rias falhas no envio.<\/p>\n<p><strong>Mensagem contendo motivo da falha:<\/strong><\/p>\n<p><strong><em>The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2022-10-11T01:10:38). Exception Message: Cannot send mails to mail server. (Failure sending mail.).&nbsp; )<\/em><\/strong><\/p>\n<p><\/p>\n<p>Sendo necess\u00e1rio algumas valida\u00e7\u00f5es para detectar onde est\u00e1 desatualizado, e com base no resultado realizar algumas altera\u00e7\u00f5es, seguem:<\/p>\n<ul>\n<li>Foi feito alguma altera\u00e7\u00e3o recentemente no portal do office?<\/li>\n<li>A conta configurada no Database-mail do SSMS que est\u00e1 tendo problema no envio, funcionava normalmente e recentemente parou de enviar ou nunca enviou e-mail?<\/li>\n<li>Foi trocado alguma senha recentemente?<\/li>\n<li>Chegou a fazer algum teste se o envio est\u00e1 normal caso use esta mesma conta por outro aplicativo?<\/li>\n<\/ul>\n<p><strong>Antes de come\u00e7ar, vamos para um breve referencial te\u00f3rico.<\/strong><\/p>\n<p><\/p>\n<p>Por motivo de seguran\u00e7a, alguns servi\u00e7os de envio de e-mail passaram a adotar o <strong>MFA (autentica\u00e7\u00e3o multifator).<\/strong> Mas afinal o que \u00e9 isso?<\/p>\n<p style=\"margin: 0in; font-family: Calibri; font-size: 11.0pt;\"><em>&#8220;A MFA (autentica\u00e7\u00e3o multifator) adiciona uma camada de prote\u00e7\u00e3o ao processo de entrada. Os usu\u00e1rios fornecem uma verifica\u00e7\u00e3o de identidade adicional ao acessar contas ou aplicativos, como a leitura de uma impress\u00e3o digital ou a adi\u00e7\u00e3o de um c\u00f3digo recebido por telefone&#8221;.<\/em><\/p>\n<p>Segue abaixo um link da Microsoft sobre como realizar esta configura\u00e7\u00e3o:<\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/pt-br\/office\/configure-sua-entrada-no-microsoft-365-para-autentica%C3%A7%C3%A3o-multifatorial-ace1d096-61e5-449b-a875-58eb3d74de14\" target=\"_blank\" rel=\"noopener\">Configure sua entrada no Microsoft 365 para autentica\u00e7\u00e3o multifatorial<\/a><\/li>\n<\/ul>\n<p>Outro ponto a ser validado \u00e9 o <strong>SMTP AUTH<\/strong>.<\/p>\n<p>O diagrama a seguir mostra uma vis\u00e3o geral conceitual de como funciona a submiss\u00e3o de clientes SMTP AUTH.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"611\" height=\"420\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/smtp.png?resize=611%2C420&#038;ssl=1\" alt=\"\" class=\"wp-image-797\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/smtp.png?w=611&amp;ssl=1 611w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/smtp.png?resize=300%2C206&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/smtp.png?resize=520%2C357&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/smtp.png?resize=360%2C247&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/smtp.png?resize=250%2C172&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/smtp.png?resize=100%2C69&amp;ssl=1 100w\" sizes=\"(max-width: 611px) 100vw, 611px\" data-recalc-dims=\"1\" \/><figcaption>Como funciona a submiss\u00e3o de clientes SMTP AUTH.<\/figcaption><\/figure>\n\n\n<blockquote>\n<p><em>Features of SMTP AUTH client submission:<\/em><\/p>\n<ul>\n<li><em>SMTP AUTH client submission allows you to send email to people in your organization and outside your company.<\/em><\/li>\n<li><em>This method bypasses most spam checks for email sent to people in your organization. This bypass can help protect your company IP addresses from being blocked by a spam list.<\/em><\/li>\n<li><em>With this method, you can send email from any location or IP address, including your (on-premises) organization&#8217;s network, or a third-party cloud hosting service, like Microsoft Azure.<\/em><\/li>\n<\/ul>\n<\/blockquote>\n<p>Para enviar e-mail de uma conta do office 365, configurada no Database mail, \u00e9 preciso que o <strong>SMTP AUTH esteja habilitado no portal em Centro de administra\u00e7\u00e3o do Microsoft 365<\/strong>.<\/p>\n<p>Podendo ser feito via tela.<\/p>\n\n\n<div class=\"wp-block-image is-style-zoooom\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"640\" height=\"375\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig2_tela_smtp.png?resize=640%2C375&#038;ssl=1\" alt=\"\" class=\"wp-image-800\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig2_tela_smtp.png?w=641&amp;ssl=1 641w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig2_tela_smtp.png?resize=300%2C176&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig2_tela_smtp.png?resize=520%2C305&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig2_tela_smtp.png?resize=360%2C211&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig2_tela_smtp.png?resize=250%2C147&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig2_tela_smtp.png?resize=100%2C59&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><figcaption>Use o Centro de administra\u00e7\u00e3o do Microsoft 365 para habilitar ou desabilitar a AUTH SMTP em caixas de correio espec\u00edficas<\/figcaption><\/figure><\/div>\n\n\n<p>Ou via <a href=\"https:\/\/learn.microsoft.com\/pt-br\/powershell\/exchange\/connect-to-exchange-online-powershell\" target=\"_blank\" rel=\"noopener\">Exchange Online Powershell<\/a>.<\/p>\n<pre class=\"lang:tsql decode:true\">Set-CASMailbox -Identity &lt;MailboxIdentity&gt; -SmtpClientAuthenticationDisabled &lt;$true | $false | $null&gt;\n<\/pre>\n<p><strong>Sobre o Multi Fator de Autentica\u00e7\u00e3o (MFA), \u00e9 necess\u00e1rio que para a conta usada no envio do e-mail, n\u00e3o pode estar habilitado essa configura\u00e7\u00e3o. Habilita nas demais contas, mas nesta que usar\u00e1 no SSMS tem que estar desabilitada.<\/strong><\/p>\n<p>Segue refer\u00eancia no site da Microsoft.<\/p>\n<p lang=\"x-none\"><a href=\"https:\/\/learn.microsoft.com\/pt-br\/microsoft-365\/admin\/security-and-compliance\/set-up-multi-factor-authentication?view=o365-worldwide\" target=\"_blank\" rel=\"noopener\">Configurar a autentica\u00e7\u00e3o multifator para usu\u00e1rios &#8211; Microsoft 365 admin | Microsoft Learn<\/a><\/p>\n<p lang=\"x-none\">Uma informa\u00e7\u00e3o importante:<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"605\" height=\"152\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig3_mfa_novo.png?resize=605%2C152&#038;ssl=1\" alt=\"\" class=\"wp-image-801\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig3_mfa_novo.png?w=605&amp;ssl=1 605w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig3_mfa_novo.png?resize=300%2C75&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig3_mfa_novo.png?resize=520%2C131&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig3_mfa_novo.png?resize=360%2C90&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig3_mfa_novo.png?resize=250%2C63&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig3_mfa_novo.png?resize=100%2C25&amp;ssl=1 100w\" sizes=\"(max-width: 605px) 100vw, 605px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Ap\u00f3s o STMP AUTH estar habilitado e o MFA estar desabilitado (para a conta de e-mail em quest\u00e3o), iremos ent\u00e3o continuar.<\/p>\n<p><\/p>\n<p>Conforme dito no in\u00edcio deste post, vamos falar agora sobre a <strong>transi\u00e7\u00e3o para o TLS 1.2<\/strong>, e explicar sobre as informa\u00e7\u00f5es de configura\u00e7\u00e3o de registros suportadas para a implementa\u00e7\u00e3o do Windows do protocolo TLS (Transport Layer Security, seguran\u00e7a da camada de transporte) atrav\u00e9s do Schannel Security Support Provider (SSP). Este novo padr\u00e3o TLS 1.2 fornece melhorias de seguran\u00e7a em rela\u00e7\u00e3o \u00e0s vers\u00f5es anteriores.<\/p>\n<p><strong>Para habilitar o TLS 1.2 teremos alguns passos a seguir:<\/strong><\/p>\n<ul>\n<li><strong>Certificar que o TLS 1.2 esteja habilitado como um protocolo para o SCHANNEL no n\u00edvel de sistema operacional;<\/strong><\/li>\n<li><strong>Atualizar\/Configurar o .Net Framework para suportar o TLS 1.2;<\/strong><\/li>\n<\/ul>\n<p>Quais vers\u00f5es do Windows Server suportam o TLS 1.2?<\/p>\n<p>O Windows Server 2008 R2 e vers\u00f5es posteriores suportam o TLS 1.2.<\/p>\n<p>Segue tamb\u00e9m um link com refer\u00eancia de um KB relacionado ao assunto.<\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/pt-br\/topic\/kb3135244-suporte-para-tls-1-2-para-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/pt-br\/topic\/kb3135244-suporte-para-tls-1-2-para-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe<\/a><\/li>\n<\/ul>\n<p><strong>Teremos que fazer as seguintes altera\u00e7\u00f5es necess\u00e1ria no TLS (s\u00e3o necess\u00e1rias para computadores Cliente e Servidor):<\/strong><\/p>\n<ul>\n<li><strong>criar um valor de registro DWORD chamado &#8220;Enabled&#8221; com um valor 1 e &#8220;DisabledByDefault&#8221; com um valor 0.<\/strong><\/li>\n<\/ul>\n<p><em>Windows Registry Editor Version 5.00<\/em><\/p>\n<blockquote>\n<p><em>[HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\SecurityProviders\\SCHANNEL\\Protocols\\TLS\\1.2\\Client]<\/em><br><em>&#8220;DisabledByDefault&#8221;=dword:00000000<\/em><br><em>&#8220;Enabled&#8221;=dword:00000001<\/em><\/p>\n<p><em>[HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\SecurityProviders\\SCHANNEL\\Protocols\\TLS\\1.2\\Server]<\/em><br><em>&#8220;DisabledByDefault&#8221;=dword:00000000<\/em><br><em>&#8220;Enabled&#8221;=dword:00000001<\/em><\/p>\n<\/blockquote>\n<p>Seguindo as orienta\u00e7\u00f5es da Microsoft, <strong>para o .NET Framework<\/strong> 3.5 &#8211; 4.5.2 e n\u00e3o WCF recomenda-se atualizar para o .NET Framework 4.7 ou posterior. Caso n\u00e3o puder atualizar, <strong>atualize as chaves de registro do &#8220;SchUseStrongCrypto&#8221; e &#8220;SystemDefaultTlsVersions&#8221;.<\/strong><\/p>\n<p>O <em>SchUseStrongCrypto<\/em> ao ser configurado com um valor 1, far\u00e1 com que seu aplicativo use criptografia forte e bloquei protocolos que n\u00e3o s\u00e3o seguros.<\/p>\n<p><em>HKEY_LOCAL_MACHINE\\SOFTWARE\\[Wow6432Node\\]Microsoft\\.NETFramework\\&lt;VERSION&gt;: SchUseStrongCrypto<\/em><\/p>\n<p><strong>Portanto para vers\u00f5es .NET Framework 4.6 ou posterior, essa chave j\u00e1 vem com valor padr\u00e3o 1, e .NET Framework 4.5.2 ou anteriores, padr\u00e3o 0<\/strong>. Esta chave s\u00f3 deve ter um valor 0 caso voc\u00ea precisar se conectar a servi\u00e7os legados que n\u00e3o suportam criptografia forte e n\u00e3o podem ser atualizados.<\/p>\n<p><em>SystemDefaultTlsVer\u00e7\u00f5es<\/em>&nbsp;ao ser configurado com um valor 1, faz com que seu aplicativo permita que o sistema operacional escolha o protocolo. Se o valor estiver com 0, far\u00e1 com que seu aplicativo use protocolos escolhidos pelo .NET.<\/p>\n<p><em>HKEY_LOCAL_MACHINE\\SOFTWARE\\[Wow6432Node\\]Microsoft\\.NETFramework\\&lt;VERSION&gt;: SystemDefaultTlsVersions<\/em><\/p>\n<p>Neste caso, se o aplicativo estiver na vers\u00e3o .NET Framework 4.7 ou posterior, o valor padr\u00e3o ser\u00e1 1, e se a vers\u00e3o for .NET Framework 4.6.1 ou anteriores, a chave padr\u00e3o ser\u00e1 0.<\/p>\n<p>Portanto se resumir\u00e1 com as seguinte configura\u00e7\u00f5es, seguindo os valores mais seguros conformes citados acima:<\/p>\n<p><em>Windows Registry Editor Version 5.00<\/em><\/p>\n<blockquote>\n<p><em>[HKEY_LOCAL_MACHINE\\SOFTWARE\\WOW6432Node\\Microsoft\\.NETFramework\\v2.0.50727]<\/em><br><em>&#8220;SystemDefaultTlsVersions&#8221;=dword:00000001<\/em><br><em>&#8220;SchUseStrongCrypto&#8221;=dword:00000001<\/em><\/p>\n<p><em>[HKEY_LOCAL_MACHINE\\SOFTWARE\\WOW6432Node\\Microsoft\\.NETFramework\\v4.0.30319]<\/em><br><em>&#8220;SystemDefaultTlsVersions&#8221;=dword:00000001<\/em><br><em>&#8220;SchUseStrongCrypto&#8221;=dword:00000001<\/em><\/p>\n<p><em>[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\.NETFramework\\v2.0.50727]<\/em><br><em>&#8220;SystemDefaultTlsVersions&#8221;=dword:00000001<\/em><br><em>&#8220;SchUseStrongCrypto&#8221;=dword:00000001<\/em><\/p>\n<p><em>[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\.NETFramework\\v4.0.30319]<\/em><br><em>&#8220;SystemDefaultTlsVersions&#8221;=dword:00000001<\/em><br><em>&#8220;SchUseStrongCrypto&#8221;=dword:00000001<\/em><\/p>\n<\/blockquote>\n<p><strong>Vamos agora para a parte pr\u00e1tica! \ud83d\ude42<\/strong><\/p>\n<p>A configura\u00e7\u00e3o inicial no Database-mail vou pressupor que est\u00e1 tudo OK. Servi\u00e7o de e-mail habilitado e startado.<\/p>\n<p>Caso tenha dificuldade na configura\u00e7\u00e3o &#8220;inicial&#8221;, veja este meu outro post.<\/p>\n<ul>\n<li><a href=\"https:\/\/ederlelis.com.br\/blog\/configurar-database-mail-no-sql-server-utilizando-uma-conta-do-gmail\/\" target=\"_blank\" rel=\"noopener\"><strong>Configurar Database-mail no SQL Server utilizando uma conta do Gmail.<\/strong><\/a><\/li>\n<\/ul>\n<p>Portanto estando com a conta Office inserida e configurada (<strong>SMTP, PORTA, SSL<\/strong>) corretamente, vamos fazer um teste de envio.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"443\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig4_contaoffice.png?resize=640%2C443&#038;ssl=1\" alt=\"\" class=\"wp-image-804\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig4_contaoffice.png?w=710&amp;ssl=1 710w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig4_contaoffice.png?resize=300%2C207&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig4_contaoffice.png?resize=700%2C484&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig4_contaoffice.png?resize=520%2C360&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig4_contaoffice.png?resize=360%2C249&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig4_contaoffice.png?resize=250%2C173&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig4_contaoffice.png?resize=100%2C69&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>O teste pode ser feito via T-SQL ou via SSMS via interface.<\/p>\n<p>Basta ir em <strong><em>Mamagement \/ Database Mail \/ Send Test E-Mail..<\/em>.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"343\" height=\"427\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig5_teste.png?resize=343%2C427&#038;ssl=1\" alt=\"\" class=\"wp-image-805\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig5_teste.png?w=343&amp;ssl=1 343w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig5_teste.png?resize=241%2C300&amp;ssl=1 241w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig5_teste.png?resize=250%2C311&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig5_teste.png?resize=100%2C124&amp;ssl=1 100w\" sizes=\"(max-width: 343px) 100vw, 343px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Com o Profile setado basta colocar um e-mail que receber\u00e1 o teste e clicar em <strong><em>&#8220;Send Test E-Mail<\/em>&#8220;<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"460\" height=\"232\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig6_envio_teste.png?resize=460%2C232&#038;ssl=1\" alt=\"\" class=\"wp-image-806\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig6_envio_teste.png?w=460&amp;ssl=1 460w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig6_envio_teste.png?resize=300%2C151&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig6_envio_teste.png?resize=360%2C182&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig6_envio_teste.png?resize=250%2C126&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig6_envio_teste.png?resize=100%2C50&amp;ssl=1 100w\" sizes=\"(max-width: 460px) 100vw, 460px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Clicar em <em><strong>&#8220;OK&#8221;<\/strong><\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"389\" height=\"272\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig7_OK.png?resize=389%2C272&#038;ssl=1\" alt=\"\" class=\"wp-image-807\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig7_OK.png?w=389&amp;ssl=1 389w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig7_OK.png?resize=300%2C210&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig7_OK.png?resize=360%2C252&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig7_OK.png?resize=250%2C175&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig7_OK.png?resize=100%2C70&amp;ssl=1 100w\" sizes=\"(max-width: 389px) 100vw, 389px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Usaremos a query para validar o envio.<\/p>\n<pre class=\"lang:tsql decode:true \">select top 50 sent_status, CASE sent_status\n        WHEN 0 THEN 'Unsent'\n        WHEN 1 THEN 'Sent'\n        WHEN 2 THEN 'Failed'\n        WHEN 3 THEN 'Retrying'\nEND as sent_status_description, send_request_date, * from msdb.dbo.sysmail_mailitems order by 3 desc<\/pre>\n<p>Envio falhou.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"58\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?resize=640%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-808\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?w=931&amp;ssl=1 931w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?resize=300%2C27&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?resize=768%2C70&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?resize=700%2C64&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?resize=520%2C47&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?resize=360%2C33&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?resize=250%2C23&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig8_falhou.png?resize=100%2C9&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos verificar a mensagem de erro com o motivo da falha.<\/p>\n<pre class=\"lang:tsql decode:true \">-- Verifica Motivo Falha Envio Email\nSELECT\n    SEL.event_type,\n    SEL.log_date,\n    SEL.description,\n    SF.mailitem_id,\n    SF.recipients,\n    SF.copy_recipients,\n    SF.blind_copy_recipients,\n    SF.subject,\n    SF.body,\n    SF.sent_status,\n    SF.sent_date\nFROM\n    msdb.dbo.sysmail_faileditems AS SF JOIN\n    msdb.dbo.sysmail_event_log AS SEL\n        ON SF.mailitem_id = SEL.mailitem_id\norder by log_date DESC<\/pre>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"81\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?resize=640%2C81&#038;ssl=1\" alt=\"\" class=\"wp-image-809\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?w=952&amp;ssl=1 952w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?resize=300%2C38&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?resize=768%2C97&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?resize=700%2C88&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?resize=520%2C66&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?resize=360%2C45&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?resize=250%2C32&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig9_msg_falha.png?resize=100%2C13&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Description:<\/strong><\/p>\n<p><strong><em>The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2022-10-11T16:24:52). Exception Message: Cannot send mails to mail server. (Failure sending mail.). )<\/em><\/strong><\/p>\n<p><\/p>\n<p>Portanto agora vamos coletar algumas configura\u00e7\u00f5es para em seguida fazer as altera\u00e7\u00f5es recomendadas conforme orienta\u00e7\u00f5es da Microsoft a qual comentamos neste post.<\/p>\n<p><strong>SISTEMA OPERACIONAL.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"453\" height=\"341\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_so.png?resize=453%2C341&#038;ssl=1\" alt=\"\" class=\"wp-image-810\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_so.png?w=453&amp;ssl=1 453w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_so.png?resize=300%2C226&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_so.png?resize=360%2C271&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_so.png?resize=250%2C188&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_so.png?resize=100%2C75&amp;ssl=1 100w\" sizes=\"(max-width: 453px) 100vw, 453px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>VERS\u00c3O DO .NETFRAMEWORK.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"585\" height=\"343\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_net.png?resize=585%2C343&#038;ssl=1\" alt=\"\" class=\"wp-image-811\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_net.png?w=585&amp;ssl=1 585w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_net.png?resize=300%2C176&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_net.png?resize=520%2C305&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_net.png?resize=360%2C211&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_net.png?resize=250%2C147&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_net.png?resize=100%2C59&amp;ssl=1 100w\" sizes=\"(max-width: 585px) 100vw, 585px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>VERS\u00c3O DO SQL.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"476\" height=\"121\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_sql.png?resize=476%2C121&#038;ssl=1\" alt=\"\" class=\"wp-image-812\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_sql.png?w=476&amp;ssl=1 476w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_sql.png?resize=300%2C76&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_sql.png?resize=360%2C92&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_sql.png?resize=250%2C64&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig_sql.png?resize=100%2C25&amp;ssl=1 100w\" sizes=\"(max-width: 476px) 100vw, 476px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<blockquote>\n<p><strong>CUIDADO!!!<\/strong><\/p>\n<p><strong>A CONFIGURA\u00c7\u00c3O DAS CHAVES DE REGISTRO AFETA TODOS OS APLICATIVOS DO SISTEMA. USE ESTA OP\u00c7\u00c3O SOMENTE SE VOC\u00ca ESTIVER NO CONTROLE TOTAL DA M\u00c1QUINA E PUDER CONTROLAR AS ALTERA\u00c7\u00d5ES NO REGISTRO.<\/strong><\/p>\n<\/blockquote>\n<p>Portanto, antes de iniciar, \u00e9 de suma import\u00e2ncia fazer um backup dos registros atuais para caso tenhamos algum problema possamos ent\u00e3o voltar as informa\u00e7\u00f5es como estavam.<\/p>\n<p><strong>Vamos salvar 5 backups e darei os seguintes nomes:<\/strong><\/p>\n<p><strong>&#8211; BKP_REG1_TLS<\/strong><br><strong>&#8211; BKP_REG2_NETFramework_v4<\/strong><br><strong>&#8211; BKP_REG3_NETFramework_v2<\/strong><br><strong>&#8211; BKP_REG4_WOW_NETFramework_v2<\/strong><br><strong>&#8211; BKP_REG5_WOW_NETFramework_v4<\/strong><\/p>\n<p>Com o comando regedit, vamos acessar o Registre Editor para iniciar os backups.<\/p>\n<p><strong>Arquivo 1)<\/strong><\/p>\n<p>CAMINHO:<br><em>Computer\\HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\SecurityProviders\\SCHANNEL\\Protocols<\/em><\/p>\n<p>Bot\u00e3o direito em <strong>&#8220;<em>Protocols<\/em>&#8220;<\/strong> clique em <strong>&#8220;Export<\/strong>&#8220;.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"389\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig10_exp_reg1.png?resize=640%2C389&#038;ssl=1\" alt=\"\" class=\"wp-image-813\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig10_exp_reg1.png?w=746&amp;ssl=1 746w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig10_exp_reg1.png?resize=300%2C183&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig10_exp_reg1.png?resize=700%2C426&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig10_exp_reg1.png?resize=520%2C316&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig10_exp_reg1.png?resize=360%2C219&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig10_exp_reg1.png?resize=250%2C152&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig10_exp_reg1.png?resize=100%2C61&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Escolha um caminho para salvar o backup, d\u00ea um nome e clique em <em><strong>&#8220;Save&#8221;<\/strong><\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"549\" height=\"500\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig11_bkp_reg1.png?resize=549%2C500&#038;ssl=1\" alt=\"\" class=\"wp-image-814\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig11_bkp_reg1.png?w=549&amp;ssl=1 549w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig11_bkp_reg1.png?resize=300%2C273&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig11_bkp_reg1.png?resize=520%2C474&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig11_bkp_reg1.png?resize=360%2C328&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig11_bkp_reg1.png?resize=250%2C228&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig11_bkp_reg1.png?resize=100%2C91&amp;ssl=1 100w\" sizes=\"(max-width: 549px) 100vw, 549px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Faremos mesmos procedimentos para salvar (export) os outros registros.<\/p>\n<p><strong>Arquivo 2)<\/strong><\/p>\n<p>CAMINHO:<br><em>Computer\\HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\.NETFramework\\v4.0.30319<\/em><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"518\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig12_bkp_reg2.png?resize=640%2C518&#038;ssl=1\" alt=\"\" class=\"wp-image-815\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig12_bkp_reg2.png?w=743&amp;ssl=1 743w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig12_bkp_reg2.png?resize=300%2C243&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig12_bkp_reg2.png?resize=700%2C566&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig12_bkp_reg2.png?resize=520%2C421&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig12_bkp_reg2.png?resize=360%2C291&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig12_bkp_reg2.png?resize=250%2C202&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig12_bkp_reg2.png?resize=100%2C81&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Arquivo 3)<\/strong><\/p>\n<p>CAMINHO:<br><em>Computer\\HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\.NETFramework\\v2.0.50727<\/em><\/p>\n<p><strong>Arquivo 4)<\/strong><\/p>\n<p>CAMINHO:<br><em>Computer\\HKEY_LOCAL_MACHINE\\SOFTWARE\\WOW6432Node\\Microsoft\\.NETFramework\\v2.0.50727<\/em><\/p>\n<p><strong>Arquivo 5)<\/strong><\/p>\n<p>CAMINHO:<br><em>Computer\\HKEY_LOCAL_MACHINE\\SOFTWARE\\WOW6432Node\\Microsoft\\.NETFramework\\v4.0.30319<\/em><\/p>\n<p>Vamos agora conferir a pasta com os backups feitos.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"601\" height=\"227\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig13_bkps.png?resize=601%2C227&#038;ssl=1\" alt=\"\" class=\"wp-image-816\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig13_bkps.png?w=601&amp;ssl=1 601w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig13_bkps.png?resize=300%2C113&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig13_bkps.png?resize=520%2C196&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig13_bkps.png?resize=360%2C136&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig13_bkps.png?resize=250%2C94&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig13_bkps.png?resize=100%2C38&amp;ssl=1 100w\" sizes=\"(max-width: 601px) 100vw, 601px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Iniciaremos as altera\u00e7\u00f5es conforme citadas acima.<\/p>\n<p><strong>Resumi em 5 passos para facilitar o entendimento:<\/strong><\/p>\n<p><strong>PASSO 1)<\/strong><\/p>\n<blockquote>\n<p><em>[HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\SecurityProviders\\SCHANNEL\\Protocols\\TLS\\1.2\\Client]<\/em><br><em>&#8220;DisabledByDefault&#8221;=dword:00000000<\/em><br><em>&#8220;Enabled&#8221;=dword:00000001<\/em><\/p>\n<p><em>[HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\SecurityProviders\\SCHANNEL\\Protocols\\TLS\\1.2\\Server]<\/em><br><em>&#8220;DisabledByDefault&#8221;=dword:00000000<\/em><br><em>&#8220;Enabled&#8221;=dword:00000001<\/em><\/p>\n<\/blockquote>\n<p>Vamos para a pr\u00e1tica!?<\/p>\n<p>Veja que seguindo o caminho que fizemos o backup, o registro Protocols n\u00e3o cont\u00e9m as chaves referentes ao TLS 1.2. Por\u00e9m se no seu ambiente tiver as informa\u00e7\u00f5es do TLS 1.0, mesmo assim ser\u00e1 necess\u00e1rio fazer o mesmo procedimento a seguir, pois vamos adicionar o TLS 1.2 com as respectivas chaves.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"616\" height=\"228\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig14_prot.png?resize=616%2C228&#038;ssl=1\" alt=\"\" class=\"wp-image-817\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig14_prot.png?w=616&amp;ssl=1 616w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig14_prot.png?resize=300%2C111&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig14_prot.png?resize=520%2C192&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig14_prot.png?resize=360%2C133&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig14_prot.png?resize=250%2C93&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig14_prot.png?resize=100%2C37&amp;ssl=1 100w\" sizes=\"(max-width: 616px) 100vw, 616px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Usaremos a seguinte &#8220;hierarquia&#8221;:<\/strong><\/p>\n<p><strong>Protocols\\TLS\\1.2\\Client<\/strong><br><strong>Protocols\\TLS\\1.2\\Server<\/strong><\/p>\n<p>Bot\u00e3o direito em <em>Protocols \/ New \/ Key<\/em> e preencha com a palavra &#8220;<em><strong>TLS<\/strong><\/em>&#8220;<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"388\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_1.png?resize=640%2C388&#038;ssl=1\" alt=\"\" class=\"wp-image-818\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_1.png?w=743&amp;ssl=1 743w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_1.png?resize=300%2C182&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_1.png?resize=700%2C425&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_1.png?resize=520%2C316&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_1.png?resize=360%2C219&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_1.png?resize=250%2C152&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_1.png?resize=100%2C61&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Feito.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"235\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_2.png?resize=640%2C235&#038;ssl=1\" alt=\"\" class=\"wp-image-819\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_2.png?w=746&amp;ssl=1 746w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_2.png?resize=300%2C110&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_2.png?resize=700%2C257&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_2.png?resize=520%2C191&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_2.png?resize=360%2C132&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_2.png?resize=250%2C92&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig15_reg1_2.png?resize=100%2C37&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Continuaremos a inserir Key, conforme &#8220;hierarquia&#8221; citada, bastando clicar com bot\u00e3o direito.<\/p>\n<p>Conferindo como ficou.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"279\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig16_reg1_3.png?resize=640%2C279&#038;ssl=1\" alt=\"\" class=\"wp-image-820\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig16_reg1_3.png?w=749&amp;ssl=1 749w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig16_reg1_3.png?resize=300%2C131&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig16_reg1_3.png?resize=700%2C306&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig16_reg1_3.png?resize=520%2C227&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig16_reg1_3.png?resize=360%2C157&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig16_reg1_3.png?resize=250%2C109&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig16_reg1_3.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Agora iremos inserir os DWORD.<\/strong><\/p>\n<p><strong>&#8220;DisabledByDefault&#8221;=dword:00000000<\/strong><br><strong>&#8220;Enabled&#8221;=dword:00000001<\/strong><\/p>\n<p>Bot\u00e3o direito <em>Client, <\/em>depois <em>New \/ DWORD (32-bit) Valuel<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"420\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig17_reg1_4.png?resize=640%2C420&#038;ssl=1\" alt=\"\" class=\"wp-image-821\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig17_reg1_4.png?w=746&amp;ssl=1 746w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig17_reg1_4.png?resize=300%2C197&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig17_reg1_4.png?resize=700%2C460&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig17_reg1_4.png?resize=520%2C342&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig17_reg1_4.png?resize=360%2C236&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig17_reg1_4.png?resize=250%2C164&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig17_reg1_4.png?resize=100%2C66&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Inserir <strong>&#8220;DisabledByDefault&#8221;<\/strong> e <strong>&#8220;Enabled&#8221;.<\/strong><\/p>\n<p><strong>Ao inserir, o valor default \u00e9 zero, por\u00e9m temos que alterar o &#8220;<em>Enabled<\/em>&#8221; para 1.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"281\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig18_reg1_5.png?resize=640%2C281&#038;ssl=1\" alt=\"\" class=\"wp-image-822\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig18_reg1_5.png?w=747&amp;ssl=1 747w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig18_reg1_5.png?resize=300%2C132&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig18_reg1_5.png?resize=700%2C307&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig18_reg1_5.png?resize=520%2C228&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig18_reg1_5.png?resize=360%2C158&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig18_reg1_5.png?resize=250%2C110&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig18_reg1_5.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Para isso basta dar duplo clique, <strong>alterar o <em>&#8220;Value data&#8221;<\/em> para 1 e clicar em &#8220;<em>OK<\/em>&#8220;<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"309\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig19_reg1_6.png?resize=640%2C309&#038;ssl=1\" alt=\"\" class=\"wp-image-823\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig19_reg1_6.png?w=747&amp;ssl=1 747w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig19_reg1_6.png?resize=300%2C145&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig19_reg1_6.png?resize=700%2C338&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig19_reg1_6.png?resize=520%2C251&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig19_reg1_6.png?resize=360%2C174&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig19_reg1_6.png?resize=250%2C121&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig19_reg1_6.png?resize=100%2C48&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Repetiremos os mesmos procedimentos para a chave &#8220;<em>Server<\/em>&#8220;.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"281\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig21_reg1_8.png?resize=640%2C281&#038;ssl=1\" alt=\"\" class=\"wp-image-824\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig21_reg1_8.png?w=748&amp;ssl=1 748w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig21_reg1_8.png?resize=300%2C132&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig21_reg1_8.png?resize=700%2C308&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig21_reg1_8.png?resize=520%2C229&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig21_reg1_8.png?resize=360%2C158&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig21_reg1_8.png?resize=250%2C110&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig21_reg1_8.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>PASSO 2)<\/strong><\/p>\n<blockquote>\n<p><em>[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\.NETFramework\\v4.0.30319]<\/em><br><em>&#8220;SystemDefaultTlsVersions&#8221;=dword:00000001<\/em><br><em>&#8220;SchUseStrongCrypto&#8221;=dword:00000001<\/em><\/p>\n<\/blockquote>\n<p>Vamos continuar com a mesma l\u00f3gica, seguir o caminho acima e <strong>inserir os &#8220;DWORD (32-bit) Value&#8221; e depois dar duplo clique para passar o &#8220;Value&#8221; para 1.<\/strong><\/p>\n<p>Ap\u00f3s as altera\u00e7\u00f5es, ficar\u00e1 dessa maneira:<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"313\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig22_reg2_1.png?resize=640%2C313&#038;ssl=1\" alt=\"\" class=\"wp-image-825\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig22_reg2_1.png?w=753&amp;ssl=1 753w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig22_reg2_1.png?resize=300%2C147&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig22_reg2_1.png?resize=700%2C342&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig22_reg2_1.png?resize=520%2C254&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig22_reg2_1.png?resize=360%2C176&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig22_reg2_1.png?resize=250%2C122&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig22_reg2_1.png?resize=100%2C49&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>PASSO 3)<\/strong><\/p>\n<blockquote>\n<p><em>[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\.NETFramework\\v2.0.50727]<\/em><br><em>&#8220;SystemDefaultTlsVersions&#8221;=dword:00000001<\/em><br><em>&#8220;SchUseStrongCrypto&#8221;=dword:00000001<\/em><\/p>\n<\/blockquote>\n<p>Mesma coisa, da\u00ed como sei que voc\u00ea j\u00e1 est\u00e1 fera nos procedimentos, vou ent\u00e3o apenas postar o print de como ficar\u00e1.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"309\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig23_reg2_2.png?resize=640%2C309&#038;ssl=1\" alt=\"\" class=\"wp-image-826\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig23_reg2_2.png?w=748&amp;ssl=1 748w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig23_reg2_2.png?resize=300%2C145&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig23_reg2_2.png?resize=700%2C338&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig23_reg2_2.png?resize=520%2C251&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig23_reg2_2.png?resize=360%2C174&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig23_reg2_2.png?resize=250%2C121&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig23_reg2_2.png?resize=100%2C48&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>PASSO 4)<\/strong><\/p>\n<blockquote>\n<p><em>[HKEY_LOCAL_MACHINE\\SOFTWARE\\WOW6432Node\\Microsoft\\.NETFramework\\v2.0.50727]<\/em><\/p>\n<p><em>&#8220;SystemDefaultTlsVersions&#8221;=dword:00000001<\/em><\/p>\n<p><em>&#8220;SchUseStrongCrypto&#8221;=dword:00000001<\/em><\/p>\n<\/blockquote>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"341\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig24_reg2_3.png?resize=640%2C341&#038;ssl=1\" alt=\"\" class=\"wp-image-827\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig24_reg2_3.png?w=747&amp;ssl=1 747w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig24_reg2_3.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig24_reg2_3.png?resize=700%2C373&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig24_reg2_3.png?resize=520%2C277&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig24_reg2_3.png?resize=360%2C192&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig24_reg2_3.png?resize=250%2C133&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig24_reg2_3.png?resize=100%2C53&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>PASSO 5)<\/strong><\/p>\n<blockquote>\n<p><em>[HKEY_LOCAL_MACHINE\\SOFTWARE\\WOW6432Node\\Microsoft\\.NETFramework\\v4.0.30319]<\/em><\/p>\n<p><em>&#8220;SystemDefaultTlsVersions&#8221;=dword:00000001<\/em><\/p>\n<p><em>&#8220;SchUseStrongCrypto&#8221;=dword:00000001<\/em><\/p>\n<\/blockquote>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"341\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig25_reg2_4.png?resize=640%2C341&#038;ssl=1\" alt=\"\" class=\"wp-image-828\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig25_reg2_4.png?w=746&amp;ssl=1 746w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig25_reg2_4.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig25_reg2_4.png?resize=700%2C373&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig25_reg2_4.png?resize=520%2C277&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig25_reg2_4.png?resize=360%2C192&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig25_reg2_4.png?resize=250%2C133&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig25_reg2_4.png?resize=100%2C53&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Pronto, feito, basta fechar o Registry Editor.<\/p>\n<p><strong>Temos que dar um STOP no servi\u00e7o de envio de e-mail e em seguida START.<\/strong><\/p>\n<p>Usaremos os seguintes scripts:<\/p>\n<pre class=\"lang:tsql decode:true\">use msdb\n\nexec dbo.sysmail_stop_sp\n\nexec dbo.sysmail_start_sp<\/pre>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"495\" height=\"224\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig26_serv_email.png?resize=495%2C224&#038;ssl=1\" alt=\"\" class=\"wp-image-829\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig26_serv_email.png?w=495&amp;ssl=1 495w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig26_serv_email.png?resize=300%2C136&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig26_serv_email.png?resize=360%2C163&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig26_serv_email.png?resize=250%2C113&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig26_serv_email.png?resize=100%2C45&amp;ssl=1 100w\" sizes=\"(max-width: 495px) 100vw, 495px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>E agora, ser\u00e1 que deu certo?<\/p>\n<p><strong>Hora da verdade&#8230;<\/strong><\/p>\n<p>Faremos novo teste de envio.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"334\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig27_teste_final.png?resize=640%2C334&#038;ssl=1\" alt=\"\" class=\"wp-image-830\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig27_teste_final.png?w=727&amp;ssl=1 727w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig27_teste_final.png?resize=300%2C156&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig27_teste_final.png?resize=700%2C365&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig27_teste_final.png?resize=520%2C271&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig27_teste_final.png?resize=360%2C188&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig27_teste_final.png?resize=250%2C130&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig27_teste_final.png?resize=100%2C52&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Obaaaaaaa, deu certo!!!!!<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"42\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?resize=640%2C42&#038;ssl=1\" alt=\"\" class=\"wp-image-832\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?w=1002&amp;ssl=1 1002w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?resize=300%2C20&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?resize=768%2C51&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?resize=700%2C46&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?resize=520%2C34&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?resize=360%2C24&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?resize=250%2C16&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig28_teste_ok.png?resize=100%2C7&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Mas ainda n\u00e3o acabou o Post, que tal aquele B\u00f4nus que sempre deixo no final para quem resistiu at\u00e9 o fim!?! \ud83d\ude09<\/p>\n<p>Vou facilitar um pouco na resolu\u00e7\u00e3o deste problema!<\/p>\n<p>Digamos que ensinei voc\u00ea a pescar, pois \u00e9 essencial aprender do zero e conhecer o porqu\u00ea de cada configura\u00e7\u00e3o realizada. Agora vou entregar o &#8220;peixe j\u00e1 pescado&#8221;. rsrs.<\/p>\n<p><\/p>\n<p>Bora?<\/p>\n<p><\/p>\n<p><strong>Como terminamos tudo, vou fazer um backup de todas as Key criadas e salvar seguindo aquele racioc\u00ednio com aqueles 5 arquivos, levando em considera\u00e7\u00e3o o mesmo caminho para salvar os backups, apenas vou renomear com as iniciais diferentes para n\u00e3o confundir.<\/strong><\/p>\n<p><strong>&#8211; REG1_TLS<\/strong><br><strong>&#8211; REG2_NETFramework_v4<\/strong><br><strong>&#8211; REG3_NETFramework_v2<\/strong><br><strong>&#8211; REG4_WOW_NETFramework_v2<\/strong><br><strong>&#8211; REG5_WOW_NETFramework_v4<\/strong><\/p>\n<p>Irei mostrar apenas o primeiro backup (darei o nome de <strong>REG1_TLS<\/strong>) para relembrar, sendo os demais na mesma ideia.<\/p>\n<p>Portanto repetindo o procedimento, basta clicar com o bot\u00e3o direito em &#8220;<em><strong>Protocols<\/strong><\/em>&#8221; e depois em &#8220;<em><strong>Export<\/strong><\/em>&#8220;.<\/p>\n<p>Veja que as Key que criamos est\u00e3o inseridas dentro de Protocols, portanto este que faremos o backup.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"281\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig29_bkp.png?resize=640%2C281&#038;ssl=1\" alt=\"\" class=\"wp-image-833\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig29_bkp.png?w=704&amp;ssl=1 704w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig29_bkp.png?resize=300%2C132&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig29_bkp.png?resize=700%2C307&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig29_bkp.png?resize=520%2C228&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig29_bkp.png?resize=360%2C158&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig29_bkp.png?resize=250%2C110&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig29_bkp.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Pronto, todos os backups foram feitos e salvos em uma pasta onde irei compartilhar com uma outra VM criada para o&nbsp; Lab.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"611\" height=\"180\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig30_conferindo_bkp.png?resize=611%2C180&#038;ssl=1\" alt=\"\" class=\"wp-image-834\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig30_conferindo_bkp.png?w=611&amp;ssl=1 611w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig30_conferindo_bkp.png?resize=300%2C88&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig30_conferindo_bkp.png?resize=520%2C153&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig30_conferindo_bkp.png?resize=360%2C106&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig30_conferindo_bkp.png?resize=250%2C74&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig30_conferindo_bkp.png?resize=100%2C29&amp;ssl=1 100w\" sizes=\"(max-width: 611px) 100vw, 611px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Para comprovar os comandos realizados e salvos nos arquivos, basta abrir eles como &#8220;Bloco de notas&#8221; e ver\u00e1 exatamente o que foi feito.<\/p>\n<p>Veja no <em><strong>&#8220;REG1_TLS&#8221;<\/strong><\/em>, mostra a &#8220;hierarquia&#8221; que usamos e as Key inseridas.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"346\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?resize=640%2C346&#038;ssl=1\" alt=\"\" class=\"wp-image-835\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?w=898&amp;ssl=1 898w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?resize=300%2C162&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?resize=768%2C415&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?resize=700%2C378&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?resize=520%2C281&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?resize=360%2C194&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?resize=250%2C135&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig31_visualizacao.png?resize=100%2C54&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Acessando agora uma outra VM, que coincidentemente possui as mesmas configura\u00e7\u00f5es da primeira (vers\u00e3o do Windows, SQL Server, .NetFramework).<\/p>\n<blockquote>\n<p><strong>OBS: Por\u00e9m n\u00e3o necessariamente precisa ter as mesmas vers\u00f5es, pois conforme orienta\u00e7\u00f5es da Microsoft, para v\u00e1rias vers\u00f5es diferentes citadas no in\u00edcio deste post, o procedimento \u00e9 o mesmo.<\/strong><\/p>\n<\/blockquote>\n<p>Conferindo a conta de e-mail do office 365 desta nova VM.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"569\" height=\"410\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig32_email_inst2.png?resize=569%2C410&#038;ssl=1\" alt=\"\" class=\"wp-image-836\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig32_email_inst2.png?w=569&amp;ssl=1 569w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig32_email_inst2.png?resize=300%2C216&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig32_email_inst2.png?resize=520%2C375&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig32_email_inst2.png?resize=360%2C259&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig32_email_inst2.png?resize=250%2C180&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig32_email_inst2.png?resize=100%2C72&amp;ssl=1 100w\" sizes=\"(max-width: 569px) 100vw, 569px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Faremos um teste de envio dessa vez <strong>via script<\/strong>.<\/p>\n<pre class=\"lang:tsql decode:true\">-- TESTE ENVIO DE EMAIL\n\nEXEC msdb.dbo.sp_send_dbmail    \n\t\t@profile_name = 'MSSQLServer',\t\n\t\t@recipients = 'contato@ederlelis.com.br', \t\t\n\t\t@subject = 'ASSUNTO: Teste envio de e-mail' ,    \n\t\t@body = 'VM Lab2' ,\n@body_format = 'HTML'<\/pre>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"422\" height=\"283\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig33_teste_envio.png?resize=422%2C283&#038;ssl=1\" alt=\"\" class=\"wp-image-837\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig33_teste_envio.png?w=422&amp;ssl=1 422w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig33_teste_envio.png?resize=300%2C201&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig33_teste_envio.png?resize=360%2C241&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig33_teste_envio.png?resize=250%2C168&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig33_teste_envio.png?resize=100%2C67&amp;ssl=1 100w\" sizes=\"(max-width: 422px) 100vw, 422px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Ao validar, comprovamos falha no envio.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"78\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig34_falha.png?resize=640%2C78&#038;ssl=1\" alt=\"\" class=\"wp-image-838\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig34_falha.png?w=737&amp;ssl=1 737w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig34_falha.png?resize=300%2C37&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig34_falha.png?resize=700%2C85&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig34_falha.png?resize=520%2C64&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig34_falha.png?resize=360%2C44&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig34_falha.png?resize=250%2C31&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig34_falha.png?resize=100%2C12&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Mensagem de erro:<\/strong><\/p>\n<p><strong><em>The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2022-10-12T02:24:22). Exception Message: Cannot send mails to mail server. (Failure sending mail.). )<\/em><\/strong><\/p>\n<p>Conferindo o Registre Editor.<\/p>\n<p>Teremos que realizar todas as configura\u00e7\u00f5es necess\u00e1ria<strong> inserindo as Key e DWORD<\/strong>.<\/p>\n<p>Exemplo: Protocols n\u00e3o constas a Key &#8220;TLS\\1.2\\Client&#8221; e &#8220;&#8221;TLS\\1.2\\Server&#8221;.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"622\" height=\"224\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig35_conferindo.png?resize=622%2C224&#038;ssl=1\" alt=\"\" class=\"wp-image-839\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig35_conferindo.png?w=622&amp;ssl=1 622w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig35_conferindo.png?resize=300%2C108&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig35_conferindo.png?resize=520%2C187&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig35_conferindo.png?resize=360%2C130&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig35_conferindo.png?resize=250%2C90&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig35_conferindo.png?resize=100%2C36&amp;ssl=1 100w\" sizes=\"(max-width: 622px) 100vw, 622px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Agora vem a parte boa,<strong> lembra dos arquivos de registros que fizemos backups e compartilhamos?<\/strong><\/p>\n<p><a href=\"https:\/\/ederlelis.com.br\/blog\/Bkp_reg_post.rar\" target=\"_blank\" rel=\"noopener\"><em><strong> SEGUE LINK CASO QUEIRAM FAZER DOWNLOAD, BASTA CLICAR AQUI.<\/strong><\/em><\/a><\/p>\n<p>Vamos dar &#8220;<strong><em>enter<\/em><\/strong>&#8221; em cada um e clicar em &#8220;<strong>Run<\/strong>&#8220;.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"594\" height=\"444\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig36_enter_tls.png?resize=594%2C444&#038;ssl=1\" alt=\"\" class=\"wp-image-840\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig36_enter_tls.png?w=594&amp;ssl=1 594w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig36_enter_tls.png?resize=300%2C224&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig36_enter_tls.png?resize=520%2C389&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig36_enter_tls.png?resize=360%2C269&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig36_enter_tls.png?resize=250%2C187&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig36_enter_tls.png?resize=100%2C75&amp;ssl=1 100w\" sizes=\"(max-width: 594px) 100vw, 594px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>&#8220;YES&#8221;.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"552\" height=\"176\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig37_run.png?resize=552%2C176&#038;ssl=1\" alt=\"\" class=\"wp-image-841\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig37_run.png?w=552&amp;ssl=1 552w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig37_run.png?resize=300%2C96&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig37_run.png?resize=520%2C166&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig37_run.png?resize=360%2C115&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig37_run.png?resize=250%2C80&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig37_run.png?resize=100%2C32&amp;ssl=1 100w\" sizes=\"(max-width: 552px) 100vw, 552px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Sucesso!<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"551\" height=\"128\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig38_sucesso.png?resize=551%2C128&#038;ssl=1\" alt=\"\" class=\"wp-image-842\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig38_sucesso.png?w=551&amp;ssl=1 551w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig38_sucesso.png?resize=300%2C70&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig38_sucesso.png?resize=520%2C121&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig38_sucesso.png?resize=360%2C84&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig38_sucesso.png?resize=250%2C58&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig38_sucesso.png?resize=100%2C23&amp;ssl=1 100w\" sizes=\"(max-width: 551px) 100vw, 551px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Repetiremos o mesmo processo nos demais arquivos.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"595\" height=\"153\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig39_repetir.png?resize=595%2C153&#038;ssl=1\" alt=\"\" class=\"wp-image-843\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig39_repetir.png?w=595&amp;ssl=1 595w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig39_repetir.png?resize=300%2C77&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig39_repetir.png?resize=520%2C134&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig39_repetir.png?resize=360%2C93&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig39_repetir.png?resize=250%2C64&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig39_repetir.png?resize=100%2C26&amp;ssl=1 100w\" sizes=\"(max-width: 595px) 100vw, 595px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos agora conferir pelo menos um deles?<\/p>\n<p>Veja que foram inseridas as informa\u00e7\u00f5es corretas.<\/p>\n<p>Uau, ser\u00e1 que vai dar certo?! Foi tudo t\u00e3o r\u00e1pido nesta VM! \ud83d\ude09<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"257\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig40_conferindo.png?resize=640%2C257&#038;ssl=1\" alt=\"\" class=\"wp-image-844\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig40_conferindo.png?w=746&amp;ssl=1 746w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig40_conferindo.png?resize=300%2C121&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig40_conferindo.png?resize=700%2C282&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig40_conferindo.png?resize=520%2C209&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig40_conferindo.png?resize=360%2C145&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig40_conferindo.png?resize=250%2C101&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig40_conferindo.png?resize=100%2C40&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Agora o teste final, enviar novamente um e-mail.<\/p>\n<p><strong>Antes do envio do e-mail, vamos fazer um STOP e START no servi\u00e7o.<\/strong><\/p>\n<pre class=\"lang:tsql decode:true\">use msdb\n\nexec dbo.sysmail_stop_sp\n\nexec dbo.sysmail_start_sp<\/pre>\n<p>Em seguida executar o script com o teste de envio.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"606\" height=\"245\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig41_teste.png?resize=606%2C245&#038;ssl=1\" alt=\"\" class=\"wp-image-845\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig41_teste.png?w=606&amp;ssl=1 606w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig41_teste.png?resize=300%2C121&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig41_teste.png?resize=520%2C210&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig41_teste.png?resize=360%2C146&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig41_teste.png?resize=250%2C101&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig41_teste.png?resize=100%2C40&amp;ssl=1 100w\" sizes=\"(max-width: 606px) 100vw, 606px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Veja que maravilha, <strong>e-mail enviado com sucesso<\/strong>. Nessa VM tivemos apenas uma falha e conseguimos resolver o problema com pouco mais de 20min (inclu\u00eddo tempo para pegar os prints e escrever o trecho do post pra voc\u00ea).<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"65\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?resize=640%2C65&#038;ssl=1\" alt=\"\" class=\"wp-image-846\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?w=880&amp;ssl=1 880w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?resize=300%2C31&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?resize=768%2C79&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?resize=700%2C72&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?resize=520%2C53&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?resize=360%2C37&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?resize=250%2C26&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/fig42_teste_final.png?resize=100%2C10&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n\n<p>Depois de bastante testes em labs e resolu\u00e7\u00e3o em case, resolvi detalhar o m\u00e1ximo poss\u00edvel para compartilhar com voc\u00ea. Me preocupando de n\u00e3o ficar muito grande o Post, por\u00e9m tive que fazer uma breve introdu\u00e7\u00e3o com os referenciais te\u00f3ricos.<\/p>\n<p>Obrigado novamente e espero que tenha contribu\u00eddo alguma coisa para o seu aprendizado. \ud83d\ude09<\/p>\n<p>Quaisquer d\u00favidas, sugest\u00f5es, podem mandar mensagens, escrever nos coment\u00e1rios\u2026<\/p>\n<p><\/p>\n<p>Seguem alguns links com refer\u00eancias usadas para escrever este post.<\/p>\n<ul>\n<li><a href=\"https:\/\/www.microsoft.com\/pt-br\/security\/business\/identity-access\/azure-active-directory-mfa-multi-factor-authentication\" target=\"_blank\" rel=\"noopener\">https:\/\/www.microsoft.com\/pt-br\/security\/business\/identity-access\/azure-active-directory-mfa-multi-factor-authentication<\/a>\u00a0<\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/exchange\/mail-flow-best-practices\/how-to-set-up-a-multifunction-device-or-application-to-send-email-using-microsoft-365-or-office-365?source=recommendations\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/exchange\/mail-flow-best-practices\/how-to-set-up-a-multifunction-device-or-application-to-send-email-using-microsoft-365-or-office-365?source=recommendations<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/windows-server\/security\/tls\/tls-registry-settings#tls-12\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/windows-server\/security\/tls\/tls-registry-settings#tls-12<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/pt-br\/topic\/kb3135244-suporte-para-tls-1-2-para-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/pt-br\/topic\/kb3135244-suporte-para-tls-1-2-para-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/dotnet\/framework\/network-programming\/tls#configuring-schannel-protocols-in-the-windows-registry\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/dotnet\/framework\/network-programming\/tls#configuring-schannel-protocols-in-the-windows-registry<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/mem\/configmgr\/core\/plan-design\/security\/enable-tls-1-2-server\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/mem\/configmgr\/core\/plan-design\/security\/enable-tls-1-2-server<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/dotnet\/framework\/network-programming\/tls#the-sch_use_strong_crypto-flag\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/dotnet\/framework\/network-programming\/tls#the-sch_use_strong_crypto-flag<\/a><\/li>\n<\/ul>\n<ul><\/ul>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dando continua\u00e7\u00e3o no tema, neste post vou abordar sobre os erros que encontro no meu dia a dia como DBA, de empresas que usam o SMTP do office, e precisamos atuar para resolver a falha no envio do e-mail.<\/p>\n<p>Ap\u00f3s a atualiza\u00e7\u00e3o da Microsoft (transi\u00e7\u00e3o para o TLS 1.2), o Database-mail passou a apresentar v\u00e1rias falhas no envio.<\/p>\n<p>Sendo necess\u00e1rio algumas valida\u00e7\u00f5es para detectar onde est\u00e1 desatualizado, e com base no resultado realizar algumas altera\u00e7\u00f5es.<\/p>\n<p>Portanto para habilitar o TLS 1.2 teremos alguns passos a seguir:<\/p>\n<p>&#8211; Certificar que o TLS 1.2 esteja habilitado como um protocolo para o SCHANNEL no n\u00edvel de sistema operacional;<br \/>\n&#8211; Atualizar\/Configurar o .Net Framework para suportar o TLS 1.2;<\/p>\n","protected":false},"author":1,"featured_media":855,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"spay_email":""},"categories":[35,44,25],"tags":[43,36,41,40,42],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/database_mail_parte2.png?fit=872%2C489&ssl=1","jetpack-related-posts":[{"id":692,"url":"https:\/\/ederlelis.com.br\/blog\/configurar-database-mail-no-sql-server-utilizando-uma-conta-do-gmail\/","url_meta":{"origin":792,"position":0},"title":"Configurar Database-mail no SQL Server utilizando uma conta do Gmail.","date":"setembro 5, 2022","format":false,"excerpt":"Bora pra mais um assunto do meu dia a dia, apesar de \"simples\" para alguns, por\u00e9m ainda d\u00e1 trabalho e dor de cabe\u00e7a para muitos, rsrs. Vamos l\u00e1! Neste post voc\u00ea vai aprender na pr\u00e1tica a configurar o Database mail no SQL Server e tamb\u00e9m a configurar uma senha espec\u00edfica\u2026","rel":"","context":"Em &quot;Database mail&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/database_mail.jpg.png?fit=872%2C489&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1406,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte1\/","url_meta":{"origin":792,"position":1},"title":"Migra\u00e7\u00e3o On-Premise para Azure SQL (PARTE1)","date":"janeiro 20, 2025","format":false,"excerpt":"\u2026 vou seguir com meus objetivos e iniciar uma \u201cs\u00e9rie\u201d de post cujo assunto ser\u00e1 \u201cMigra\u00e7\u00e3o On-Premise para Azure SQL\u201d Portanto darei o nome deste de hoje como \u2026PARTE1. Para migrar um database do On-Premise para o Azure SQL temos v\u00e1rias op\u00e7\u00f5es. Cada op\u00e7\u00e3o tem suas vantagens e desvantagens espec\u00edficas.\u2026","rel":"","context":"Com 1 coment\u00e1rio","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/banner.png?fit=616%2C520&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":339,"url":"https:\/\/ederlelis.com.br\/blog\/restore-database-azure-usando-ssms\/","url_meta":{"origin":792,"position":2},"title":"Restore de Backups Armazenados no Azure usando Microsoft SSMS","date":"abril 10, 2022","format":false,"excerpt":"Neste primeiro Post do meu blog abordarei um assunto que a cada dia que passa, quanto mais aprendo, mais quero aprender, SQL x Azure. Vamos fazer um Restore de Backups armazenados no Blob do Azure usando o Microsoft SQL Server Management Studio (SSMS).","rel":"","context":"Em \"Azure\"","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/03\/00.png?fit=447%2C222&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1484,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte2\/","url_meta":{"origin":792,"position":3},"title":"Migra\u00e7\u00e3o On-Premise para Azure SQL (PARTE2)","date":"fevereiro 8, 2025","format":false,"excerpt":"...Dando continuidade \u00e0 nossa s\u00e9rie sobre migra\u00e7\u00e3o de banco de dados on-premise. Se voc\u00ea ainda n\u00e3o leu o primeiro post da s\u00e9rie, d\u00ea uma olhada, ficou bem completo. Usei o m\u00e9todo \u201cDeploy Database to Microsoft Azure SQL Database\u201d, detalhando cada passo. 1) Deploy Database to Microsoft Azure SQL Database (link\u2026","rel":"","context":"Com 1 coment\u00e1rio","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/banner.png?fit=474%2C422&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1580,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-de-banco-de-dados-on-premise-para-azure-sql-parte3\/","url_meta":{"origin":792,"position":4},"title":"Migra\u00e7\u00e3o de Banco de Dados On-Premise para Azure SQL (PARTE3)","date":"fevereiro 26, 2025","format":false,"excerpt":"\u2026Dando continuidade \u00e0 nossa s\u00e9rie sobre migra\u00e7\u00e3o de banco de dados on-premise. Se voc\u00ea ainda n\u00e3o leu os posts anteriores, d\u00ea uma olhada. 1) Deploy Database to Microsoft Azure SQL Database. 2) Backup bacpac com import Agora, na Parte 3, vamos explorar a migra\u00e7\u00e3o usando o DMA. 3. DMA (Data\u2026","rel":"","context":"Post similar","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/dma.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":538,"url":"https:\/\/ederlelis.com.br\/blog\/automatizar_backups_armazenando_em_blob_no_azure\/","url_meta":{"origin":792,"position":5},"title":"Automatizar Backups Armazenando em Blob &#8211; Azure usando Microsoft SSMS","date":"maio 28, 2022","format":false,"excerpt":"Para aqueles que querem criar um Job de Backup e automatizar o trabalho pensando principalmente em seguran\u00e7a, afinal, se um dia algo acontecer com meu banco de dados, ser\u00e1 que est\u00e1 preparado? Quanto \"tempo de dados\" posso perder? 1) Automatiza\u00e7\u00e3o de backup Para criarmos um job de backup vou usar\u2026","rel":"","context":"Em &quot;MSSQL&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/topo_bkp_aut3.png?fit=407%2C316&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/792"}],"collection":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/comments?post=792"}],"version-history":[{"count":22,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/792\/revisions"}],"predecessor-version":[{"id":947,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/792\/revisions\/947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media\/855"}],"wp:attachment":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media?parent=792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/categories?post=792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/tags?post=792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}