May 7, 2010 at 7:39 am
Okay - I am an independent consultant that uses a hotmail account for my email purposes. I read where in SQL2005 you do not need an outlook/MAPI account to use SQL mail services.
My question is - In my situation, what entry do you use in the Server Name field for the outgoing SMTP server? What entry for port?
Any guidance would be appreciated. I did search this forum and have not found any similar requests.
Thanks.
May 7, 2010 at 8:01 am
Bron Tamulis (5/7/2010)
Okay - I am an independent consultant that uses a hotmail account for my email purposes. I read where in SQL2005 you do not need an outlook/MAPI account to use SQL mail services.My question is - In my situation, what entry do you use in the Server Name field for the outgoing SMTP server? What entry for port?
Any guidance would be appreciated. I did search this forum and have not found any similar requests.
Thanks.
You will enter the mail host name or ip address port is 25. That being said, it's somewhat doubtful that you will be able to get passed the firewall (port 25 is usually going to be blocked). Plus, SQL Server is designed to work with corporate mail servers, not hotmail, you may experience authenticatoin issues if you can connect.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
May 7, 2010 at 11:53 am
That's kind of what I thought.
Thanks for the assistance.
May 7, 2010 at 12:00 pm
Use GMAIL. you will just need to create an account. Their outgoing server requires user authentication so you'll need the account. You can forward to any email address you want to with that account at no cost.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 7, 2010 at 12:08 pm
MeltonDBA (5/7/2010)
Use GMAIL. you will just need to create an account. Their outgoing server requires user authentication so you'll need the account. You can forward to any email address you want to with that account at no cost.
You can still run into a problem with the firewall and/or proxy servers. I believe that gmail has SSL SMTP on port 993 or so, unless there is an outbound hole in the firewall, those messages will never get sent. If there is a hole, then just use smtp.gmail.com.
In most orginazations, the link you included is not even available from behind the firewall, everyone I know has external email blocked at work.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply