How to configure SQL Server to send email
Zhu Er (2004.9 reproduced please indicate the author)
Usually everyone knows: SQL Server and Microsoft Exchange Server integration is very good, and about this configuration, there is a detailed description in the online help of SQL Server, and details are not described here. However, we are more concerned about how to configure SQL Server to send emails without Exchange Server, how do you configure SQL Server to send emails with Internet mail servers? The author has hurt the brain for this issue. It is found in the Internet. It is found that only a few pieces of information have been brought. Although it introduces the operational steps, you can follow the steps step by step, and the result is always failed. . To this end, I finally find a simple and effective way, I don't dare to enjoy alone, the following is a detailed configuration step, if you encounter problems during the operation, please leave a message. Test Environment: 1 Windows 2000 Server2 SQL Server 2000 SP33 Microsoft Outlook (Office 2000) Prepare an Internet Mail Account: Test Email Account: Test@163.comSMTP Server SMTP.163.COMP3 Server Pop.163.com Step 1: Change Email Configuration 1 Open Microsoft Outlook Click Options in the Tools menu, and then click the Mail Services tab. 2 Click Reconfigure Mail Support. 3 Select "Used for Enterprise or Workgroup" option 4 Restart Microsoft Outlook Step 2: Add Profile Description: If you have previously added configuration files (for example, profile name: test), The following 1,2,3 operation steps can be omitted
1 Click Services in the Tools menu and click the Add button. 2 Select "Internet Email" and click OK. 3 The following steps are to set an email account, refer to the Microsoft Outlook Help file, and details will not be described here. 4 Use the configuration email account to send and receive mail, confirm that the configuration is successful. Step 3: Configuring the MSSQLServer service Using the Mail Profile 1 Restart the MSSQLServer service (must, otherwise the MSSQLServer service does not detect the configuration file added to the previous step) 2 Open Enterprise Manager -> Expand Server -> Support -> Right click "Mail" -> Click the drop-down box, you will find the "Microsoft Outlook Internet Settings" option (if you add configuration files, such as: Configuration File Name: Test, then you will find TEST options ), Select your configured configuration file, click "Test". If you have a successful dialog, congratulations, you have already gone it. Step 4: Enjoy your labor results 1 Open SQL Server Query Analyzer 2 Enter the following SQL statement, execute exec master@163.com ',' Hello, World! '3, go to your mailbox to collect mail!
Note: The above configuration procedure requires the Windows 2000 Server, which is used by the MSSQLServer service, that is, the account you use by your login and the Windows account used by the MSSQLServer service.