xp_sendmail at SQL Server 2000

[susan]

Hi,

I have database at Microsoft SQL Server 2000, and I successed to set SQL MAIL profile.

But when I run this query :

EXEC xp_sendmail 'susan',
@subject = 'Test'

Then this result appeared :

Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80040111

I don't know why this result can't run success. I hope somebody want to tell me how to solve this problem.

Thanks

[bnt]

Hi Susan.

Try fully qualifying the procedure name as in 'master.dbo.xp_sendmail', also, be sure the account executing the sendmail has been granted permission to execute extended stored procedures. Hope this helps.

bnt

[bcollins]

Hi Susan,

It sounds like the MSSQL Service is running under the local account, rather than a domain account.

[RandyPa]

Hi,
There are so many things to do in order to get SQL Mail running -
At this point, ensure that you can open your mail client and send mail when logged onto the server desktop with the Domain ID that SQL Server is running under.
This should be the same ID that you used to create the mail profile.

BTW, you shouldn't mix positional parameters with named parameters when you call stored procedures.