Switching SSRS data sources from Windows Auth to SQL auth RRS feed

  • Question

  • Hello,

    I had a customer apply a GP service pack. The upgrade automatically caused the SSRS reports to deploy. It also deployed the data connections with the default settings of Windows auth. This affected 57 data sources so manually changing them back would take awhile. The customer needs to use SQL auth with an account, because of a double hop issue, and they do not want to configure Kerberos. Is there a way to run a script against the SSRS database that will change the data connections from windows auth to SQL auth with a specific account?

    Wednesday, August 2, 2017 2:35 PM

All replies