How can I pass a generic login and password in the URL for an SSRS report embedded in an iFrame in Sharepoint?

Question

How can I pass a generic login and password in the URL for an SSRS report embedded in an iFrame in Sharepoint?

Lela Keller 86

Jul 5, 2022, 9:58 PM

We have an SSRS report embedded in an iframe in Sharepoint. To prevent users from having to enter their login and password each time they access that page in Sharepoint, I need to be able to pass a generic login and password in the URL as not all users have access to the reporting server but all users need to be able to view this particular report. I'm also open to other suggestions on how to accomplish this.

In addition, there are two text boxes with an expression in the Action section that update the report with data for the prior month or next month and those will also need to be modified as they are also making calls to the reporting server.

1 answer

Your answer

Answer 1

Olaf Helper 46,201

Jul 6, 2022, 5:38 AM

I need to be able to pass a generic login and password in the URL

It's not possible.
SSRS works with Windows authentication and if user should be able to access the report(s), you have to grant access for them.
An option is to create a AD group, grant access for that group and add the users to it.

Yi Lu_MSFT 17,611 Reputation points

Jul 10, 2022, 4:22 PM

Hi @Lela Keller
Is OlafHelper's answer is helpful for you? Please feel free to reply.
Lela Keller 86 Reputation points

Jul 10, 2022, 8:14 PM

Hi @Olaf Helper ,

The problem is we do not want the users having to type in their login each time they access the home page where the report will be located on in Sharepoint. We were able to find a way to pass the login/pwd in the URL outside of Sharepoint, but that we need it to work inside Sharepoint.
Olaf Helper 46,201 Reputation points

Jul 11, 2022, 5:59 AM

The problem is we do not want the users having to type in their login each time they access the home page

Then you are doing something wrong, if you grant access to users they don't need to enter login credentials.
Lela Keller 86 Reputation points

Jul 11, 2022, 6:57 PM

I assume you mean grant access to users in SSRS. All users have access to the report so I don't see how I'm doing something wrong. I created the report and it asks me to sign in as well.
We do not have single sign on between Sharepoint and SSRS and I haven't checked to see if that's even doable.

The future is yours

Share via

How can I pass a generic login and password in the URL for an SSRS report embedded in an iFrame in Sharepoint?

1 answer

Your answer