Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.

Infrastructure: This has been run and tested successfully on SQL 2005 and onward.

Scenario: Many DBAs create their own lab at home for learning and r&d purpose. lets say you also wanna do like this and wanna setup database mail for the SQL server to get-notification on some alerts on your home PC or laptop using your gmail or other mail service provider.

Resolution:

It is exactly similar to what you use to configure @ your client environments, the only difference is that you first need to know the SMTP server name and port no while setting up at your home PC or lapsql for respective provider like gmail, hotmail etc.

If you are not familiar with the database mail configure  please click here.

So I will explain and provide SMTP and port details which need to put while setting up DB mail on your personal PC

• Rest of setting you already know or can easily get from google on bit searching.
• On account setting, in Outgoing mail server (SMTP) enter your personal email add like gmail hotmail or rediffmail.
• Google SMTP server name is smtp.gmail.com with port no 587, put this in appropriate text box and use your credentials for the authentication.

Below is the few SMTP server details you can use it as per your need. If I missed something you can again get on google search.

SMTP Server Details
Hotmail        SMTP server name: smtp.live.com                    Port number:   587
Gmail           SMTP server name: smtp.gmail.com                  Port number:   587
Yahoo          SMTP server name: smtp.mail.yahoo.com          Port number :  25
AOL             SMTP server name: smtp.aol.com                    Port number :  587 REDIFFMAIL       SMTP Server name: smtp.rediffmailpro.com     Port number :  587

• So we are done with DB setting, now test the db mail.

Note: You may see authentication errors in DB mail logs even though you put correct password below is the reason and solutions for the same.

Gmail and rest of email service providers now days are more secure and have standard security policy so it may be possible while testing db mail on your IDs you may not receive the email as say for example Gmail security does not allow the less secure app to authenticate your account from less secure app like SSMS, mobile email etc.

So in this case, you will receive email if you are testing on gmail from google about this security breach they will give you Learn More option from where you can Turn ON allow secure app.

This way you will now start getting email from SSMS.

Hope this helps!