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.
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!