i am working on porject to encrypt the connection between ssrs reports and sql server. we have already installed ssl certificate on sql server. can i know how to encrypt the connection string in SSRS datasource
Sql-server – SSRS connection string Encryption
sql serversql-server-2016ssrs
Related Question
- Sql-server – how to add a data source to SSRS – reporting services 2014
- SSRS 2016 – Change Connection String in All Reports
- SQL Server 2016 SSRS – How to Encrypt Connection
- Sql-server – `Encrypt Connection` causes an invalid certificate error even though server-side encryption is forced
- Query Editor Connection Error With Unattended Service Account
Best Answer
When you setup a data source, you can specify components of the connection string directly.
Simply add the following to the connection string:
Encrypt=True;TrustServerCertificate=True
That will force encryption between the SQL Server and the SSRS reporting server for the given data source. Any report that uses that data source will obtain its data via an encrypted channel. The
TrustServerCertificate=True
tells the client (SSRS) to trust the server certificate, even if it's a self-generated, or untrusted, certificate.