mail relay problem out of sql server

When trying to send e-mail out from SQL server I get the following error: Error string: Server response: 550 5.7.1 Unable to relay for email@.domain.com.

I am using XPSMTP, which sends mail without the use of a mapi client.

If I load up outlook on the server I can send mail externally? Why would the exchange server not relay mail out of the stored procedure, but do it for everything else?did you check the SMTP stuff in IIS which is required for SMTP mail to work?|||i do not have access to the IIS server, because I am a contractor at this company

the thing is, i just tested the sql server agent and it sends mail just fine to external addresses

so i know sql server can do it, but i feel like XPSMTP is limited in some way, perhaps the error message is wrong?|||well the sql server agent is likely running on a domain account with an exchange account and that is how sqlmail works.

smtpmail, as I recall (it's been over a year since I did this) requires somes setup and a running smtp service within IIS. this can be a security issue btw. I would refer to the documentation on the web page for xp_smptmail.|||yes the sql server agent is running off a domain account

i'm using XPSMTP a 3rd party .dll. it does not require IIS, in fact it doesnt really require anything

their website has that error message documented but it doesn't make sense, if i can send mail from the SQL Agent I should have no problem relaying mail from the XPSMTP80.dll

i've been trying to set up SQL mail with no success, sql server does not recognize a profile name in the drop down box in enterprise manager

i have outlook 2000 set up and configured and all...

mail error

Iam unable to send out emails since we changed the system
acount name...
when I test the email name I get the following message
'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
session is not running; check the mail profile and or
SQLServerAgent service startup acount in SQLServerAgent
properties dialogue box'
the mail configeration test works ok and restarted
SQLServerAgent.. any ideasgrumy,
When you say you changed the "system account name", what exactly are you
referring to? The MSSQLServer service account name?
I am also not clear on whether your SQLServerAgent service is running or
not. The error message states that it is not running, but you are saying
that SQLServerAgent was restarted successfully. Could you clarify your
questions?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"grumy" <anonymous@.discussions.microsoft.com> wrote in message
news:2f5e01c4289b$d6d1eba0$a301280a@.phx.gbl...
> Iam unable to send out emails since we changed the system
> acount name...
> when I test the email name I get the following message
> 'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
> session is not running; check the mail profile and or
> SQLServerAgent service startup acount in SQLServerAgent
> properties dialogue box'
> the mail configeration test works ok and restarted
> SQLServerAgent.. any ideas

mail error

Iam unable to send out emails since we changed the system
acount name...
when I test the email name I get the following message
'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
session is not running; check the mail profile and or
SQLServerAgent service startup acount in SQLServerAgent
properties dialogue box'
the mail configeration test works ok and restarted
SQLServerAgent.. any ideas
grumy,
When you say you changed the "system account name", what exactly are you
referring to? The MSSQLServer service account name?
I am also not clear on whether your SQLServerAgent service is running or
not. The error message states that it is not running, but you are saying
that SQLServerAgent was restarted successfully. Could you clarify your
questions?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"grumy" <anonymous@.discussions.microsoft.com> wrote in message
news:2f5e01c4289b$d6d1eba0$a301280a@.phx.gbl...
> Iam unable to send out emails since we changed the system
> acount name...
> when I test the email name I get the following message
> 'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
> session is not running; check the mail profile and or
> SQLServerAgent service startup acount in SQLServerAgent
> properties dialogue box'
> the mail configeration test works ok and restarted
> SQLServerAgent.. any ideas

mail error

Iam unable to send out emails since we changed the system
acount name...
when I test the email name I get the following message
'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
session is not running; check the mail profile and or
SQLServerAgent service startup acount in SQLServerAgent
properties dialogue box'
the mail configeration test works ok and restarted
SQLServerAgent.. any ideasgrumy,
When you say you changed the "system account name", what exactly are you
referring to? The MSSQLServer service account name?
I am also not clear on whether your SQLServerAgent service is running or
not. The error message states that it is not running, but you are saying
that SQLServerAgent was restarted successfully. Could you clarify your
questions?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"grumy" <anonymous@.discussions.microsoft.com> wrote in message
news:2f5e01c4289b$d6d1eba0$a301280a@.phx.gbl...
> Iam unable to send out emails since we changed the system
> acount name...
> when I test the email name I get the following message
> 'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
> session is not running; check the mail profile and or
> SQLServerAgent service startup acount in SQLServerAgent
> properties dialogue box'
> the mail configeration test works ok and restarted
> SQLServerAgent.. any ideas