Share via

Sql Server Reporting Server connect report server db with encrypted connection

Bilgehan Yıldız 1 Reputation point
2021-03-14T11:11:07.657+00:00

I use sql server reporting server to host my msreporting.I want to encrypt my sql server connection (not connection string I mean ,its is already encrypted) encrypted on network traffic traffic

Normally I can add encrypt=true value to mysqlserver connection string and that time it works in my c# code.How can do same feature in sql server reporting server(SSRS 2019)

c# sample Provider=SQLOLEDB;Data source=HOSTNAME;Initial catalog=databaseName;User Id=userName;Password=password;encrypt=true

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,847 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,351 Reputation points
    2021-03-15T05:37:41.527+00:00

    Hi @Bilgehan Yıldız ,

    It seems that we couldn't connect report server db with encrypted connection.

    We could use Reporting Services Configuration Manager and rsreportserver.exe to connect to the report server database.

    Neither of them gives us the option to add the encryption connection.

    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