Hello, I was wondering of someone might have some advice about setting up SSRS and ASP.NET for internal and remote access using Integrated Windows Security. We have the following scenario:
1. ServerDB has SSRS and SQL Server installed on it
2. ServerWS has our ASP.NET application running on it
Our ASP.NET application has a form which calls an SSRS Webservice against ServerDB to show what reports the user can run, and a form with a report viewer on it which displays the report. The config file for the website is set up to impersonate the user
so that when viewing reports it uses the users credentials to ensure only reports that user has access to are displayed. For the rest of the site, we don't use impersonation and instead use the credentials of the user running the app pool, so only that user
is set up on the database.
I believe we have Kerberos enabled to get around the double hop issue. When connecting inside the domain to ...
Go to the complete details ...