What credentials need to be passed when accessing an SSRS report through URL?

Question

I know this is repeat question, but I have searched almost all the threads about this and have not found any solution to my problem. Some of threads show a solution like:

&dsu:DataSourceName=username&dsp:DataSourceName=password

But this doesn't work for me. What value should I give for DataSourceName?FolderName/SharedDataSourceName or only SharedDataSourceName? For username and password do I need to provide Windows username and password for where the report server is installed? I tried all possible combinations, but nothing has worked.

I am showing this report using Kendo Window & iFrame controls in an Angular SPA application. iFrame is being passing SSRS URL and showing report.

Firstly why does the dsu: & dsp: method not work for me? And if it's working but not secured as passing username and password then what other approaches are available for URL based reporting service?

Answer 1

In the RDL of the report and on your SSRS reports manager you should be able to set a DataSource and authentication type. If you have the RDL looking at a shared DataSource then put the DataSource in the same folder as the RDL and you can click 'Manage' on it and enter the credentials/authentication type you want