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

x
?
Solved

DB Mail Authentication Error: Certificate Invalid

Posted on 2008-06-24
3
Medium Priority
?
1,814 Views
Last Modified: 2012-06-21
Hello Experts:

I have been trying to set up DB Mail on SQL Server 2005 (Developer) for about 3 weeks. My company has granted me an account we use for DB Administration. I have send as permissions, and it has passed all SMPT authentication testing. The company has confirmed the SMTP server address that I am using.

I am receiving the following error message when testing DB Mail with this account.

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 . Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.). )
 
I have added my account and the mail group per troubleshooting instructions. I am an administrator of both the server and SQL Server 2005. HELP!
0
Comment
Question by:savetheday
  • 2
3 Comments
 
LVL 7

Expert Comment

by:60MXG
ID: 21858233
0
 

Author Comment

by:savetheday
ID: 21858774
OK thanks This is a bit of a different error.
0
 

Accepted Solution

by:
savetheday earned 0 total points
ID: 21934191
I changed this to Basic Authentication to get it working - was the option that worked!
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

572 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