SSRS Email SSL Option

Chinni 21 Reputation points
2021-03-24T22:50:57.583+00:00

I have a couple of question about Email settings

I see that email settings password is encrypted in the config file. What is used to encrypt this? Is it the encryption key that is used for the reports?

If I want to migrate my SSRS to a new host, I will transfer the databases along with the encryption key and config files. But what will happen to the my email settings? would the emails continue to work?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,993 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 40,586 Reputation points
    2021-03-25T06:09:29.613+00:00

    Hi @Chinni ,

    Username and password (Basic) allows you to specify a username and password to connect to the mail server. You can also select Use secure connection to have this go over an encrypted connection to your mail server.

    Selecting this option will set <SendUsing> to a value of 2 and <SMTPAuthenticate> to a value of 1 in the rsreportserver.config. Selecting Use secure connection will set SMTPUseSSL to True. Username will be set in <SendUserName> as an encrypted value. Password will be set in <SendPassword> as an encrypted value.

    Encryption key is used to secure credentials and connection information that is stored in a report server database. It's not the key to encrypt email settings password.

    If you transfer the databases along with the encryption key and config files, the e-mail settings should continue to work.

    e-mail-settings-reporting-services-native-mode-configuration-manager

    ssrs-encryption-keys-store-encrypted-report-server-data

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.