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.
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'.