SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

How to setup the Database mail in SQL server 2005

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


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.

SQL Server Blog Forum

My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.


Leave a comment on the original post [www.sqlserverblogforum.com, opens in a new window]

Loading comments...