{"id":573,"date":"2020-03-04T22:19:04","date_gmt":"2020-03-04T21:19:04","guid":{"rendered":"http:\/\/www.maisse-sebastien.fr\/?p=573"},"modified":"2020-03-04T22:20:28","modified_gmt":"2020-03-04T21:20:28","slug":"database-mail-nenvoi-rien-database-mail-not-sending","status":"publish","type":"post","link":"https:\/\/www.maisse-sebastien.fr\/index.php\/database-mail-nenvoi-rien-database-mail-not-sending\/","title":{"rendered":"Database Mail n’envoi rien \/ Database Mail not sending"},"content":{"rendered":"\n

Au boulot, j’ai rencontr\u00e9 un probl\u00e8me d’envoi d’e-mail depuis un serveur Microsoft SQL<\/strong>. Alors m\u00eame que la configuration \u00e9tait, visiblement, correct. L’envoi d’un e-mail ne fonctionne pas.<\/p>\n\n\n\n

Apr\u00e8s quelques recherches, il s’av\u00e8re que le programme DatabaseMail.exe<\/strong> a besoin du .NET Framework 3.5<\/strong>. Sachant que le .NET Framework 3.5 n’est pas un pr\u00e9-requis sur la version 2016 du SQL Serveur<\/a>.<\/p>\n\n\n\n

Pour corriger le probl\u00e8me, on peut r\u00e9aliser l’installation de la fonctionnalit\u00e9 pour r\u00e9soudre le probl\u00e8me :<\/p>\n\n\n\n

\"\"
Installation fonctionnalit\u00e9 .NET Framework 3.5<\/figcaption><\/figure>\n\n\n\n

Si vous aviez des e-mails non envoyer (unsent) dans Database Mail d\u00e8s que le framework est installer, les e-mails vont \u00eatre envoyer.<\/p>\n\n\n\n

Pour voir le journal :<\/p>\n\n\n\n

\"\"
Voir le journal de Database Mail<\/figcaption><\/figure>\n\n\n\n
\"\"
Le contenu du journal<\/figcaption><\/figure>\n\n\n\n

Au besoin, on peut \u00e9galement utiliser la requ\u00eate <\/strong>SQL suivante :<\/p>\n\n\n\n

USE msdb SELECT sent_status, * FROM sysmail_allitems<\/code><\/pre>\n\n\n\n
Cette requ\u00eate affiche tous les e-mails (envoy\u00e9, non envoy\u00e9, en erreur).<\/p>\n\n\n\n
On peut \u00e9galement utiliser une requ\u00eate pour supprimer les e-mails en attente d’envoi.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Au boulot, j’ai rencontr\u00e9 un probl\u00e8me d’envoi d’e-mail depuis un serveur Microsoft SQL. Alors m\u00eame que la configuration \u00e9tait, visiblement, correct. L’envoi d’un e-mail ne fonctionne pas. Apr\u00e8s quelques recherches, il s’av\u00e8re que le programme DatabaseMail.exe a besoin du .NET … Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"two_page_speed":[],"footnotes":""},"categories":[3],"tags":[262,263,267,271,270,268,269,265,266,264],"class_list":["post-573","post","type-post","status-publish","format-standard","hentry","category-informatique","tag-database-mail","tag-e-mail","tag-envoi","tag-requete","tag-send-mail","tag-serveur-mail","tag-smtp","tag-sql","tag-sql-server","tag-sql-serveur"],"_links":{"self":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/comments?post=573"}],"version-history":[{"count":2,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/573\/revisions"}],"predecessor-version":[{"id":578,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/posts\/573\/revisions\/578"}],"wp:attachment":[{"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/media?parent=573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/categories?post=573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.maisse-sebastien.fr\/index.php\/wp-json\/wp\/v2\/tags?post=573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}