{"id":692,"date":"2022-09-05T16:12:55","date_gmt":"2022-09-05T19:12:55","guid":{"rendered":"https:\/\/ederlelis.com.br\/blog\/?p=692"},"modified":"2023-05-11T22:16:46","modified_gmt":"2023-05-12T01:16:46","slug":"configurar-database-mail-no-sql-server-utilizando-uma-conta-do-gmail","status":"publish","type":"post","link":"https:\/\/ederlelis.com.br\/blog\/configurar-database-mail-no-sql-server-utilizando-uma-conta-do-gmail\/","title":{"rendered":"Configurar Database-mail no SQL Server utilizando uma conta do Gmail."},"content":{"rendered":"<p style=\"margin: 0in;\"><span>Ol\u00e1, espero que voc\u00ea esteja bem!&nbsp;<\/span><img draggable=\"false\" role=\"img\" class=\"emoji\" alt=\"\ud83d\ude09\" src=\"https:\/\/s.w.org\/images\/core\/emoji\/13.1.0\/svg\/1f609.svg\"><\/p>\n<p>Bora pra mais um assunto do meu dia a dia, apesar de &#8220;simples&#8221; para alguns, por\u00e9m ainda d\u00e1 trabalho e dor de cabe\u00e7a para muitos, rsrs.<\/p>\n<p>Vamos l\u00e1! Neste post voc\u00ea vai <strong>aprender na pr\u00e1tica a configurar o Database mail<\/strong> no SQL Server e tamb\u00e9m a configurar uma senha espec\u00edfica para este prop\u00f3sito. Neste Lab vamos <strong>usar uma conta do Gmail<\/strong>.<\/p>\n<p>Nosso primeiro passo ser\u00e1 configurar o Database mail no Microsoft SQL Server Management Studio.<\/p>\n<p>Basta ir na<strong> Inst\u00e2ncia a qual vai configurar<\/strong>, depois em <em>Management \/ Database Mail<\/em> e com o bot\u00e3o direito do mouse em <em>Configure Database mail<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"411\" height=\"615\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/1.png?resize=411%2C615&#038;ssl=1\" alt=\"\" class=\"wp-image-696\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/1.png?w=411&amp;ssl=1 411w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/1.png?resize=200%2C300&amp;ssl=1 200w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/1.png?resize=360%2C539&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/1.png?resize=250%2C374&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/1.png?resize=100%2C150&amp;ssl=1 100w\" sizes=\"(max-width: 411px) 100vw, 411px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Aparecer\u00e1 uma tela de boas-vindas.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"504\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/2.png?resize=640%2C504&#038;ssl=1\" alt=\"\" class=\"wp-image-698\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/2.png?w=714&amp;ssl=1 714w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/2.png?resize=300%2C236&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/2.png?resize=700%2C551&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/2.png?resize=520%2C409&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/2.png?resize=360%2C283&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/2.png?resize=250%2C197&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/2.png?resize=100%2C79&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Como n\u00e3o temos nenhuma conta criada, vamos ent\u00e3o criar uma nova conta e tamb\u00e9m um profile.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"504\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/3.png?resize=640%2C504&#038;ssl=1\" alt=\"\" class=\"wp-image-699\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/3.png?w=713&amp;ssl=1 713w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/3.png?resize=300%2C236&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/3.png?resize=700%2C552&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/3.png?resize=520%2C410&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/3.png?resize=360%2C284&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/3.png?resize=250%2C197&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/3.png?resize=100%2C79&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Por default, o SQL Server vem com o Database mail desabilitado<\/strong>, portanto basta aperta o YES para habilitar, caso este seja seu caso tamb\u00e9m.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"329\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/4.png?resize=640%2C329&#038;ssl=1\" alt=\"\" class=\"wp-image-700\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/4.png?w=645&amp;ssl=1 645w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/4.png?resize=300%2C154&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/4.png?resize=520%2C268&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/4.png?resize=360%2C185&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/4.png?resize=250%2C129&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/4.png?resize=100%2C51&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Pr\u00f3xima tela vamos <strong>criar nosso Profile<\/strong> e abaixo <strong>adicionar uma conta<\/strong> clicando em <em>Add<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"318\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/5.png?resize=640%2C318&#038;ssl=1\" alt=\"\" class=\"wp-image-701\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/5.png?w=708&amp;ssl=1 708w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/5.png?resize=300%2C149&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/5.png?resize=700%2C348&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/5.png?resize=520%2C259&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/5.png?resize=360%2C179&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/5.png?resize=250%2C124&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/5.png?resize=100%2C50&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos cadastrar um Profile com o nome de MSSQLServer.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"76\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/6.png?resize=640%2C76&#038;ssl=1\" alt=\"\" class=\"wp-image-702\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/6.png?w=704&amp;ssl=1 704w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/6.png?resize=300%2C36&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/6.png?resize=700%2C84&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/6.png?resize=520%2C62&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/6.png?resize=360%2C43&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/6.png?resize=250%2C30&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/6.png?resize=100%2C12&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Temos agora algumas informa\u00e7\u00f5es para preencher:<\/p>\n<ul>\n<li>Conta;<\/li>\n<li>SMTP \/ Porta;<\/li>\n<li>Requer conex\u00e3o segura (SSL);<\/li>\n<li>E-mail;<\/li>\n<li>Senha;<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"574\" height=\"457\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/7.png?resize=574%2C457&#038;ssl=1\" alt=\"\" class=\"wp-image-703\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/7.png?w=574&amp;ssl=1 574w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/7.png?resize=300%2C239&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/7.png?resize=520%2C414&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/7.png?resize=360%2C287&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/7.png?resize=250%2C199&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/7.png?resize=100%2C80&amp;ssl=1 100w\" sizes=\"(max-width: 574px) 100vw, 574px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Nesse momento vamos precisar usar um e-mail existente ou criar um espec\u00edfico para usar como envio.<\/p>\n<p>E conforme dito, vamos usar um <strong>e-mail do Gmail<\/strong>.<\/p>\n<p>Ap\u00f3s preencher as informa\u00e7\u00f5es referentes ao e-mail usado, basta dar <em>OK<\/em> e depois <em>NEXT<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"572\" height=\"460\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/8.png?resize=572%2C460&#038;ssl=1\" alt=\"\" class=\"wp-image-705\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/8.png?w=572&amp;ssl=1 572w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/8.png?resize=300%2C241&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/8.png?resize=520%2C418&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/8.png?resize=360%2C290&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/8.png?resize=250%2C201&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/8.png?resize=100%2C80&amp;ssl=1 100w\" sizes=\"(max-width: 572px) 100vw, 572px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"476\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/9.png?resize=640%2C476&#038;ssl=1\" alt=\"\" class=\"wp-image-707\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/9.png?w=711&amp;ssl=1 711w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/9.png?resize=300%2C223&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/9.png?resize=700%2C521&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/9.png?resize=520%2C387&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/9.png?resize=360%2C268&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/9.png?resize=250%2C186&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/9.png?resize=100%2C74&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos selecionar o <strong>perfil como p\u00fablico<\/strong> (caso necess\u00e1rio podemos limitar o acesso dos usu\u00e1rios na procedure sp_send_dbmail) e deixar o <strong>Profile como Default<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"478\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/10.png?resize=640%2C478&#038;ssl=1\" alt=\"\" class=\"wp-image-708\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/10.png?w=713&amp;ssl=1 713w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/10.png?resize=300%2C224&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/10.png?resize=700%2C523&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/10.png?resize=520%2C389&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/10.png?resize=360%2C269&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/10.png?resize=250%2C187&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/10.png?resize=100%2C75&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Em seguida basta <strong>conferir se as informa\u00e7\u00f5es est\u00e3o corretas<\/strong> e finalizar.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"477\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/11.png?resize=640%2C477&#038;ssl=1\" alt=\"\" class=\"wp-image-709\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/11.png?w=712&amp;ssl=1 712w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/11.png?resize=300%2C224&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/11.png?resize=700%2C522&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/11.png?resize=520%2C388&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/11.png?resize=360%2C268&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/11.png?resize=250%2C186&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/11.png?resize=100%2C75&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Cadastro efetuado com sucesso.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"226\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/12.png?resize=640%2C226&#038;ssl=1\" alt=\"\" class=\"wp-image-710\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/12.png?w=703&amp;ssl=1 703w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/12.png?resize=300%2C106&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/12.png?resize=700%2C247&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/12.png?resize=520%2C183&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/12.png?resize=360%2C127&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/12.png?resize=250%2C88&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/12.png?resize=100%2C35&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos agora validar algumas informa\u00e7\u00f5es cadastradas.<\/p>\n<pre class=\"lang:tsql decode:true \">-- Verificar se o Database mail est\u00e1 habilitado\n\nsp_configure 'show advanced', 1; \nGO\nRECONFIGURE;\nGO\nsp_configure;\nGO<\/pre>\n<p><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"512\" height=\"121\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/13.png?resize=512%2C121&#038;ssl=1\" alt=\"\" class=\"wp-image-715\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/13.png?w=512&amp;ssl=1 512w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/13.png?resize=300%2C71&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/13.png?resize=360%2C85&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/13.png?resize=250%2C59&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/13.png?resize=100%2C24&amp;ssl=1 100w\" sizes=\"(max-width: 512px) 100vw, 512px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<pre class=\"lang:tsql decode:true \">-- Verificar se o Database Mail foi iniciado.\n\nEXEC msdb.dbo.sysmail_help_status_sp;<\/pre>\n<p><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"155\" height=\"75\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/14.png?resize=155%2C75&#038;ssl=1\" alt=\"\" class=\"wp-image-716\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/14.png?w=155&amp;ssl=1 155w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/14.png?resize=100%2C48&amp;ssl=1 100w\" sizes=\"(max-width: 155px) 100vw, 155px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Caso esteja com <em>Status<\/em> <strong>STOPPED<\/strong>, ser\u00e1 necess\u00e1rio fazer o <em>START<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"159\" height=\"73\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/15.png?resize=159%2C73&#038;ssl=1\" alt=\"\" class=\"wp-image-717\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/15.png?w=159&amp;ssl=1 159w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/15.png?resize=100%2C46&amp;ssl=1 100w\" sizes=\"(max-width: 159px) 100vw, 159px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Podemos usar os seguintes scripts:<\/p>\n<pre class=\"lang:tsql decode:true\">use msdb\n\n-- start\nEXEC msdb.dbo.sysmail_start_sp;\n\n--stop\nEXEC msdb.dbo.sysmail_stop_sp;\n<\/pre>\n<p><\/p>\n<p>O pr\u00f3xima valida\u00e7\u00e3o \u00e9 conferir nosso profile cadastrado.<\/p>\n<pre class=\"lang:tsql decode:true \">SELECT P.name\n\t,A.display_name\n\t,A.email_address\n\t,A.name\n\t,PA.sequence_number\nFROM msdb..sysmail_profileaccount PA\nJOIN msdb..sysmail_account A ON A.account_id = PA.account_id\nJOIN msdb..sysmail_profile P ON P.profile_id = PA.profile_id<\/pre>\n<p><\/p>\n<p>Aqui temos um resumo.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"596\" height=\"79\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/16.png?resize=596%2C79&#038;ssl=1\" alt=\"\" class=\"wp-image-718\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/16.png?w=596&amp;ssl=1 596w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/16.png?resize=300%2C40&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/16.png?resize=520%2C69&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/16.png?resize=360%2C48&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/16.png?resize=250%2C33&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/16.png?resize=100%2C13&amp;ssl=1 100w\" sizes=\"(max-width: 596px) 100vw, 596px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Com base nas informa\u00e7\u00f5es acima<\/strong>, iremos fazer nosso teste de envio.<\/p>\n<p>Temos duas op\u00e7\u00f5es para realizar este teste, <strong>por T-SQL e\/ou por tela (SSMS)<\/strong>:<\/p>\n<p><strong>1) T-SQL<\/strong><\/p>\n<pre class=\"lang:tsql decode:true\">-- Teste envio de e-mail\n\t\nEXEC msdb.dbo.sp_send_dbmail @profile_name = 'MSSQLServer'\n,@recipients = 'SEUEMAIL@gmail.com'\n,@subject = 'ASSUNTO: TESTE ENVIO DE E-MAIL'\n,@body = 'CORPO E-MAIL TESTE'\n,@body_format = 'HTML'<\/pre>\n<p><\/p>\n<p>Pelo resultado n\u00e3o sabemos se foi enviado com sucesso ou n\u00e3o.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"486\" height=\"236\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/17.png?resize=486%2C236&#038;ssl=1\" alt=\"\" class=\"wp-image-719\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/17.png?w=486&amp;ssl=1 486w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/17.png?resize=300%2C146&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/17.png?resize=360%2C175&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/17.png?resize=250%2C121&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/17.png?resize=100%2C49&amp;ssl=1 100w\" sizes=\"(max-width: 486px) 100vw, 486px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Para validar, vamos usar uma query com um <em>CASE<\/em> que mostrar\u00e1 o <strong>status<\/strong> do &#8220;<em>envio<\/em>&#8220;.<\/p>\n<pre class=\"lang:tsql decode:true\">-- Verifica o Status das solicita\u00e7\u00f5es de envio do E-mail.\n\nSELECT TOP 50 sent_status\n\t,CASE sent_status\n\t\tWHEN 0\n\t\t\tTHEN 'Unsent'\n\t\tWHEN 1\n\t\t\tTHEN 'Sent'\n\t\tWHEN 2\n\t\t\tTHEN 'Failed'\n\t\tWHEN 3\n\t\t\tTHEN 'Retrying'\n\t\tEND AS sent_status_description\n\t,send_request_date\n\t,*\nFROM msdb.dbo.sysmail_mailitems\nORDER BY 3 DESC\n<\/pre>\n<p><\/p>\n<p>Chiii e agora, <strong>e-mail falhou<\/strong>. Alguma sugest\u00e3o?<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"45\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?resize=640%2C45&#038;ssl=1\" alt=\"\" class=\"wp-image-720\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?w=972&amp;ssl=1 972w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?resize=300%2C21&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?resize=768%2C54&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?resize=700%2C49&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?resize=520%2C36&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?resize=360%2C25&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?resize=250%2C17&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/18.png?resize=100%2C7&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos verificar o motivo?<\/p>\n<pre class=\"lang:tsql decode:true\">-- Verifica motivo de falha no envio de e-mail\n\nSELECT SEL.event_type\n\t,SEL.log_date\n\t,SEL.description\n\t,SF.mailitem_id\n\t,SF.recipients\n\t,SF.copy_recipients\n\t,SF.blind_copy_recipients\n\t,SF.subject\n\t,SF.body\n\t,SF.sent_status\n\t,SF.sent_date\nFROM msdb.dbo.sysmail_faileditems AS SF\nJOIN msdb.dbo.sysmail_event_log AS SEL ON SF.mailitem_id = SEL.mailitem_id\nORDER BY log_date DESC\n<\/pre>\n<p><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"41\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?resize=640%2C41&#038;ssl=1\" alt=\"\" class=\"wp-image-721\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?w=995&amp;ssl=1 995w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?resize=300%2C19&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?resize=768%2C49&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?resize=700%2C45&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?resize=520%2C33&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?resize=360%2C23&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?resize=250%2C16&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/19.png?resize=100%2C6&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Copiando a <strong><em>description<\/em> <\/strong>temos:<\/p>\n<p>&#8220;<em>The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2022-09-04T23:15:45). Exception Message: Cannot send mails to mail server. (O servidor SMTP requer uma conex\u00e3o segura ou o cliente n\u00e3o foi autenticado. A resposta do servidor foi: 5.7.0 Authentication Required. Learn more at). )&#8221;<\/em><\/p>\n<p>Ou seja, <strong>problema na autentica\u00e7\u00e3o<\/strong>.<\/p>\n<p>Mas como, se eu coloquei exatamente minha senha do e-mail do Gmail e \u00e9 <strong>a mesma que uso para ver meus e-mail todo dia!!! Tenho certeza que est\u00e1 correta.<\/strong><\/p>\n<p>Alguma sugest\u00e3o?<\/p>\n<p>Teremos que clicar no <em>esqueci a senha no Gmail<\/em> e configurar outra (apesar que tenho certeza que est\u00e1 correta)?<\/p>\n<p>N\u00e3o!<\/p>\n<p>Agora vai a principal dica, anota a\u00ed&#8230;!<\/p>\n<p><strong>O Gmail por quest\u00e3o de seguran\u00e7a mudou algumas regras<\/strong>, dentre elas a verifica\u00e7\u00e3o em duas etapas e a gera\u00e7\u00e3o de senhas de app.<\/p>\n<p>Segue uma postagem a respeito:<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"294\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/20.png?resize=640%2C294&#038;ssl=1\" alt=\"\" class=\"wp-image-722\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/20.png?w=651&amp;ssl=1 651w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/20.png?resize=300%2C138&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/20.png?resize=520%2C239&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/20.png?resize=360%2C165&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/20.png?resize=250%2C115&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/20.png?resize=100%2C46&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><em><strong>O que \u00e9 a autentica\u00e7\u00e3o em dois fatores<\/strong><\/em><\/p>\n<p><em>A autentica\u00e7\u00e3o de dois fatores, seguran\u00e7a multifator ou verifica\u00e7\u00e3o em duas etapas, \u00e9 um m\u00e9todo de seguran\u00e7a adotado atualmente por quase todas as empresas criadores de apps e programas web. Na verdade, significa logar-se, com dois procedimentos, sempre confirmando a identidade n\u00e3o somente com uma senha, mas verifica-la em outro dispositivo, por exemplo, ou um c\u00f3digo (chave). Assim, para abrir a caixa de entrada de um servi\u00e7o de e-mail, voc\u00ea dever\u00e1 digitar a senha habitual e confirmar que voc\u00ea \u00e9 voc\u00ea, acessando a caixa de entrada, para confirmar em outro aparelho \u2013 tablet, PC, celular.<\/em><\/p>\n<p><strong><em>Qual \u00e9 o objetivo?<\/em><\/strong><br><em>Google explica que a iniciativa pretende colocar todas as contas em um n\u00edvel de prote\u00e7\u00e3o e seguran\u00e7a padr\u00e3o, minimizando intercorr\u00eancias com brechas na seguran\u00e7a.<\/em><\/p>\n<p style=\"margin: 0in; font-family: Calibri; font-size: 11.0pt;\"><em><a href=\"https:\/\/br.ccm.net\/faq\/57941-contas-google-com-autenticacao-em-dois-fatores-obrigatorio-para-todos\" target=\"_blank\" rel=\"noopener\">Refer\u00eancial: Contas Google com autentica\u00e7\u00e3o em dois fatores: obrigat\u00f3rio para todos<\/a><\/em><\/p>\n<p><\/p>\n<p><strong>Portanto vamos precisar fazer login em nossa conta do Gmail e fazer os ajustes necess\u00e1rios.<\/strong><\/p>\n<p><strong>OBS:<\/strong> <strong>neste caso vamos usar nossa senha &#8220;padr\u00e3o&#8221; que j\u00e1 sabemos.<\/strong><\/p>\n<p style=\"margin: 0in; font-family: Calibri; font-size: 11.0pt;\"><a href=\"https:\/\/myaccount.google.com\/intro\/security\" target=\"_blank\" rel=\"noopener\">Link: Fazer login na conta do Google<\/a><\/p>\n<p>Ap\u00f3s logar, vamos em <strong><em>Seguran\u00e7a<\/em><\/strong> para depois ativar a verifica\u00e7\u00e3o em duas etapas.<\/p>\n<p><\/p>\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"258\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=640%2C258&#038;ssl=1\" alt=\"\" class=\"wp-image-723\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=1024%2C412&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=300%2C121&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=768%2C309&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=700%2C282&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=520%2C209&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=360%2C145&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=250%2C101&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?resize=100%2C40&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/21.png?w=1116&amp;ssl=1 1116w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Ir\u00e1 solicitar um telefone para cadastrar, o qual ser\u00e1 feito uma valida\u00e7\u00e3o inicial.<\/p>\n<p>Em seguida <em>Avan\u00e7ar<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"446\" height=\"437\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/22.png?resize=446%2C437&#038;ssl=1\" alt=\"\" class=\"wp-image-724\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/22.png?w=446&amp;ssl=1 446w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/22.png?resize=300%2C294&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/22.png?resize=360%2C353&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/22.png?resize=250%2C245&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/22.png?resize=100%2C98&amp;ssl=1 100w\" sizes=\"(max-width: 446px) 100vw, 446px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>O <strong>Google vai enviar um c\u00f3digo<\/strong>, voc\u00ea precisar\u00e1 dele para continuar.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"633\" height=\"344\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/27.png?resize=633%2C344&#038;ssl=1\" alt=\"\" class=\"wp-image-725\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/27.png?w=633&amp;ssl=1 633w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/27.png?resize=300%2C163&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/27.png?resize=520%2C283&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/27.png?resize=360%2C196&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/27.png?resize=250%2C136&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/27.png?resize=100%2C54&amp;ssl=1 100w\" sizes=\"(max-width: 633px) 100vw, 633px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Feito isso, basta <em>ATIVAR<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"628\" height=\"316\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/28.png?resize=628%2C316&#038;ssl=1\" alt=\"\" class=\"wp-image-726\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/28.png?w=628&amp;ssl=1 628w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/28.png?resize=300%2C151&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/28.png?resize=520%2C262&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/28.png?resize=360%2C181&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/28.png?resize=250%2C126&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/28.png?resize=100%2C50&amp;ssl=1 100w\" sizes=\"(max-width: 628px) 100vw, 628px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"636\" height=\"443\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/29.png?resize=636%2C443&#038;ssl=1\" alt=\"\" class=\"wp-image-727\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/29.png?w=636&amp;ssl=1 636w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/29.png?resize=300%2C209&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/29.png?resize=520%2C362&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/29.png?resize=360%2C251&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/29.png?resize=250%2C174&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/29.png?resize=100%2C70&amp;ssl=1 100w\" sizes=\"(max-width: 636px) 100vw, 636px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Pronto ativada, vamos voltar para tela inicial de seguran\u00e7a.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"182\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/30.png?resize=640%2C182&#038;ssl=1\" alt=\"\" class=\"wp-image-728\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/30.png?w=708&amp;ssl=1 708w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/30.png?resize=300%2C85&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/30.png?resize=700%2C199&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/30.png?resize=520%2C148&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/30.png?resize=360%2C102&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/30.png?resize=250%2C71&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/30.png?resize=100%2C28&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Nosso pr\u00f3ximo passo \u00e9 <strong>gerar uma senha espec\u00edfica de app<\/strong>, ou seja, lembra quando o SSMS deu um erro com a senha padr\u00e3o que usamos? Agora ele vai ter uma senha s\u00f3 pra ele (ego\u00edsta, rsrs)!<\/p>\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"214\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=640%2C214&#038;ssl=1\" alt=\"\" class=\"wp-image-729\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=1024%2C342&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=300%2C100&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=768%2C256&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=700%2C234&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=520%2C174&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=360%2C120&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=250%2C83&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?resize=100%2C33&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/31.png?w=1159&amp;ssl=1 1159w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Caso n\u00e3o ache a op\u00e7\u00e3o &#8220;Senhas de app&#8221;, na listagem.\u00a0<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"270\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?resize=640%2C270&#038;ssl=1\" alt=\"\" class=\"wp-image-868\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?w=1013&amp;ssl=1 1013w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?resize=300%2C126&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?resize=768%2C324&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?resize=700%2C295&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?resize=520%2C219&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?resize=360%2C152&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?resize=250%2C105&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista.jpg?resize=100%2C42&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Basta pesquisar &#8220;Senhas&#8221; que vai aparecer, e ent\u00e3o clicar.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"435\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista2.jpg?resize=640%2C435&#038;ssl=1\" alt=\"\" class=\"wp-image-869\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista2.jpg?w=645&amp;ssl=1 645w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista2.jpg?resize=300%2C204&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista2.jpg?resize=520%2C353&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista2.jpg?resize=360%2C244&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista2.jpg?resize=250%2C170&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/lista2.jpg?resize=100%2C68&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Precisamos fazer login na conta novamente usando nossa senha &#8220;<em>padr\u00e3o&#8221;<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"414\" height=\"269\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/32.png?resize=414%2C269&#038;ssl=1\" alt=\"\" class=\"wp-image-730\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/32.png?w=414&amp;ssl=1 414w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/32.png?resize=300%2C195&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/32.png?resize=360%2C234&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/32.png?resize=250%2C162&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/32.png?resize=100%2C65&amp;ssl=1 100w\" sizes=\"(max-width: 414px) 100vw, 414px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Nesta tela vamos selecionar a op\u00e7\u00e3o <em><strong>outro (nome personalizado)<\/strong><\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"376\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?resize=640%2C376&#038;ssl=1\" alt=\"\" class=\"wp-image-731\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?w=954&amp;ssl=1 954w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?resize=300%2C176&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?resize=768%2C451&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?resize=700%2C411&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?resize=520%2C305&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?resize=360%2C211&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?resize=250%2C147&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/33.png?resize=100%2C59&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Iremos colocar um nome sugestivo para ajudar em uma futura manuten\u00e7\u00e3o. Ficando f\u00e1cil lembrar quais as senhas estou ainda usando e quais posso deletar.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"362\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/34.png?resize=640%2C362&#038;ssl=1\" alt=\"\" class=\"wp-image-732\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/34.png?w=690&amp;ssl=1 690w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/34.png?resize=300%2C170&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/34.png?resize=520%2C294&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/34.png?resize=360%2C203&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/34.png?resize=250%2C141&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/34.png?resize=100%2C57&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Ao clicar em <em>gerar<\/em>, aparecer\u00e1 uma senha. Copie em algum bloco de anota\u00e7\u00f5es, pois vamos precisar dela para configurar no SSMS.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"628\" height=\"456\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/35.png?resize=628%2C456&#038;ssl=1\" alt=\"\" class=\"wp-image-733\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/35.png?w=628&amp;ssl=1 628w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/35.png?resize=300%2C218&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/35.png?resize=520%2C378&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/35.png?resize=360%2C261&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/35.png?resize=250%2C182&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/35.png?resize=100%2C73&amp;ssl=1 100w\" sizes=\"(max-width: 628px) 100vw, 628px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Pronto, senha criada.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"345\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/36.png?resize=640%2C345&#038;ssl=1\" alt=\"\" class=\"wp-image-734\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/36.png?w=677&amp;ssl=1 677w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/36.png?resize=300%2C162&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/36.png?resize=520%2C280&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/36.png?resize=360%2C194&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/36.png?resize=250%2C135&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/36.png?resize=100%2C54&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos voltar no SSMS.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"319\" height=\"393\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/37.png?resize=319%2C393&#038;ssl=1\" alt=\"\" class=\"wp-image-735\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/37.png?w=319&amp;ssl=1 319w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/37.png?resize=244%2C300&amp;ssl=1 244w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/37.png?resize=250%2C308&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/37.png?resize=100%2C123&amp;ssl=1 100w\" sizes=\"(max-width: 319px) 100vw, 319px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Agora j\u00e1 temos uma conta criada, e tamb\u00e9m um profile, pois criamos ambos anteriormente. Portanto basta selecionar a op\u00e7\u00e3o <em>Manage Database Mail accounts and profiles<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"478\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/38.png?resize=640%2C478&#038;ssl=1\" alt=\"\" class=\"wp-image-736\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/38.png?w=710&amp;ssl=1 710w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/38.png?resize=300%2C224&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/38.png?resize=700%2C523&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/38.png?resize=520%2C388&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/38.png?resize=360%2C269&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/38.png?resize=250%2C187&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/38.png?resize=100%2C75&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos colocar nossa nova senha rec\u00e9m criada.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"480\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/39.png?resize=640%2C480&#038;ssl=1\" alt=\"\" class=\"wp-image-737\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/39.png?w=711&amp;ssl=1 711w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/39.png?resize=300%2C225&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/39.png?resize=700%2C525&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/39.png?resize=520%2C390&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/39.png?resize=360%2C270&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/39.png?resize=250%2C187&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/39.png?resize=100%2C75&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Em seguida Next \/ Finishi \/ Close.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"193\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/40.png?resize=640%2C193&#038;ssl=1\" alt=\"\" class=\"wp-image-738\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/40.png?w=692&amp;ssl=1 692w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/40.png?resize=300%2C91&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/40.png?resize=520%2C157&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/40.png?resize=360%2C109&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/40.png?resize=250%2C76&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/40.png?resize=100%2C30&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Faremos novo teste de envio de e-mail.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"544\" height=\"224\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/41.png?resize=544%2C224&#038;ssl=1\" alt=\"\" class=\"wp-image-739\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/41.png?w=544&amp;ssl=1 544w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/41.png?resize=300%2C124&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/41.png?resize=520%2C214&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/41.png?resize=360%2C148&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/41.png?resize=250%2C103&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/41.png?resize=100%2C41&amp;ssl=1 100w\" sizes=\"(max-width: 544px) 100vw, 544px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos conferir se deu certo.<\/p>\n<p>Agora sim, <strong>enviado com sucesso.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"269\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?resize=640%2C269&#038;ssl=1\" alt=\"\" class=\"wp-image-740\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?w=929&amp;ssl=1 929w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?resize=300%2C126&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?resize=768%2C323&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?resize=700%2C295&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?resize=520%2C219&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?resize=360%2C152&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?resize=250%2C105&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/42.png?resize=100%2C42&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos conferir se realmente recebemos o e-mail?<\/p>\n<p>Oba, aqui deu certo, e a\u00ed com voc\u00ea? Me diga se mesmo ap\u00f3s todos os passos realizados ainda deu algum erro pra voc\u00ea!<\/p>\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"120\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=640%2C120&#038;ssl=1\" alt=\"\" class=\"wp-image-741\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=1024%2C192&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=300%2C56&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=768%2C144&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=700%2C131&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=520%2C97&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=360%2C67&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=250%2C47&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?resize=100%2C19&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/43.png?w=1079&amp;ssl=1 1079w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>2) Via tela (SSMS)<\/strong><\/p>\n<p>Agora vamos testar via tela? Alguns preferem esse m\u00e9todo.<\/p>\n<p><strong>Basta ir no Database mail<\/strong>, bot\u00e3o direito e clicar em <strong>Send Teste E-mail<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"347\" height=\"392\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/44.png?resize=347%2C392&#038;ssl=1\" alt=\"\" class=\"wp-image-743\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/44.png?w=347&amp;ssl=1 347w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/44.png?resize=266%2C300&amp;ssl=1 266w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/44.png?resize=250%2C282&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/44.png?resize=100%2C113&amp;ssl=1 100w\" sizes=\"(max-width: 347px) 100vw, 347px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Preencher o e-mail<\/strong> que vai receber o teste e clicar em <strong>Send Test E-Mai<\/strong>l. <\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"460\" height=\"279\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/45.png?resize=460%2C279&#038;ssl=1\" alt=\"\" class=\"wp-image-744\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/45.png?w=460&amp;ssl=1 460w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/45.png?resize=300%2C182&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/45.png?resize=360%2C218&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/45.png?resize=250%2C152&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/45.png?resize=100%2C61&amp;ssl=1 100w\" sizes=\"(max-width: 460px) 100vw, 460px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Depois em <strong>OK<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"388\" height=\"276\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/46.png?resize=388%2C276&#038;ssl=1\" alt=\"\" class=\"wp-image-745\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/46.png?w=388&amp;ssl=1 388w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/46.png?resize=300%2C213&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/46.png?resize=360%2C256&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/46.png?resize=250%2C178&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/46.png?resize=100%2C71&amp;ssl=1 100w\" sizes=\"(max-width: 388px) 100vw, 388px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Vamos conferir?<\/p>\n<p>Pronto, enviado tamb\u00e9m com sucesso!<\/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\/09\/47.png?resize=640%2C65&#038;ssl=1\" alt=\"\" class=\"wp-image-746\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/47.png?w=990&amp;ssl=1 990w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/47.png?resize=300%2C31&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/47.png?resize=768%2C78&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/47.png?resize=700%2C71&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/47.png?resize=520%2C53&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/47.png?resize=360%2C37&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/47.png?resize=250%2C26&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/47.png?resize=100%2C10&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Com o e-mail configurado, temos uma ampla possibilidade de usar a nosso favor.<\/strong><\/p>\n<p><\/p>\n<p><strong>Que tal um b\u00f4nus agora?<\/strong><\/p>\n<p>Uma das grandes vantagens \u00e9 usar o e-mail em caso de <strong>falha na execu\u00e7\u00e3o de um Job<\/strong>, como por exemplo um Job de Backup, que falha por um motivo. Talvez por espa\u00e7o em disco insuficiente, e com isso se n\u00f3s DBA recebermos um e-mail informando que o backup falhou, poderemos resolver muito mais r\u00e1pido o problema do que se descobrirmos s\u00f3 mesmo no dia em que precisar do tal backup e descobrirmos que n\u00e3o temos.<\/p>\n<p><\/p>\n<p>Sendo assim segue como exemplo um post meu, onde foi feito a <a href=\"https:\/\/ederlelis.com.br\/blog\/automatizar_backups_armazenando_em_blob_no_azure\/\" target=\"_blank\" rel=\"noopener\"><strong>cria\u00e7\u00e3o de um Job de Backup.<\/strong><\/a><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><a href=\"https:\/\/ederlelis.com.br\/blog\/automatizar_backups_armazenando_em_blob_no_azure\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"640\" height=\"375\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/bonus.png?resize=640%2C375&#038;ssl=1\" alt=\"\" class=\"wp-image-747\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/bonus.png?w=719&amp;ssl=1 719w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/bonus.png?resize=300%2C176&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/bonus.png?resize=700%2C410&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/bonus.png?resize=520%2C304&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/bonus.png?resize=360%2C211&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/bonus.png?resize=250%2C146&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/bonus.png?resize=100%2C59&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/a><\/figure>\n\n\n<p>Antes de alterar as configura\u00e7\u00f5es no Job, teremos que <strong>configurar um Operador.<\/strong><\/p>\n<p>No meu caso j\u00e1 tenho meus Operadores configurados, mas caso voc\u00ea n\u00e3o tenha, basta adicionar um <em><strong>New Operado<\/strong><\/em><strong>r<\/strong>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"328\" height=\"365\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/50-1.png?resize=328%2C365&#038;ssl=1\" alt=\"\" class=\"wp-image-751\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/50-1.png?w=328&amp;ssl=1 328w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/50-1.png?resize=270%2C300&amp;ssl=1 270w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/50-1.png?resize=250%2C278&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/50-1.png?resize=100%2C111&amp;ssl=1 100w\" sizes=\"(max-width: 328px) 100vw, 328px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Preencher o e-mail que ir\u00e1 receber as mensagens e <em>Habilitar<\/em><\/strong>, <strong>depois <em>OK<\/em>.<\/strong><\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"516\" height=\"654\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/51.png?resize=516%2C654&#038;ssl=1\" alt=\"\" class=\"wp-image-750\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/51.png?w=516&amp;ssl=1 516w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/51.png?resize=237%2C300&amp;ssl=1 237w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/51.png?resize=360%2C456&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/51.png?resize=250%2C317&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/51.png?resize=100%2C127&amp;ssl=1 100w\" sizes=\"(max-width: 516px) 100vw, 516px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Agora vamos alterar as <strong>Propriedades do Job<\/strong> para configurar a notifica\u00e7\u00e3o.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"484\" height=\"416\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/52.png?resize=484%2C416&#038;ssl=1\" alt=\"\" class=\"wp-image-752\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/52.png?w=484&amp;ssl=1 484w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/52.png?resize=300%2C258&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/52.png?resize=360%2C309&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/52.png?resize=250%2C215&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/52.png?resize=100%2C86&amp;ssl=1 100w\" sizes=\"(max-width: 484px) 100vw, 484px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Selecione <em>Notifications<\/em>, marque a <em>caixinha do E-mail. E<\/em>scolha o <em>Operador<\/em> a qual configuramos o e-mail e selecione <em>&#8220;alertar&#8221; em caso de falhas<\/em>.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"200\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/53.png?resize=640%2C200&#038;ssl=1\" alt=\"\" class=\"wp-image-753\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/53.png?w=685&amp;ssl=1 685w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/53.png?resize=300%2C94&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/53.png?resize=520%2C162&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/53.png?resize=360%2C112&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/53.png?resize=250%2C78&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/53.png?resize=100%2C31&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Bora testar?<\/p>\n<p>Vamos iniciar o job manualmente.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"389\" height=\"238\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/54-1.png?resize=389%2C238&#038;ssl=1\" alt=\"\" class=\"wp-image-754\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/54-1.png?w=389&amp;ssl=1 389w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/54-1.png?resize=300%2C184&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/54-1.png?resize=360%2C220&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/54-1.png?resize=250%2C153&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/54-1.png?resize=100%2C61&amp;ssl=1 100w\" sizes=\"(max-width: 389px) 100vw, 389px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"386\" height=\"202\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/55.png?resize=386%2C202&#038;ssl=1\" alt=\"\" class=\"wp-image-755\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/55.png?w=386&amp;ssl=1 386w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/55.png?resize=300%2C157&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/55.png?resize=360%2C188&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/55.png?resize=250%2C131&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/55.png?resize=100%2C52&amp;ssl=1 100w\" sizes=\"(max-width: 386px) 100vw, 386px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p>Veja que maravilha, <strong>recebemos o alerta da falha em nosso e-mail cadastrado<\/strong> e com isso podemos validar qual o motivo da falha no Job de Backup.<\/p>\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"132\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?resize=640%2C132&#038;ssl=1\" alt=\"\" class=\"wp-image-756\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?w=992&amp;ssl=1 992w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?resize=300%2C62&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?resize=768%2C158&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?resize=700%2C144&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?resize=520%2C107&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?resize=360%2C74&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?resize=250%2C51&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/56.png?resize=100%2C21&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n<p><strong>Portanto<\/strong> <strong>aprendemos a configurar o Database mail no SSMS, usando uma conta do Gmail e tamb\u00e9m alguns passos extras.<\/strong><\/p>\n<p>A utiliza\u00e7\u00e3o do SMTP pode ser n\u00e3o s\u00f3 do Gmail, mas tamb\u00e9m de outros provedores.&nbsp; <strong>Por\u00e9m cada um tem suas regras<\/strong> de seguran\u00e7a e podem exigir alguns par\u00e2metros diferentes para ajustarem. N\u00e3o sendo suficiente apenas inserir uma &#8220;simples senha&#8221; no Database mail e acharmos que vai dar tudo certo.<\/p>\n<p>Por exemplo, para quem usa o SMTP do Office, pode estar passando alguma raiva com o envio do e-mail. Acontece que <strong>a Microsoft tamb\u00e9m por motivo de seguran\u00e7a passou a exigir algumas mudan\u00e7as. <\/strong>E neste caso, \u00e9 necess\u00e1rio validar v\u00e1rias configura\u00e7\u00f5es tanto no Servidor SQL Server, mas tamb\u00e9m no portal da conta Microsoft. Tenho atuado em bastante clientes assim, sendo necess\u00e1rio a realiza\u00e7\u00e3o de v\u00e1rios ajustes e com isso logo em seguida o e-mail volta a funcionar como um &#8220;passe de m\u00e1gica&#8221;, rsrs. Mas este ser\u00e1 assunto para uma outra postagem.<\/p>\n<p><strong>Conclu\u00edmos que com o e-mail funcionando no Servidor, podemos ajustar os Jobs para notificar de falhas. Por\u00e9m a funcionalidade n\u00e3o fica restrito apenas nesse exemplo que usamos. Podemos usar al\u00e9m das notifica\u00e7\u00f5es, tamb\u00e9m o envio de promo\u00e7\u00f5es, newsletter dentro outros.<\/strong><\/p>\n<p><\/p>\n<p>Outro ponto que deve ser ressaltado \u00e9 com base nas poss\u00edveis valida\u00e7\u00f5es e checagens de erros. Resolvi escrever este post pois passei por v\u00e1rias refer\u00eancias muito boas, por\u00e9m sempre precisei pegar algo a mais, ou a menos. Portanto caso n\u00e3o tenha resolvido o seu problema n\u00e3o desanime, o seu problema pode estar relacionado a algum ponto a qual n\u00e3o precisei para fazer este post, e por isso n\u00e3o foi citado. Mas com certeza vai ter um solu\u00e7\u00e3o em outro material.<\/p>\n<p>Com base nesta quest\u00e3o, segue como refer\u00eancia uma postagem bem completa do meu amigo Dirceu Resende.<\/p>\n<p style=\"margin: 0in; font-family: Calibri; font-size: 11.0pt;\"><a href=\"https:\/\/www.dirceuresende.com\/blog\/como-habilitar-enviar-monitorar-emails-pelo-sql-server-sp_send_dbmail\/\" target=\"_blank\" rel=\"noopener\">SQL Server &#8211; Como ativar e configurar o Database mail para enviar e monitorar e-mails pelo banco de dados (sp_send_dbmail)<\/a><\/p>\n<p><\/p>\n<p>\u00c9 isso pessoal, obrigado e espero que tenha contribu\u00eddo alguma coisa para o seu aprendizado.<\/p>\n<p>Quaisquer d\u00favidas, sugest\u00f5es, podem mandar mensagens, escrever nos coment\u00e1rios\u2026<\/p>\n<p><strong>At\u00e9 breve! #gogogo<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Bora pra mais um assunto do meu dia a dia, apesar de &#8220;simples&#8221; para alguns, por\u00e9m ainda d\u00e1 trabalho e dor de cabe\u00e7a para muitos, rsrs.<\/p>\n<p>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 para este prop\u00f3sito. Neste Lab vamos usar uma conta do Gmail.<\/p>\n<p>Nosso primeiro passo ser\u00e1 configurar o Database mail no Microsoft SQL Server Management Studio.<\/p>\n<p>E no final vamos configurar um Job de Backup que ao falhar, receberemos um alerta do e-mail reportando a falha.<\/p>\n","protected":false},"author":1,"featured_media":784,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"spay_email":""},"categories":[35,25],"tags":[38,36,37,20,39,16],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/database_mail.jpg.png?fit=872%2C489&ssl=1","jetpack-related-posts":[{"id":1406,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte1\/","url_meta":{"origin":692,"position":0},"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":692,"position":1},"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":792,"url":"https:\/\/ederlelis.com.br\/blog\/falha-envio-database-mail-tls-1-2-netframework-smtp-microsoft-365\/","url_meta":{"origin":692,"position":2},"title":"Falha envio Database-mail TLS 1.2 \/ .NETFramework SMTP Microsoft 365.","date":"outubro 14, 2022","format":false,"excerpt":"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. Ap\u00f3s a atualiza\u00e7\u00e3o da Microsoft (transi\u00e7\u00e3o para o TLS 1.2), o\u2026","rel":"","context":"Em &quot;Database mail&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/10\/database_mail_parte2.png?fit=872%2C489&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":692,"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":538,"url":"https:\/\/ederlelis.com.br\/blog\/automatizar_backups_armazenando_em_blob_no_azure\/","url_meta":{"origin":692,"position":4},"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":[]},{"id":1580,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-de-banco-de-dados-on-premise-para-azure-sql-parte3\/","url_meta":{"origin":692,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/692"}],"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=692"}],"version-history":[{"count":40,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/692\/revisions"}],"predecessor-version":[{"id":870,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/692\/revisions\/870"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media\/784"}],"wp:attachment":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media?parent=692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/categories?post=692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/tags?post=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}