By Brian Swanson on 8/21/2007 12:55 PM

I've been using DotNetNuke for A LOT of projects lately.  Mostly small projects, but a couple of larger ones that I can't really discuss as of yet...

On one of these larger projects we are using MS SQL Reporting Services, and of course we want it integrated into DNN.  The challenge we ran into was with accessing the SQL Reporting Services.  Since we aren't using the ADSI provider for authnetication, and the site is not running under an impersonated identity, how do we go about accessing reports on the SQL Reporting Services server?

It was actually much simpler than I orginally thought it would be.  I searched and found a few options that referred to Forms Authentication with SRS, but it didn't seem very elegant.

Ultimately the solution we chose to implement was to provide the ability to enter a username/password/domain to be used with a given report module.  Then we created a generic user on the SRSS for accessing the report with.

Of course the SQL Reporting Services “visualizer“ for...

Read More »