cannot execute xp_sendmail

[bhp]

This is what I ran:
exec xp_sendmail 'bob@bob.com','test mesg'

This is what gets returned in query analyser:

Server: Msg 17926, Level 18, State 1, Line 0
Not supported.

I have tested that all the mail services are set up and the right security is applied. And have done a general search on this on the net but to no avail. Is there anyone here who may no the answer??
Thanks - James

P.S. Am running on sql7 environment and have outlook 2003 installed

 

[mutley1]

Are you logged onto the server when you try to run this, or are you running it using query analyser on your machine that is connected to the server?

The mail account should be set up as the domain account running the SQL service, and you will need to be logged in as that domain account otherwise it will take your credentials. E.g. if you have an account called DOMAIN\SQLAdmin running the SQL Service, then the mail account should be set up for that account. I found in a lot of things like DTS that it takes the credentials of your registration if you are working on your machine, not the server.

Basic check as well is in Enterprise manager, is SQL mail running? When you say you have done a test, do you mean from Enterprise manager and sending the test mail?

Try logging on to the server as the domain account that is running SQL (and hopefully has the mail account set up for it) and run the test in QA again)

 

[bhp]

Yes am logged on with the domain account the same one that is used for running sqlserver and sqlagent, and yes sql is running in Enterprise Manager. Yes my test was from Enterprise manager and I also sent a mail using outlook!!!

 

[Catadmin]

Outlook is configured and running on the server? The profile in Outlook is using the Domain User account from SQL?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"