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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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
2241 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
2241 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
2241 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  
 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