SQL Mail error

[Steve Renaker]

I've just set up SQL Mail, and I think it's working -- at any rate, the envelope icon in Enterprise Manager
is green. Problem is, no matter what address I try to mail to, I get an 'Unknown recipient' error.

My input:

xp_sendmail 'srenaker@alexa.com', 'This is a test message.'

The results:

Msg 17914, Level 18, State 1
Unknown recipient: Parameter '@recipients', recipient 'srenaker@alexa.com'

Thanks in advance for any help,

Steve Renaker
srenaker@alexa.com

[Jens Nilsson]

Hello!!

Try to execute the xp_sendmail in MASTER the database
It works for me!

Hope it Works!
/Jens Nilsson
Database Administrator
Sweden

------------
Steve Renaker at 9/7/99 8:23:23 PM

I've just set up SQL Mail, and I think it's working -- at any rate, the envelope icon in Enterprise Manager
is green. Problem is, no matter what address I try to mail to, I get an 'Unknown recipient' error.

My input:

xp_sendmail 'srenaker@alexa.com', 'This is a test message.'

The results:

Msg 17914, Level 18, State 1
Unknown recipient: Parameter '@recipients', recipient 'srenaker@alexa.com'

Thanks in advance for any help,

Steve Renaker
srenaker@alexa.com

[Steve Renaker]

Thanks for the suggestion, but I was already using the Master database. In fact,
that's the only database where xp_sendmail exists (by default, at least).

Steve

------------
Jens Nilsson at 9/8/99 11:24:40 AM

Hello!!

Try to execute the xp_sendmail in MASTER the database
It works for me!

Hope it Works!
/Jens Nilsson
Database Administrator
Sweden

------------
Steve Renaker at 9/7/99 8:23:23 PM

I've just set up SQL Mail, and I think it's working -- at any rate, the envelope icon in Enterprise Manager
is green. Problem is, no matter what address I try to mail to, I get an 'Unknown recipient' error.

My input:

xp_sendmail 'srenaker@alexa.com', 'This is a test message.'

The results:

Msg 17914, Level 18, State 1
Unknown recipient: Parameter '@recipients', recipient 'srenaker@alexa.com'

Thanks in advance for any help,

Steve Renaker
srenaker@alexa.com