How to Configure Database Mail | How to send Email from SQL SERVER | SQL

How to Configure Database Mail | How to send Email from SQL SERVER | SQL
This session will help you understand the following concepts:
1.) What is Database Mail in sql server.
2.) How to configure the Database mail in sql server ?
3.) How to create profile and multiple accounts in database mail in sql server.
4.) How to send test email to Gmail Account from SQL SERVER with practical demo.
5.) Which are those two settings in Gmail Account you need to check before sending mail from SQL SERVER.

=====To Get More useful video's, please follow below links ======

1.) To learn Learn SQL Server Concepts, visit below playlist

2.) To learn SQL Server Clauses and Keywords, please visit below playlist

3.) For SSIS Tutorial, follow below playlist

=======My Favorite Study Materials you can check out =====

Disclaimer : the above links may be amazon affiliate links, which means if you go through it,
I may get some commission but please bear in mind, it won't charge you a single penny
..so if you like the content, keep watching and support my channel.

=========Share, Support and Subscribe =========
Subscribe to my YouTube channel :

Share and like the Facebook Page :

Thank you for Watching
By SQL
By SQL Training Session

[umamaheswar]

thanks for good tip to get mail from sql server.

[akummutagha]

Thanks for this beautiful presentation. The extra changes you made to the gmail account was very helpful, thanks.

[BestInTheWorld]

Appreciate your time & knowledge
Please make a video how to create a SQL job for sending mails from query or stored procedure

[mohammedghouse]

This vidios are the greatest support medam

[Jass_aamu]

Thank you so much ma'am you guide us completely

[himanshubajaj]

Thanks for providing great information :)

[aneesashaik]

Thank you iam crystal clear in this topic by watching this video

[luke]

Thank you for making this video! You are a genius! :)

[ameen]

Thanks for the video, It was really helpful..I have a doubt what all extra changes to configured in outlook if we want to send the mail on outlook

[mytrolls]

Thank you so much for providing great info. I'm requesting to you please make a video how to create job for sending mails from query or stored procedure.

[druvaraja]

thank you so much really, its really very helpful and for outlooks we need to change any setting ? Like gmail

[bgqnkmo]

Thanks for your content. Very informative. But unfortunately, I could not find the "less secure app access" option in my security tab.

[dildokafir]

Great, msg queued up always I get while sending test email from SQL, probably the Gmail security setting would be the reason.. anyway thank you for beautiful tip.. keep coming

[VikasSharma-tmqp]

working fine. but after some time, Less secure app settings are enabled by google.. my question is that without using a less secure app setting how to send mail.

[ravindranathkurmam]

Good explain. But i have doubt, In real time that Gmail settings are done by DBA job or windows or networking team job ?

[hephzibah]

Hii Maam, I could'nt find the "less secure app" in my account. Can u pls help me with dis.

[vickyyagami]

Can we also send an email once backup runs and completed?

[dildokafir]

Can we schedule mail to be send at specific time. .??

[tonyettah]

That was an awesome presentation and thank you for sharing your knowledge with the world. I'm having challenges with mine, I did all the configurations as instructed but still could not receive sql email on my Gmail.

[alpesh]

I need your help, we have live database server & Reporting database server, I need auto backup and restore in reporting server, both server are connect on same network....