Solved

Database Mail Remote Certificate Invalid

Posted on 2011-03-18
4
4,321 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
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.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now