Put SSRS credentials in url to see reports

Question

Put SSRS credentials in url to see reports

SSRS questions 111

Hi.
I have a url in my web application to see the reports. But it ask the credentials to see the reports:

How can I put the SSRS credentials in the url to avoid the prompt? The credentials of the web portal not the datasource

4 answers

Your answer

Answer 1

Anonymous

Sounds good, I'd ask that one over here.
https://learn.microsoft.com/en-us/answers/topics/windows-server-iis-troubleshooting.html

--please don't forget to upvote and Accept as answer if the reply is helpful--

Answer 2

ZoeHui-MSFT 41,446

Hi @SSRS questions ,

You can provide a custom authentication extension for SSRS that handles security.

authentication-with-the-report-server

Here is a sample for your reference: CustomSecuritySample2016

You may also use the Report Viewer control if you want to allow public access to secure reports without asking for credentials as said here.

Also a sample programmatically-pass-credentials-embedded-power-bi-report, you may take a reference.

Regards，

Zoe

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

SSRS questions 111 Reputation points

2021-06-09T18:58:40.437+00:00

Hello.

I try the option of CustomSecuritySample2016 but it is very defficult and I don't really know how to use it.
I can't use ReportViewer since I'm using mobile reports and RV only works for paginated reports.

I like the option of the PowerBI embeded since the way I display the reports is the same as explained in the previous post of that url you send me (using <iframe>).

I try something like this (but with my mobile reports):

”test3:Password1@win-hauseq7hanj:82/Reports/powerbi/reportdemo2?rs:embed=true”

And it works!!, I like this. BUT this option only works for firefox, not chrome not edge. What can I do in this situation?
Also, it is dangerous to use emdeded credentials in the url?

Thank you so much.

Answer 3

Olaf Helper 46,461

Which browser are you using?
By default SSRS uses Windows authentication and Internet Explorer & Edge automatically passes the credential of the current user to SSRS; Firefox & Chrome don't
In Firefox you can set it up:
https://codepunk.io/windows-authentication-pass-through-in-firefox/
https://community.rsa.com/t5/rsa-securid-access-cloud/configure-user-browsers-for-integrated-windows-authentication/ta-p/571239

SSRS questions 111 Reputation points

2021-06-08T18:42:04.833+00:00

The webb app users can use firefox, edge and chrome.
"By default SSRS uses Windows authentication and Internet Explorer & Edge automatically passes the credential of the current user"
That could be a problem. I don't want to pass the windows credentials of the user who is watching the report. I have one user registerd in the server and I only want to use his credentials. I can't create 100 users in the windows-host and add them to the SSRS server. In adition, each user pc has his own windows domain.
I want something like a normal web app. Users login in the web app an can watch the reports. Since I must create an user to allow him to watch the reports, I want to use those credentials embeded for all users.

I test the connection with edge, and It also display de prompt for credentials.

Answer 4

Anonymous

What I've always done is to create an SQL user, then give that user datareader to the underlying report source views or tables, or execute permissions in the case of a stored proc source. Then in the report data source or shared data source, save the credentials,

then republish the report plus the report data source

--please don't forget to upvote and Accept as answer if the reply is helpful--

SSRS questions 111 Reputation points

2021-06-09T18:56:35.4+00:00

The credentials that the browser ask for are the web portal, not the datasource

Share via

Put SSRS credentials in url to see reports

4 answers

Your answer