SQL Mail Requirements? 1

[jgoodman00]

According to the help file:
SQL Mail requires a post office connection

Can SQL mail be used with a POP mail account, or does it need to be connected to an exchange server?

If it can be used with POP accounts what needs to be done? I setup a mail profile to use on of our POP accounts & tested it, but it didnt work. I then modified the profile to connnect to an exchange server & it did work. Trouble is, the exchange server is not in the production environment, so I need to work out if we need exchange in production, in order to use this feature...

James Goodman MCP

http://www.angelfire.com/sports/f1pictures

 

[TitleistDBA]

SQL mail will work with a POP account. Our mail system here is Lotus and I have setup SQL mail. I did have to install the outlook client on the SQL server.

http://www.acushnetcompany.com

 

[jgoodman00]

Yup, was about to self-answer my question. It would appear that it is supported, but it doesnt function perfectly. We use Outlook 2002 which seems to cause 'a whole world of hurt'. SQL Agent can send messages perfectly, but if I try to send messages using xp_sendmail they get stuck in the Inbox(!). Microsofts answer to this is to leave the outlook client running. I have, & it still does. Thanks MS...

James Goodman MCP

http://www.angelfire.com/sports/f1pictures

 

[TitleistDBA]

I had the same problem and also had to leave the client running. I was able to set an option for outlook to send mail every 1 minute. That way nothing gets stuck in the inbox.

http://www.acushnetcompany.com

 

[jgoodman00]

I always set that. Strangely, if I actually look in Outlook the message is indeed stuck in Inbox. If I try manually sending & receiving nothing happens. It would appear the only way I can get them to send is to physically open the message & press send. Then it is send with no problems...

James Goodman MCP

http://www.angelfire.com/sports/f1pictures

 

[Corran007]

you may want to try outlook 2k. i dont have any of those issues with it.

 

[sunny456]

Look at this web site

http://www.sqldev.net/xp/xpsmtp.htm.

I have been using this method for over a year and had no problems. It does NOT require MS Outlook, just uses smtp.

Good Luck