SQL Server Database Mail - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Administration

SQL Server Database Mail

Author

Topic

vicky.srm87
Starting Member

6 Posts

Posted - 2015-04-24 : 01:06:09

Hi all,

I'm getting below error, while sending mail through Database mail (SQL Server 2008 Standard Edition, SP3-64 bit). Can any help me to resolve this.

------------------------------------------------------------
Date :4/24/2015 10:21:36 AM
Log :Database Mail (Database Mail Log)
------------------------------------------------------------
Log ID :63
Process ID :3252
Mail Item ID :20
Last Modified :4/24/2015 10:21:36 AM
Last Modified By :sa
------------------------------------------------------------
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-04-24T10:21:35). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
)
------------------------------------------------------------

I've configured the database mail by below details.

SMTP Server name : smtp.gmail.com
Port number : 465
We have enabled secure connection(SSL)
User name : My gmail id
Password : My gmail password

Regards,

Vignesh R

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-04-24 : 01:14:28

Can you confirm the SMTP server works independant of SQL Server? Is the recipient address valid?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

vicky.srm87
Starting Member

6 Posts

Posted - 2015-04-24 : 01:20:13

Hi jack,

Thank u very much for u r reply.

Yes..,recipient address is valid only. For testing purpose, recipient address also my gamil account only.

Vignesh.

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2015-04-24 : 07:23:29

can you try with port 587

Javeed Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95

vicky.srm87
Starting Member

6 Posts

Posted - 2015-04-25 : 01:14:38

Dear Javeed,

I've tried with 587 still the problem is there, also 587 for TSL right? But our SQL Server require SSL, still can we use 587 port?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-04-25 : 01:39:22

To rule out any SQL Server issues - have you tried to send the email via a powershell script. Do you still get the error message? Use this script from the same server as the database server - http://www.sqlserver-dba.com/2012/01/sql-server-send-email-using-powershell.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

sunder.bugatha
Yak Posting Veteran

66 Posts

Posted - 2015-04-29 : 08:11:22

what about the email address configured to send emails to your email id? Is it configured in the mail server?

Hema Sunder

smiley999
Starting Member

1 Post

Posted - 2015-05-01 : 13:28:50

Port 587 is correct.
I also had to change the gmail security setting:
https://www.google.com/settings/security/lesssecureapps

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources