Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    1

    Angry Unanswered: Configuring SQLServerAgent 2000 mail session

    How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by just4me4
    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. 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
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •