|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 573,
Visits: 1,010
|
|
I work for a university. Recently we've changed mail servers and are now using Office 365 (or at least the Exchange Server part of it), for email. We've got a departmental email which I use for our SQL 2005 Database Mail. We've gotten a notice that in a couple of weeks the SMTP client user and replay server to change, and that I'll have to set up Database Mail to use TLS and a port other than 25. I set up Database Mail some time ago, so I had to hop back into it, to see if I could change that, but it doesn't appear to me as though I can change Database Mail to use TLS. Am I wrong about that? If I am, how do I change it to use TLS?
Kindest Regards,
Rod
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 6,703,
Visits: 11,731
|
|
Rod at work (3/21/2013) I work for a university. Recently we've changed mail servers and are now using Office 365 (or at least the Exchange Server part of it), for email. We've got a departmental email which I use for our SQL 2005 Database Mail. We've gotten a notice that in a couple of weeks the SMTP client user and replay server to change, and that I'll have to set up Database Mail to use TLS and a port other than 25. I set up Database Mail some time ago, so I had to hop back into it, to see if I could change that, but it doesn't appear to me as though I can change Database Mail to use TLS. Am I wrong about that? If I am, how do I change it to use TLS? TLS = SSL. Configure the account to send email using SSL. Chances are the port number number will need to be changed as well.
__________________________________________________________________________________________________ There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Believe you can and you're halfway there. --Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 573,
Visits: 1,010
|
|
| Are you sure? The reason why I ask is because the email I've gotten from the unviersity IT says, Please Note: Unlike the previous email system, <the new mail system> only supports TLS encryption, regardless of the port number used. The deprecated SMTPS/SSL encryption method over port 465 will not be supported. That suggests to me that SSL isn't going to work, unless SMTPS/SSL is something different from SSL.
Kindest Regards,
Rod
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 6,703,
Visits: 11,731
|
|
I have used the SSL feature in Database Mail with success. Have you tried it out?
__________________________________________________________________________________________________ There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Believe you can and you're halfway there. --Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 573,
Visits: 1,010
|
|
No, but I will.
Kindest Regards,
Rod
|
|
|
|