Solved

Sending email from SQL Server Database

Posted on 2015-01-14
5
23 Views
Last Modified: 2015-04-30
We are having problems sending mail from SQL Server Database Mail.
 
The error written in the SQL log is:
 
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-01-14T11:06:06). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.1 Client was not authenticated)."

Could I set up a relay to make this work? If so how?
0
Comment
Question by:JayHine
  • 3
  • 2
5 Comments
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 40548896
Generally speaking: Yes. But without knowing the cause of your problem: No.

Your error code points to Exchange as MTA. Thus check what kind of authentication it needs and what you have setup in SQL Server. Check your account configuration:

Account Settings
0
 

Author Comment

by:JayHine
ID: 40553158
Hi,

Thank you for your reply!

Unfortunately it is still not working

Getting the error below.

Error,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-01-16T10:04:34). Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.).
0
 
LVL 33

Expert Comment

by:ste5an
ID: 40553339
Ask your Exchange admin for help.
0
 

Author Comment

by:JayHine
ID: 40593194
still not solved
0
 
LVL 33

Expert Comment

by:ste5an
ID: 40593254
Yup, we cannot do much about a invalid certificate used in your environment..
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question