Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Mail error

Status
Not open for further replies.

tpluskota

Technical User
Dec 11, 2002
121
GB
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
 
I am having the same problem. Did U resloved this yet....

Tesi
 
Problem fix:
under management in Enterprise Manager
right click SQL Server Agent, go to properties
make sure mail session is pointing to your mail profile.

-Tesi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top