Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sending email from SQL Server Database

Posted on 2015-01-14
5
Medium Priority
?
53 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 36

Accepted Solution

by:
ste5an earned 2000 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
 
LVL 1

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 36

Expert Comment

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

Author Comment

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

Expert Comment

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

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

578 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