How to configure the email settings in reporting services configuration manager.

8.6K    Asked by shyamJoshi in SQL Server , Asked on Nov 28, 2019
Answered by Prateek Jain

SSRS configuration manager allows you to configure the email settings. IF you want to send out an email via subscriptions, then you can setup the email port and server via configuration manager.

SSRS uses a SMTP (simple mail transfer protocol) to send out the emails.

Via email, you can deliver the reports or report processing notification to users.

Port 25, is default for the SMTP and it should be enabled at machine where SSRS services are running.


You can provide the SMTP like, mail..com:25.

You can also configure the sender’s address which can be anything and it does not need to be created at your active directory level.



Your Answer

Answer (1)

Configuring email settings in SQL Server Reporting Services (SSRS) through Reporting Services Configuration Manager involves several steps. Here’s a detailed guide to help you through the process:

1. Open Reporting Services Configuration Manager:

Go to Start Menu > Microsoft SQL Server [Version] > Configuration Tools > Reporting Services Configuration Manager.

Connect to the Report Server instance you want to configure.

2. Navigate to E-Mail Settings:

Once connected, click on E-Mail Settings on the left-hand side menu under the Service Account section.

3. Configure SMTP Server Settings:

  • SMTP Server: Enter the address of your SMTP server. This is typically provided by your email service provider (e.g., smtp.gmail.com for Gmail).
  • SMTP Server Port: Specify the port number for the SMTP server (e.g., 587 for Gmail).
  • Sender Address: Enter the email address that will appear as the sender of the emails.
  • Use Secure Connection (SSL): Check this box if your SMTP server requires a secure connection (SSL/TLS).
  • Authentication Mode: Choose the appropriate authentication method required by your SMTP server (e.g., Windows Authentication or Basic Authentication).
  • User Name and Password: Provide the credentials if authentication is required.

4. Test E-Mail Settings:

Click on Apply to save the settings.

Click on Send Test E-Mail to verify that the email configuration is correct. Enter a recipient email address and click Send Test E-Mail.

5. Configure Execution Account (if necessary):

Ensure that the service account configured for SSRS has permissions to send emails through the specified SMTP server.

6. Restart SSRS Service (if necessary):

Sometimes, restarting the SQL Server Reporting Services service may be required for the new email settings to take effect.

Example Configuration:

  • SMTP Server: smtp.gmail.com
  • SMTP Server Port: 587
  • Sender Address: your-email@gmail.com
  • Use Secure Connection (SSL): Checked (if required)
  • Authentication Mode: Basic Authentication
  • User Name: your-email@gmail.com
  • Password: Your Gmail password

Additional Considerations:

Firewall and Network Settings: Ensure that outbound SMTP traffic is allowed through your network firewall.

SMTP Server Requirements: Verify any specific requirements or restrictions imposed by your SMTP server provider (e.g., IP whitelisting).

Notes:

Configuration steps and options may vary slightly depending on the version of SQL Server and Reporting Services you are using.

Always ensure that you comply with your organization's policies and legal requirements when configuring email settings.

By following these steps in Reporting Services Configuration Manager, you should be able to configure SSRS to send email subscriptions and notifications successfully. If you encounter any issues, reviewing the SSRS logs or consulting with your email service provider for specific SMTP configuration details can be helpful.

4 Months

Interviews

Parent Categories