SQL Mail and Exchange Server

  • :cool:Does anyone know how to configure SQL Server 2000 Mail and Microsoft Outlook Exchange?

    Thanks

  • 1 need install outlook on SQL server

    2- SQL service need run with domain credential

    3- ensure mailbox exist for SQL credential

    4- log into server whith SQL credential

    5- configure exchange profile

    6- restard SQL service

    7- select profile on suport service SQL mail

    and is done.

  • For SQL 2005, you should use Database Mail instead of the legacy SQL Mail

    Look into Books Online for "Database Mail"

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • in future, for sql2000 queries please post in the correct forum area 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • And watch out for that first step, it's a doozy!

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Be careful with SQL Mail, some interesting gotchas with it.

    My favourite is the way that certain Windows patches (usually IE ones) lose the default MAPI handler setting after a reboot.

    If SQL Server is configured to use SQL Mail and it doesn't know what to use to handle MAPI at startup - the SQL Server service doesn't start at all.

    To fix, log on as the account you are running the SQL Service under, then start IE and Outlook. You should be prompted to make Outlook your default MAPI handler. Log off, then restart the server. Service should start.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply