SSR 2016 + Encrypted parameter + shared dataset

• prathibak

  SSC Enthusiast

  Points: 118

  More actions

  December 14, 2020 at 8:36 pm

  #3820417

  Hi,

  We are using SQL Server 2016 and SSDT 15.1.6 to create SSRS reports. Using Shared dataset to be used by 10 reports. Dataset has 2 encrypted data columns. Reports also has parameter SSN which may be supplied or may not be. Report has date range FromDate and EndDate parameters.

  1. SQL Server 2016 is used.
  2. Always Encrypted is used to create CMK and CEK by running SSMS as admin
  3. 2 columns in the table are Encrypted (Determinstic) using above keys
  4. Key is exported along with password
  5. Connection is encryption enabled
  6. Parameterization checkbox is checked
  7. Client (report server) imported the certificate into local machine and SSRS service account is given permissions
  8. In SSRS reports, tried ODBC driver, Microsoft SQL Server driver with encryption enabled in data source.
  9. In SSDT also, tried same

  when we run report in report server (web URL), 1st row in the table is coming back. Not filtered data.

  In SSDT, it is not even returning. Erroring.

  Please suggest what to do.

  Thank You

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  December 15, 2020 at 9:10 pm

  #3820884

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.