May 4, 2012 at 4:49 am
We have a need to provide a portal for certain external customers to access data. We believe SQL reporting services can provide the range of reports required but with this being www facing we need to make sure it is secure. Any suggestions as to what to use ?
May 7, 2012 at 12:34 am
You can run the reports in .NET using the ReportViewer and use a fixed set of credentials to run the reports.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 8, 2012 at 1:21 pm
Hi l had a similar issue in a previous company. The solution l used, was to use a content management system. The one l had most experience with at that time was Dot Net Nuke. This allowed us to set up a website, which users would then have to log into. The user admin and security being handled by DNN. Once they where logged into the site, we could configure the reporting pages to show or hide reports according to the clients specification.
In order to display reports to the user we purchased this module. Which we configured to connect to the SSRS instance we had running. Alternatively it is possible to build your own module to connect to SSRS. This solution also had the added advantage if we set up a site for a client we could customize the colour scheme and add the clients logos etc.
This was all done using the community edition of DNN which is free to download and use. I have skipped over a lot of detail just thought it was worth suggesting, as it had worked for me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply