SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database mail saying remote certificate invalid


Database mail saying remote certificate invalid

Author
Message
Superdoc
Superdoc
Old Hand
Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)

Group: General Forum Members
Points: 358 Visits: 814
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,
Superdoc
Superdoc
Old Hand
Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)

Group: General Forum Members
Points: 358 Visits: 814
any body has come across with this problem?
Superdoc
Superdoc
Old Hand
Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)

Group: General Forum Members
Points: 358 Visits: 814
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.
le_billy
le_billy
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 237
Hello,
I am having the same issue, can you please detail steps by steps in what you do to get it working. I am very new at this.
Superdoc
Superdoc
Old Hand
Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)

Group: General Forum Members
Points: 358 Visits: 814
I have described the workaround in the second post in the same thread, the cloud exchange does a reverse lookup which is why you have to put the IP address following the dns of your office 365 smtp in the hosts file, i don't work with that company where they used office 365 so i can't exactly remember every steps but i hope i can still help you.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search