Re: xp_sendmail works from QA but not from DTS package

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steen Persson (SPE_at_REMOVEdatea.dk)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 08:57:14 +0200

Do you use the same account for running both your SQLServer service and your
SQLAgent service? If not, then try to set SQLserver to use the same account
as SQLAgent - the one that has the mailbox set up.
I have had similar issues where it was solved by having the SQLserver
running on the same account as SQLagent rather than the local system.

Regards
Steen

Colleen Rossman wrote:
> The 'error' message is 'successfully executed step' but I never get
> the e-mail. Yes, we setup a MAPI profile for SQLAgent Account and it
> successfully stops and starts a mail session using that account. It
> works on all our other servers. I've had this problem at other
> companies too, and have never figured it out.
>
>
> "Rick Sawtell" wrote:
>
>> What error message are you getting back?
>>
>> Did you create an email profile for whatever account the DTS package
>> is running under?
>>
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
>>
>> "Colleen Rossman" <crossman@discussions.microsoft.com> wrote in
>> message news:646B361E-002D-4958-A5C2-16FCC3ACDD78@microsoft.com...
>>> I copy and paste from QA to DTS so I know it's not a typo. I ran
>>> xp_stopmail and xp_startmail and still no l luck. We bounced the
>>> SQL Agent too but it's still not working. SQL mail is working
>>> though.
>>>
>>> Please help!

Relevant Pages

  • Re: Error 53: Cannot generate SSPI Context
    ... need to try to connect to sqlagent using sa account and password. ... I will then suggest re-booting the server. ... I vaguely remember it being something to do with the sqlagent service ... > error in the agent out file. ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Agent wont start
    ... Both SQLServer and SQLAgent are now run under the Local System ... Windows Admin account which was used to start these services. ... Interestingly, when a sysadmin account ...
    (microsoft.public.sqlserver.server)
  • Re: Sql Server is not backing up as scheduled
    ... > Ensure that Service startup account for SQLAgent should be same as MSSQL ... >> It sounds like it's probably a permissions issue. ... >> However, when I am scheduling it for one time backup, it ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Agent wont start
    ... SQLServer and SQLAgent run, I had to change these services to start using ... Local System Account. ... SQLAgent but I suspect some more "fiddling" was done last week with Windows ... "Griff" wrote: ...
    (microsoft.public.sqlserver.server)
  • Re: xp_sendmail works from QA but not from DTS package
    ... "Steen Persson" wrote: ... then try to set SQLserver to use the same account ... > as SQLAgent - the one that has the mailbox set up. ... > running on the same account as SQLagent rather than the local system. ...
    (microsoft.public.sqlserver.server)