Data source error - Security protocol not supported

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  August 22, 2019 at 1:17 pm

  #3673556

  Hi Experts,

  I have a report that fetches data from a cube .I have an issue with a data source which is returning an error "Security protocol not supported".This is only happening in SSRS reporting server  after deployment but in visual studio the report is working perfect.I have been working on this without no success.

  Anyone who came across this error?Please help.

   

  Many thanks

  Attachments:

  You must be logged in to view attached files.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  August 22, 2019 at 4:44 pm

  #3673696

  If the data source connects to a instances with TLS, Try adding Encrypt=yes to the connection string. Depending on different configurations, you may also have t include trustServerCertificate=true. The following documentation has a chart of the different settings, client and server, and how it affects encryption:

  Using Encryption Without Validation

  Sue