Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5722
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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