SQL Mail notification on sql 2000

[jpotucek]

I have a sql server 2000 sp3a box with 4 named instances.

I have read all of the articles and I cannot get the 'send mail' stuff working.

I have a mailbox associated with the Domanin account that starts the sql server and sql server agent services. I installed Outlook and created a mail profile for this account. I bounced the SQL server agent on one of the Instances but when I go into the properties for the Agent, on the General Tab, the option to choose a mail profile is GREYED out. I tried 'xp_startmail' and I get this error: xp_startmail: failed with mail error 0x80040111

can anyone help???????

 

[ptheriault]

This may be of some use to you.

http://support.microsoft.com/kb/q292761/

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[jpotucek]

Thanks.. this article indicated to start the services with a domain account (which I am) and to apply the latest service pack (which I have done)

 

[jpotucek]

What I ended up doing was logging onto the Server running SQL Server with the domain account that starts the services and created my outlook profile while logged in with that account and then restarting the SQL Server Agent.. works now. thank u for your help