?
Solved

Database Mail Remote Certificate Invalid

Posted on 2011-03-18
4
Medium Priority
?
4,829 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 1500 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
In this article I will describe the Copy Database Wizard 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 tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

752 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