Configuring SQL Mail
In order to use the SQL Mail stored procedures and to process incoming email messages, you must configure the SQL Mail account used by the MSSQLServer process. Emails used by alerts and jobs statuses (that is, SQL Server Agent) are not performed by the MSSQLServer process email account but by the SQL Agent account, which must be configured separately. Let's look at how to set up the SQL Mail account first (that is, MSSQLServer process). To do this, follow these steps:
1. |
Open the SQL Server Enterprise Manager. Expand the appropriate Server group, and then expand the appropriate server and open the Support Services Folder. Right-click the SQL Mail icon and click Properties. You will see the dialog box shown in Figure 25.1 ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
