How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?
Yes you do. More specifically, you need MS Outlook 2000.
Try this link (http://support.microsoft.com/kb/263556). Bear in mind that SQL Agent Mail and SQL Mail are different, and must be configured separately (though you don't have to configure both).
In general, I HATE SQL Agent Mail. If Outlook hangs or whatever reason, you can potentially hang your entire job scheduling process. It can get real ugly real fast.
Google SMTP solutions for SQL 2000 and you'll find a lot of other options. Best bet, though, is to go with SQL 2005 and use the new database mail feature (which is SMTP based).
Regards,
hmscott
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment