How to Setup Database Mail in SQL server || Ms SQL

Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine or Azure SQL Managed Instance.
Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on your network.
Benefits of Using a Database Mail :
docs.microsoft...
#DatabaseMail

[@Funnykidszone2024]

Nice brother you explained clearly and simple

[@RahulSharma-vi3cs]

Great job , thanks for helping all the new beginners

[@pavankalyananingi2913]

Thanks!

[@dukejian]

Great job!! Thanks.

[@rahulsaini-ly4sq]

Sir your videos is very helpful, Please upload all script on drive which you have used in video. Thanks ❤🙏 sir

[@abba9510]

I am getting this error The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2022-03-25T14:51:55). 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 Authentication Required. Learn more at). )

[@n.aentertainments3668]

Good explanation

[@WorldInnovationn]

"To help keep your account secure, from May 30, 2022, ​​Google no longer supports the use of third-party apps or devices which ask you to sign in to your Google Account using only your username and password." this is the new google update. In that case how can i enable "Less secure apps"? Or do you have any solution for gmail configuration? Im Using MS SQL 2017. Thank you

[@SBhaskarG]

when tried i got this Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2023-04-21T05:36:27). 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 Authentication Required. Learn more at). )

[@venkateswarlureddy8602]

Clear explanation

[@tusharkaushik79]

Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-05-11T16:20:45). Exception Message: Could not connect to mail server. (No such host is known).

[@ErickNishimoto]

Thanks!!! 👍

[@ezrasastrykakumani5466]

Hi Sir, i am getting the following error for my gmail account The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 ( ). 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.5.1 Authentication Required. Learn more at).)

[@naveenm9272]

I know where the error and solution

[@naveenm9272]

You can change Google mail id setting s there are two settings in your Gmail account

[@fantooshh]

Sir I tried this with outlook and I got this error msg: "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2021-12-20T12:58:47). Exception Message: Could not connect to mail server. (This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server)" I tried googling the solution but not getting relevant solution. Can you help plz...

[@righttolearnbk]

Check the SMTP port number. It varies from service provider or else try using Gmail

[@fantooshh]

@@righttolearnbk thanks for the reply sir, we do that

[@Amitmishra-ri1tv]

Sir, please make video on performance tuning

[@righttolearnbk]

Sure, I will do.

[@tableaututorialstips71]

Database Mail XPs' this one not enabled after running those commands

[@righttolearnbk]

sp_configure 'show advanced options', 1; RECONFIGURE; sp_configure 'Database Mail XPs', 1; RECONFIGURE After you run above script did you any error?

[@tableaututorialstips71]

@@righttolearnbk no erro ,but when I ran command I see that is enabled but it is not in display under that "SQL Servel Logs" Folder

[@Aurobinda-vv7rz]

I am also getting the same issue as mentioned by you

[@imransdin]

still not configure mail setup after execute sp_configure 'show advance options' go reconfigure go sp_configure 'Database Mail XPs',1 go Reconfigure go

[@pulusumunikiran7253]

Sir please explain db backup mail configuration

[@righttolearnbk]

Please watch this video kzbin.info/www/bejne/bJnMf6acp8aoedU

[@kakarlanagajyothi4089]

The mail can not be send for the recipient

[@Iqra_theislamiclearning]

After Setup Also not receiving mail

[@righttolearnbk]

Are you using a gmail account ?? If yes, then additional privacy settings should altered in your gmail account

[@leelakrishna888]

@@righttolearnbk how the SQL queries automated and sent to the email on daily basis..can you please help .

[@adityapandey7946]

@@righttolearnbk What are the addition privacy settings for gmail? Enabled SSL Authentication while configuring dbmail, Allowed Less Secure Apps in Gmail Security Settings, Even tried with 2Factor Authentication. But Still not able to receive mail... Please give us a solution.

[@imransdin]

still not showing mail service

[@tuminhh7617]

share code pls