Solved

Database Mail Remote Certificate Invalid

Posted on 2011-03-18
4
4,694 Views
Last Modified: 2012-05-11
I am trying to send mail from SQL Server 2008 R2 using Database Mail.  I have configured a public profile making sure that the user account has the databasemailuserrole role.  I set up an smtp account using  a webmail account set up for this purpose and made sure it was receiving and sending mail outsiide of SQL.  I checked the SSL requirement.
The mail gets queued when I sent it but I never receive the sent mail.  I always get this error "...... Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.
I am tearing my eyeballs out right now having searched high low for what could be the problem.  Is there a savior out there?
0
Comment
Question by:ashokunbi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 35170331
Not exactly the same error, but I had a similar problem recently.  Unfortunately, the only 'fix' I found was to enable the sql server service account within Exchange, as an actual account.  That was also the account that was used in my database mail account and profile.

These people had the same error you're having, and they say the same thing -- make sure your service account can authenticate to exchange without problems:
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/6efd99f4-c41c-417d-9d46-5cd741b8e077/
0
 

Author Comment

by:ashokunbi
ID: 35171518
I don't use Exchange.  I use webmail.
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 35172963
0
 

Author Closing Comment

by:ashokunbi
ID: 35182303
It wasn't the actual solution but it pointed me in the right direction to solve the issue on my own.
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

688 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