I'm trying to configure SQLAgentMail on a new install, 2K3, and SQL2000 SP3
and Exchange with Outlook 2000SR1. Followed the KB instructions to the lette
r.
SQL mail properties sees the outlook profile, test ok. Sends mail OK. SQL ma
il 100% working. SQLagent mail does not - greyed out when running enterprise
manager from the console. No options selectable for Mail profile in SQLAgen
t properties. They both sta
rt with the same domain account.
From a workstation:
If I connect with Enterprise manager from my workstation I CAN see the profi
le in SQLagent properties window. Using the test button reports that the MAP
I session started and stopped correctly. However if I then select an operato
r and send a test email I g
et: Error22022 The SQLServerAgent mail session is not running; check the mai
l profile and/or the SQLServerAgent service startup account in the SQLserver
Agent Properties dialog.
In the SQL Server Agent/Properties/View Error Log I get: [355] The mail
system failed to initialize; check that a mail client been installed.
Can anyone point me to the nest step? Does this (shows profile from wkstn/no
t from console) indicate I should reinstall enterprise manager at the consol
e? or do I have a deeper issue
and Exchange with Outlook 2000SR1. Followed the KB instructions to the lette
r.
SQL mail properties sees the outlook profile, test ok. Sends mail OK. SQL ma
il 100% working. SQLagent mail does not - greyed out when running enterprise
manager from the console. No options selectable for Mail profile in SQLAgen
t properties. They both sta
rt with the same domain account.
From a workstation:
If I connect with Enterprise manager from my workstation I CAN see the profi
le in SQLagent properties window. Using the test button reports that the MAP
I session started and stopped correctly. However if I then select an operato
r and send a test email I g
et: Error22022 The SQLServerAgent mail session is not running; check the mai
l profile and/or the SQLServerAgent service startup account in the SQLserver
Agent Properties dialog.
In the SQL Server Agent/Properties/View Error Log I get: [355] The mail
system failed to initialize; check that a mail client been installed.
Can anyone point me to the nest step? Does this (shows profile from wkstn/no
t from console) indicate I should reinstall enterprise manager at the consol
e? or do I have a deeper issue