How to configure SQL Agentmail and SQL Mail to send and receive mail SQL Agentmail is the email service responsible for sending an advertisement when the warning is triggered or when the scheduled job is successful or fails; SQL Mail is the email message used to process the database application And handle the service of the email. Let's talk about how they are configured. 1. When you configure the mail service, we should remember: 1. An email client program (can be Outlook or Exchange Client) must be installed on the computer running SQL Server. You must use an email account for extending the MAPI (Mail Message Design Interface) and to ensure that your email client is compatible with the email server. 2. Configure the user login account that launches the SQL service, which can be a local administrator user or a domain user (recommended domain users). Here you'd better log in to each service to log in to the account. 2. Configure the mail configuration file correctly. Configure it to "Control Panel" -> Mail. Confirm that the configuration file used is correct, you can send and receive mail normally (you can use Outlook to make a messaging test of the message to determine if your profile is no problem). 3. Configure SQL Server. Set SQL Message 1. Expand the server group and expand the server. 2. Expand the Support Services item, right-click the "SQL Mail" item, and then click the Properties menu item. 3. In the Configuration File Name list, type or select the mail configuration file configured for SQL mail. 4. Click the Test button to check the ability to start and stop the mail customer program service using the entered profile. A message should be received, pointing out that SQL mail has been successfully launched and stopped mail sessions using this profile. Set SQLAGENTMAIL 1. Expand the server group and expand the server. 2. Expand the Administration item, right-click the SQL Server Agent item, and then click the Properties menu item. 3. If you are configured with a mail profile using a domain account from the domain account used by Microsoft® SQL ServerTM, click this account, then enter Microsoft Windows NT® 4.0 or Windows used to create a mail configuration file for SQLAGENTMAIL. 2000® account name and password. 4. In the Mail Profile box, select the mail profile created for SQLAGENTMAIL. 5. Click the "Test" button to check the ability to start and stop the mail customer program service using the entered profile. A message should be received indicating that SQL mail has been successfully launched and stopped messaging with this configuration file.
