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
Go to Top of Page

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
Go to Top of Page

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?
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -