SQL server 7 agent mail / SQL mail setup questions

SQL server 7 agent mail / SQL mail setup questions

Post by Paul » Sun, 04 Feb 2001 15:26:55

Hi folks.

Does anyone have knowledge or experience (or even success) with setup
of sql agent mail or sql mail?

 I'm running NT 4.0 server (sp6) with SQL server 7 (sp1) .

Microsoft says you have to create an NT account plus a mail profile
(with the same name) along with starting/running the SQL server
service and QL agent under this account.  From within the agent
properties,  you identify the profile you set up on the NT side. -
Same for the sql mail property..

Ok... So now outside of SQL server this is where I'm kind of lost on
what has to be present and what has to happen.   Though vague,
I figured out that you need 'windows messaging' and 'mail' installed
on the NT side before you can set up a profile that SQL server
could 'See'   -<  got this far > -  

The third piece to this is to have some kind of mail client/MAPI so as
SQL server can pass out internally generated mail whether from the
agent or sql mail...  (outlook express gets installed upon setting up
NT out-of-box)  But I gather from the books (vague or a page at most)
you need Exchange Server  running + an external POP3 account
to make this thing work.

Could anybody confirm or deny this? We are a Novell/Groupwise
shop. No one's running an exchange server. Must I buy a copy
of exchange server just to send  mail from sql server - or is there
another way...?

Anyone's help or experiences would be much appreciated.

Thx, Paul S.


1. SQL Mail vs SQL Agent Mail

SQL Mail is used by the SQL Server service - configured from
Enterprise Manager under Support Services. It's used when
you do things like xp_sendmail.
SQL Agent Mail is used by the SQL Server Agent service -
configured from the properties of SQL Server Agent. It's
used for sending out email job failure notifications, alert
email notifications.  


On Thu, 14 Mar 2002 17:30:37 -0800, "yuling"

2. Creating mySQL database in JDBC?

3. Setting up SQL Agent Mail and SQL Mail

4. HELP abouty capturing keyevents/macrocreation in vb6

5. sql mail and sql agent mail

6. Exceptions in recordset-loop.

7. Lotus Notes and SQL Mail/SQL Agent Mail

8. Oracle 7.2 Capabilities

9. SQL Agent Mail and SQL Mail

10. Problem in Setting SQL Mail / SQL Agent Mail

11. SQL Mail (SQL Server 6.5) Setup Question

12. SQL agent mail vs XP_SEND MAIL

13. SQL Mail and Agent Mail with Lotus Notes