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.