1. Make sure that the following is Enabled: 3 Services:
SQL Server (MSSQLServer)
SQL Server Reporting Services (MSSQLServer)
SQL ServerProxy(MSSQLServer)--- SQLThe proxy service is very important. mail subscription depends on it.
2.OpenSQL Server Management Studio
Step 1: After connecting to the database engine, right-click Database mail in the manage option and choose configure database mail]
Step 2: In the pop-up window, click Next Wizard to [select Configuration task] and select the firstRadio
Perform the following tasks to install the database Email: click Next.
Step 3: click Next. In the displayed "create configuration file" dialog box, enter the name and description of the configuration file.,Click Next. In the pop-up dialog box "create database email account", enter the corresponding email information, click "OK", and then click "Next ".
Step 4: select the configuration file you just created in [manage configuration file security], click Next, and continue until the next step is complete. At this moment, the mail configuration is complete.
3. Open 【 Reporting Services Configuration Manager: connects to the Report Server instance.
Navigate to the email settings page, enter the response email information, and click Apply.
4. This email subscription SSRs The report's preliminary tasks are basically completed. Next, we will test the settings we just set:
Step 1: Open IE ( Something of Microsoft IE Is fully supported ) And open the report. Web Manager
Step 2: Click [subscribe] In the report email you want to subscribe]
Step 3: Set the recipient, subscription format, and time on the subscription page....,Click OK.
Step 4: Click my subscription to navigate to subscription and open the receiving mailbox.
So farSSRsThe email subscription configuration and test have been completed.
Tip: SQL You can use your company's SMTP Server, you can also use other mailboxes.
provides my environment: SQL Server 2008r2 + Windows Server 2008 R2
verified environment: SQL Server 2008r2 + Windows Server 2003 sp2
SQL Server 2008r2 + Windows 7 flagship edition
SQL Server 2008r2 + Windows Server 2008 SP2