• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5452
  • Last Modified:

Database Mail Remote Certificate Invalid

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
ashokunbi
Asked:
ashokunbi
  • 2
  • 2
1 Solution
 
dbaSQLCommented:
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
 
ashokunbiAuthor Commented:
I don't use Exchange.  I use webmail.
0
 
ashokunbiAuthor Commented:
It wasn't the actual solution but it pointed me in the right direction to solve the issue on my own.
0

Featured Post

[Webinar] 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.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now