I have the same issue to deal with here at my new job. The company has a asp.net app that has it's own security (user name and pswd). There could be huge growth into how many users dealing with. At this time over 2K users/dealers. So we really don't want to go the AD route (huge initial setup headache and constant maintenance costs, too)
We're running SQL Server rs 12 (I think)... So, will the same solution deal with my issue??....i.e.....the user will log into the ASP.net app and they will Click on a URL ( I guess) to gain access to SSRS web page. There they will have access to all the 20 reports in Prod (at this time) to print out ONLY their data and not some other users/dealers data.
I will need to get their userid passed as a parm into SSRS to filter out the data on each report too. (We can't have Lucy looking at Fred's data and visa versa!)
I'm new at this side of SSRS, having developed 100's of reports. Just never had to do the setup to get to the boody reports!
Any help would be greatly appreciated!