In SQL Server reporting services, you can use the "Reporting Services Configuration Manager" to configure the SMTP server for sending emails. However, you cannot explicitly configure the user name and password for logging on to the SMTP server, log on to the SMTP server using the account that starts the Reporting Services Service. Therefore, if reporting services and SMTP are in the same domain, you can set the domain user logging on to SMTP as the startup user of reporting services to pass SMTP authentication.
However, in many cases, we need to explicitly configure authentication for logon to SMTP, which cannot be implemented through the "Reporting Services Configuration Manager. You can solve this problem through the following methods.
First, install the SMTP service (a Windows function) on the reporting services server and configure the locally installed SMTP.
Start IIS Configuration Manager
Open SMTP Properties window
In the smpt Properties window, switch to the access tab and add the IP address 127.0.0.1 for "connection" and "replay" respectively.
Switch to the "delevery" tab.
Click "Outbound Security". In the "Outbound Security" attribute window, set the user name and password for logging on to the SMTP server.
Click "advanced". In the "advanced" Properties window, set the SMTP server information.
Other options can be adjusted as needed.
Finally, you need to manually adjust the configuration file of reporting services to use the SMTP information configured above.
Configuration File Name: \ Reporting Services \ reportserver \ rsreportserver. config
Set the following items in the file:
<Smtpserverpickupdirectory> C: \ Inetpub \ mailroot \ pickup </smtpserverpickupdirectory>
<Smtpusessl>
</Smtpusessl>
<Sendusing> 1 </sendusing>
<Smtpauthenticate>
</Smtpauthenticate>
<From> XXXX @ xxxcom </from>