Database mail saying remote certificate invalid

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Database mail saying remote certificate...

Database mail saying remote certificate invalid

Rate Topic

Display Mode

Topic Options

Author

Message

Superdoc

Posted Sunday, October 21, 2012 12:22 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:13 PM
Points: 22, Visits: 591

Hello Everyone,

I have a crushing issue that i have been looking all over the web, a week ago we moved our mail server to office exchange 365, i reconfigured the mail accounts in database mail profile with the new ones and exchange supports only SSL ports, however the servers on internet are able to access that is behind a firewall but i have another server that is behind NAT, i can open the port 587 for that ip through telnet, but sql server 2008r2 database mail is throwing this error message and not sending any.

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-10-21T11:34:42). Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.).
)

I setup a local outlook client to check if mail can be sent and i got a pop up from remote server to verify a certificate, thinking this was the reason i placed it under Enterprise Root, Trusted Publisher but still sql's database is giving the same odd message, i have enabled it for SSL with correct server, username and password... please help. Thank you.

Regards,

Post #1375147

Superdoc

Posted Tuesday, October 23, 2012 7:00 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:13 PM
Points: 22, Visits: 591

any body has come across with this problem?

Post #1376013

Superdoc

Posted Tuesday, October 23, 2012 8:03 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:13 PM
Points: 22, Visits: 591

Hello Everyone!,

I resolved this issue myself.

Whenever the server tried to make contact with exchange it was expecting the remote server to have host name instead of IP, something just barged into my head and i created a Host A record on my server and checked whenever I ping the dns of outlook takes me to the server and it worked!, all i had to do is PUT the exchange 365 smtp dns name and redirect it to the static ip and done, i received the test mail. Thanks.

Post #1376068

« Prev Topic | Next Topic »

Permissions