How to setup the DB mail using Gmail account
In this article I am going to show the database mail setup steps with screen shots. When I tried to test one of my automation procedure in my friend’s laptop I got number of errors.Then I Goggled and found the solution. Here I am going to share my experience.
Database mail is introduced in SQL server 2005 onwards. It is the replacement of the SQLMail with new features.
Step by Step DB Mail setup Screen shot
After click the send test e-mail go and checks your mail box.
While i was testing in SQL server 2005 (9.0.1399) version i got number of errors.
Message: Object reference not set to an instance of an object.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)
HelpLink: NULL
Solution from Microsoft KB-2008286
Basic checks while setup the DBmail.
- Check the ping status
- Check the TELNET status
Error:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-02-05T10:14:08). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it XX.XX.XX.XX:XX). )
If you get the above error check the Telnet status for the particular port. The firewall is opened then it will success. Otherwise check the firewall.
11 Comments
Anonymous
Muthukkumaran Kaliyamoorthy,
I am getting error while doing the same setup (Gmail account)
Muthukkumaran Kaliyamoorthy
@Anonymous,
Can you post me the error.
(or) mail me muthukumark1986@gmail.com
Muthukkumaran Kaliyamoorthy
Thanks for the mail @P_rob1973.
I forget to change the profile name test to DBA.
Anonymous
Basic checks while setup the DBmail.
This post saved my time.Thanks.
by,
sri
Pingback:
Indian
I was just searching for this details for some time. After 6 several hours of constant Googleing, finally I obtained it inside your internet site.
krishna
Hi Muthukkumaran,
when i tried to use telnet for checking port open..i’m getting error message as “‘telnet’ is not recognized as an internal or external command,
operable program or batch file.”
and Here is the Command
C:\Users\kvXXXXX>telnet ohms03.XXXXXXX.com 25
Muthukkumaran kaliyamoorthy
Hi Krishna,
Please check http://www.question-defense.com/2010/07/23/windows-7-telnet-is-not-recognized-as-an-internal-or-external-command
Also look the post and run the same.
anoop pandey
i did as per article but still getting below error
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2013-09-19T11:50:46). Exception Message: Could not connect to mail server. (No such host is known). )
Muthukkumaran kaliyamoorthy
@Anoop, Have checked the telnet status? Is it success? Test and revert.
Pingback: