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.
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....
When you get the message 'invalid type' when yrying yo send an .xslx file from a directory to which you have access, but otherwise the test email works, how do you fix that? Anybody know?
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.
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.
I am not able to send mail using sql 2019. But I followed same process on sql 2012 and mail works fine. Microsoft has has not tested this tool properly. Configure app password in gmail and use same app password when configuring send mail account-- do not use original password or it will fail. I have not tested this process in SQL 2014, 2016, 2017.
Hi, Very much impressed with your session, It is very clear Could you please do a session on sending SQL DB health check report as mail notification in scheduled intervals
ma'am could be create video for the same for oracle 12c. i have my machine i installed the oracle 12c i need to mail configuration on the same. please help me....................
"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
Hi, i am impressed your video. but i will do the same process. but i received any db mail in my gmail, i am asking db mail app installed my laptop are not?
Hi Mam I want SQL report automated generated through excel file to manager How I write my Stored Procedure and get result to excel and automatice mail to my mangers .
Hi, I am getting this error even after changing gmail settings... 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). )
Hi, I made the configuration but im getting error " The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 " how to resolve it.
One thing that I noticed that was weird was that after I went in to 'Manage Existing Account' for Database Mail that the account password only showed 5 stars for my password despite it being longer. I wonder if that's normal. I can't get the mail service in Sql to send the test email. I'll keep trying and update you here if I can get it to work.
Update: Ok! I got this to work. For this to work with Gmail you have to go to the 2-step Verification settings on your Google Account and set an App Password. You use this in the SQL email settings in place of your gmail account password and it works.
To enable sql server agent service, all you need to do is to open the sql server configuration manager, select "SQL Services". Once you select "sql services" option, you will get all sql services. select sql server agent service, right click on it and select enable option. this is enable your sql server agent services.
Thanks for your content. Very informative. But unfortunately, I could not find the "less secure app access" option in my security tab.
Appreciate your time & knowledge
Please make a video how to create a SQL job for sending mails from query or stored procedure
Thanks for this beautiful presentation. The extra changes you made to the gmail account was very helpful, thanks.
Thanks! Simple and effective.
Glad it was helpful!
thanks for good tip to get mail from sql server.
Thank you iam crystal clear in this topic by watching this video
Glad that it is useful
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.
Glad to know that it is useful
Thanks for providing great information :)
Thanks for your lovely comments
This vidios are the greatest support medam
Thank you so much ma'am you guide us completely
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
Thanks I needed this only
thank you so much really , its really very helpful and for outlooks we need to change any setting ? Like gmail
It's help to me ,tnq
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....
When you get the message 'invalid type' when yrying yo send an .xslx file from a directory to which you have access, but otherwise the test email works, how do you fix that? Anybody know?
helps a lot, thanks!
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.
What error you are getting?
Thank you for making this video! You are a genius! :)
You're very welcome!
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.
I am not able to send mail using sql 2019.
But I followed same process on sql 2012 and mail works fine.
Microsoft has has not tested this tool properly.
Configure app password in gmail and use same app password when configuring send mail account-- do not use original password or it will fail.
I have not tested this process in SQL 2014, 2016, 2017.
Good explain. But i have doubt, In real time that Gmail settings are done by DBA job or windows or networking team job ?
Hi,
Very much impressed with your session, It is very clear
Could you please do a session on sending SQL DB health check report as mail notification in scheduled intervals
Thanks for you comment @Arun. My schedule is getting tight nowdays but I will definitely make vedio of your ask once I got little bandwidth
Thank you somuch
Hii Maam, I could'nt find the "less secure app" in my account. Can u pls help me with dis.
This option is no longer avaliable in gmail security.
In SQL server Logs I don't have the option "Database Mail". please suggest what I have to do to get the option?
The db mail feature is not available.would u like to enable this feature.i have enabled ,but it is not working mam.is it work or not?
Medam
Sorry to say
When I try every step I do not get any mail to my Gmail account.
Pls advise
ma'am could be create video for the same for oracle 12c. i have my machine i installed the oracle 12c i need to mail configuration on the same. please help me....................
@kamalkPatil : Hi. I Would like to create videos for oracle , but sorry i do not have knowledge on Oracle.
@@LearnWithMRajput no issues ma'am thanks for your response........
Thankzz it helps
Most welcome
@@LearnWithMRajput any video about already created backup have mail alert linking
Thank you
Thanks didi
"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
After May 30, 2022' Less secure app access' is no longer available in Gmail. any thought how to bypass this issues ?,
thanks
Maybe you can show us configure database mail sql server with an outlook 365 account. Thanks. Is this works with SSRS too?
I have a similar question. Were you able to configure an Outlook 365 account? If so, can you explain how to do it?
Hi,
i am impressed your video. but i will do the same process. but i received any db mail in my gmail, i am asking db mail app installed my laptop are not?
Not able to see the option for allowing less security app
How to configure schedule mail..
Mam isse website mein koi database mein query enter kerti hu to uska bhi mail aa jayega kya
How to add Database Mail Under the sql server logs,please explain by using any video.Thanks.
Hi Mam I want SQL report automated generated through excel file to manager How I write my Stored Procedure and get result to excel and automatice mail to my mangers .
Hi,
I am getting this error even after changing gmail settings...
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). )
How can view existing email setting?
Топ! Просто, внятно и понятно. Спс.
Hi, I made the configuration but im getting error " The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 "
how to resolve it.
An important step was not mentioned. SQL Server Agent needs to have Mail system and Mail profile selected under Alert System
Can we also send an email once backup runs and completed?
*Does this tool require smtp.?*
One thing that I noticed that was weird was that after I went in to 'Manage Existing Account' for Database Mail that the account password only showed 5 stars for my password despite it being longer. I wonder if that's normal. I can't get the mail service in Sql to send the test email. I'll keep trying and update you here if I can get it to work.
Update: Ok! I got this to work. For this to work with Gmail you have to go to the 2-step Verification settings on your Google Account and set an App Password. You use this in the SQL email settings in place of your gmail account password and it works.
@@luke2042gracias, estaba teniendo problemas y justo con eso lo pude solucionar
Thanks. This worked for me❤
But how can I send mail without the send test email option...?
Please post how to enable sql server Agent
To enable sql server agent service, all you need to do is to open the sql server configuration manager, select "SQL Services". Once you select "sql services" option, you will get all sql services. select sql server agent service, right click on it and select enable option. this is enable your sql server agent services.
Just want to know how can we use it in SQL procedures
Have you got any idea to do so
Gmail changed so you can no longer turn on "Allow Less secure apps" as of May 30, 2022.
i didnt get any database mail in management
The mail can not be send to the sender.
it is showing in red mark