problem with xp_sendmail

Hi
I had the xp_sendmail working the other day, but when I now try to send an
email using the xp_sendmail proc, I get the following error message:
xp_sendmail: Procedure expects parameter @.user, which was not supplied.
What does that mean? I can't even see that there's a @.user parameter to set
for the xp_sendmail proc. Is it just me that are missing something here?
Regards
Steen
Hi
You may want to check the mail profiles, by logging in as the service
account and making sure it exists and is working.
John
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:ux9r1XCZEHA.2432@.tk2msftngp13.phx.gbl...
> Hi
> I had the xp_sendmail working the other day, but when I now try to send an
> email using the xp_sendmail proc, I get the following error message:
> xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> What does that mean? I can't even see that there's a @.user parameter to
set
> for the xp_sendmail proc. Is it just me that are missing something here?
> Regards
> Steen
>
|||arghhh...stupid me... The account that runs the SQLServer service needs to
be the one that has the mailbox setup for it to work from TSql. In my case
it was still the local system account on some servers but the SQLServer
Agent service is all set to the mailbox user - that was why it worked when
testing an operator setup but not when running the xp_sendmail.
Steen
"John Bell" <jbellnewsposts@.hotmail.com> skrev i en meddelelse
news:%23ofKcfCZEHA.1152@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi
> You may want to check the mail profiles, by logging in as the service
> account and making sure it exists and is working.
> John
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> news:ux9r1XCZEHA.2432@.tk2msftngp13.phx.gbl...
an
> set
>