Unable to Send Mails through Database Mail

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Unable to Send Mails through Database Mail

Author

Topic

daipayan
Posting Yak Master

181 Posts

Posted - 2013-04-04 : 03:27:12

Hello All,

We are having MS SQL 2005 in our server and our organization mainiting Two types of E-Mail - Internal & External.

Internal Emails are used to communicate within the employees of our organization only.
External Emails: We are using Google Mails for communicating with external mail servers.

Now, I had configured MS SQL Database Mail with one Internal E-Mail ID and it's working fine.

But, now when am trying to configure the MS SQL Database Mail with one external E-Mail ID, it's not working and am getting following error every time:

Date		4/4/2013 12:35:41 PM
Log		Database Mail (Database Mail Log)

Log ID		13738
Process ID		7040
Mail Item ID		145765
Last Modified		4/4/2013 12:35:41 PM
Last Modified By		sa

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 13 (2013-04-04T12:35:41). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)

The External Email configuration as follows in below screenshot:

I had tried every possibilities for the configuration, still am unable to resolve the problem.

Please help me.

Regards,
Daipayan
Software Analyst

Application has reported a 'Not My Fault' in module KRNL.EXE in line 0200:103F

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-04-04 : 05:14:12

May be the cause is:
Email address: Your Gmail ID
Display name: Your name
Reply e-mail: Any reply-to email account
Server name: smtp.gmail.com
Port number: 587

Refer this link: http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx

daipayan
Posting Yak Master

181 Posts

Posted - 2013-04-04 : 06:07:34

Dear Bandi,

I tried with both 587 and 465 port.

Even keeping and not keeping the SSL checkbox.

But every options failing.

Please suggest me some way to track the exact problem.

quote:
Originally posted by bandi

May be the cause is:
Email address: Your Gmail ID
Display name: Your name
Reply e-mail: Any reply-to email account
Server name: smtp.gmail.com
Port number: 587

Refer this link: http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx

Regards,
Daipayan
Software Analyst

Application has reported a 'Not My Fault' in module KRNL.EXE in line 0200:103F

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-04-04 : 06:39:39

Do your company has given permission to access external mails?

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-04-04 : 06:45:25

check the following link... That error will occur in the case of wrong port number
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/setting-up-sql-server-database
http://www.sqlservercentral.com/Forums/Topic545821-146-1.aspx

My company doesn't allow external mails... So i can't check out

daipayan
Posting Yak Master

181 Posts

Posted - 2013-04-05 : 01:33:02

Yes, I have the permission to access external mail, but still no success..

quote:
Originally posted by bandi

check the following link... That error will occur in the case of wrong port number
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/setting-up-sql-server-database
http://www.sqlservercentral.com/Forums/Topic545821-146-1.aspx

My company doesn't allow external mails... So i can't check out

Regards,
Daipayan
Software Analyst

Application has reported a 'Not My Fault' in module KRNL.EXE in line 0200:103F

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources