question

sand143eep avatar image
sand143eep asked

SSRS Reports required to ask Type or enter a user name and password to access the data source:

Hello i am using SQL Server 2008R2. the report server Database and report server tempdb are restored in seperate server. SSRS 2008R2 was installed in seperate server. i got a requirement from customer that when ever the users access the reports then they need to get enter a user name and password to enter their credentials.but in current report server some reports are asking for credentials and some reports are directly opening the content.the reports asking for credentials when provided with credentials they are resulting with query processing error. i need to have all the reports to ask for credentials for users to view reports.please suggest the settings how to make it possible in SSRS 2008R2.
ssrsssrs-2008ssrs-2008-r2ssrs-2012
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
David Wimbush avatar image
David Wimbush answered
This seems like a crazy thing to insist on for several reasons. Very annoying for the user. A security hole because user names and passwords will be passed over the network in plain text unless you insist on SSL. You will have to configure permissions on the database objects so that the report queries can all be executed by the users. How will you keep track of who has access to what? You will need to configure Kerberos security so that the entered credentials can be passed from the SSRS server to the database server (aka the 'double hop' problem). And they won't be able to set up email subscriptions to reports. Seriously, make sure they understand how hard this will be and make sure they have a good reason. What are they trying to achieve by this? Maybe they just think this is the answer. If you have to do this - and I really hope you don't - I think you can achieve this by configuring the Data Sources. Select the option 'Credentials supplied by the user running the report'.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Perhaps it's cached by the browser or by IIS in the session. I'm not sure. There's a bit in this thread ( https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8f616e0e-f537-488c-8f9b-db38f9808822/why-reportmanager-prompts-for-credentials?forum=sqlreportingservices) near the bottom about using Basic Authentication to just have the user prompted for credentials at the start of their session. That might be what you need. But I still think you should confirm what the problem is and whether this is the solution before you put too much work into it. Management tends to focus on how you wasted 2 days, instead of the fact that it was their stupid idea.
1 Like 1 ·
Thanks for the update, i already configured the Data Sources. Select the option 'Credentials supplied by the user running the report'. but still for some reports its directly showing the content with out asking any credentials.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.