Re: Tracking Package Execution Status

"(And I must have done something a little while ago about setting up an
MAPI client like Outlook.) Now, when I go to Enterprise Manager, under
Support Services/SQL MAIL,
I have a MAPI profile and test to success. However, however, however,
when I attempted to run some sql extended procs for mail function like
xp_startmail, xp_sendmail, xp_stopmail I ran into errors, err msgs
include "failed with mail error 0x80004005". Searching for this err
msg has not generated interesting enough info. "

Are you logging in as the account under which the SQL Server service is
running? Be sure that you have a mail profile set up for that account,
and that profile is the one being used in SQL Mail.

.

Relevant Pages

  • Re: SQL Mail doesnt work. Please HELP!
    ... You have to set the sql services to run under an account other then "system" ... One thing to note mapi does not work well on systems with more ... the profile seems to randomly have strange behavior. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server agent email profile greyed out
    ... >log into the server with the NT account for SQL, ... Once its done you can see the profile ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server agent email profile greyed out
    ... log into the server with the NT account for SQL, open the Mail profile in ... with that account. ... Once its done you can see the profile in SQL. ...
    (microsoft.public.sqlserver.server)
  • Operator problem error 22022
    ... I have created a profile called sqlservice, ... the mail profile for this account works. ... Sql mail has the same profile and works (i tried an xp_sendmail and thats ...
    (microsoft.public.sqlserver.setup)
  • Operator error error:22022
    ... I have created a profile called sqlservice, ... the mail profile for this account works. ... Sql mail has the same profile and works (i tried an xp_sendmail and thats ...
    (microsoft.public.sqlserver.server)