SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Unable to Send Mails through Database Mail
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

daipayan
Posting Yak Master

India
181 Posts

Posted - 04/04/2013 :  03:27:12  Show Profile  Visit daipayan's Homepage  Send daipayan a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
2218 Posts

Posted - 04/04/2013 :  05:14:12  Show Profile  Reply with Quote
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

India
181 Posts

Posted - 04/04/2013 :  06:07:34  Show Profile  Visit daipayan's Homepage  Send daipayan a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
2218 Posts

Posted - 04/04/2013 :  06:39:39  Show Profile  Reply with Quote
Do your company has given permission to access external mails?
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2218 Posts

Posted - 04/04/2013 :  06:45:25  Show Profile  Reply with Quote
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

Edited by - bandi on 04/04/2013 06:49:27
Go to Top of Page

daipayan
Posting Yak Master

India
181 Posts

Posted - 04/05/2013 :  01:33:02  Show Profile  Visit daipayan's Homepage  Send daipayan a Yahoo! Message  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000