April 1, 2009 at 2:23 pm
:cool:Does anyone know how to configure SQL Server 2000 Mail and Microsoft Outlook Exchange?
Thanks
April 1, 2009 at 2:54 pm
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.
April 2, 2009 at 10:32 am
For SQL 2005, you should use Database Mail instead of the legacy SQL Mail
Look into Books Online for "Database Mail"
April 2, 2009 at 4:10 pm
in future, for sql2000 queries please post in the correct forum area 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 4:45 pm
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]
April 2, 2009 at 6:11 pm
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