Have you been through the following...
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;263556
&
http://support.microsoft.com/default.aspx?scid=kb;en-
us;315886
Peter
"Do not awake the sleeping dragon for you are crunchy and
taste good with ketchup".
Peter The Spate
>--Original Message--
>I have set up an operator under the SQL Server Agent,
added an email address
>and click Test, and I get the following error message:
>Error 22022: SQLServerAgent Error: The SQLServerAgent
mail session is not
>running; check the mail profile and/or the SQLServerAgent
service startup
>account int the SQLServerAgent Properties dialog.
>Now, This machine has outlook installed and under Support
Services -> SQL
>Mail -> Properties, the profile name (Outlook) is
selected and I can Test it
>(Successfully started (and stopped) a MAPI session with
this profile.)
>Under the SQL Server Agent settings I have the profile
set there (Outlook)
>and I can successfully test it (Successfully started (and
stopped) a mail
>session with this profile)
>Both the SQL Server and SQL Server Agent are run under
the same domain
>account. I can log on with this account and open Outlook
and send and
>recieve email messages with no problems. I can also use
xp_sendmail in
>Query Analyzer to send email messages as well.
>I have searched extensively through google and have yet
to find any settings
>that I am missing, however, I am unable to recieve alerts
to my operators,
>I'm not even able to get the test message to work. Does
anyone have any
>ideas as to what could be causing this problem.
>Thanks for the help,
>Matt
>
>.
>
> Have you been through the following...
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;263556
> &
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;315886
> Peter
Yes, I have been through both, but neither cover the problem I am having.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment