SQL Server DBA Tutorial 132-How to configure DBMail in SQL Server

In this video you will learn how to configure DBMail in SQL Server using SQL Server Management studio as well as using T-SQL. It also explains how to configure Google smtp server as dbmail account in SQL Server using SQL Server management studio as well as T-SQL Script. It illustrates the smtp server configuration both for Exchange as well as google, what is the port google smtp server uses as well as port number of Microsoft Exchange Server. Step by step dbmail profile configuration as well as account stepup. It also shows how to delete dbmail profile and account in sql server.

blog post link for this video:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[LaRothe]

I'm with error:The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2016-08-03T11:47:38). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 64.233.190.109:587).
)
How do I solve this?

[prathipraveen]

i cannot find DATABASE MAIL IN SqlServerLog...what can i do

[prawinumar]

Hi Aamir,

Thanks for posting the video i have followed all the steps what you u have advised in video but got error as below

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2015-09-30T22:49:47). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. xu5sm1791459pab.12 - gsmtp).
)

Can u please suggest

[bcakansagarafy]

helloo, i dont have an option of database mail in ssms... how to add??

[noorhirjee]

PL EXPLAIN HOW TO INSTALL SMTP SERVER. THANKS.

[dhruvpatel]

I have followed all of your instructions and still, I am not able to get a test email. I am also trying to use the send email task on SSIS, but I am getting an error. The error is this: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: Unable to connect to the remote server A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.125.195.109:25".
Task failed: Send Mail Task

[banalasiva]

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1003 (2021-03-09T11:12:38). Exception Message: Could not connect to mail server.(smtp server requires a secure connection or the client was not authenticated the server response was 5.7.0 must issue a STARTTLS command first mu6sm1135567pjb.35 -gsmtp)

[manoharchowdarycherukuri]

im getting the error it will not send a mail to gmail.