Need help designing authentication for SQL SRS in DMZ
Posted on 2009-03-30
We have a SQL Reporting Services server built and are prepared to put it on our DMZ which has already been prepped and readied for this function.
We're going to have customers access this SSRS via the internet to access data and run reports off of this model. Right now though, I was wondering if anyone could help me with best practices on how to configure the user authentication piece. Right now, we're considering just opening up ports between the SSRS server and our AD domain controllers, and using our corporate domain for both our users and customers.
We're open to suggestions..