Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Access SSRS From Multiple Untrusted Domains? Expand / Collapse
Author
Message
Posted Tuesday, April 8, 2014 9:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 10:08 AM
Points: 3, Visits: 30
Hi. I'm working with a client who has an SSRS portal that is accessed via web browser. They would like users from multiple untrusted domains to be able to authenticate and gain access to SSRS. It appears that native authentication methods would require a trust to be setup to allow multiple domains. It's a long story, but setting up a trust is not an option in this case. Does anyone know of a 3rd party product that solves this problem?

By the way, it's a 2008 R2 SQL Server.

This client had a similar need for their DotNetNuke portal, and we were able to solve it with a nifty 3rd party module (AD Pro by Glanton). On the login screen, the users select the correct domain from a drop down list, and then enter their user name and password. Internally, each domain is defined with a different LDAP source. It's slick!

I was hoping that a similar 3rd party add-on might exist for SSRS.

Thanks!
Van
Post #1559557
Posted Tuesday, April 8, 2014 10:32 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 4:58 AM
Points: 213, Visits: 827
Setting up your own authentication method for SSRS has been discussed before (a lot!) but I've never seen an implementation of it that I could understand because it requires a fairly high-level of programming knowledge.

There are two places I'd direct you aside from a Google search. One is the book Applied Reporting Services as I'm fairly certain it directly addressed it (check the table of contents).

Secondly there was a sample in the Reporting Services 2008 Samples. It shows you how to have a web page with its own credential system, and you could link it to the SSRS back-end to check those credentials. I take it that's what you want to achieve.

Please post back with your findings. I've always found it interesting.
Post #1559774
Posted Wednesday, April 9, 2014 11:39 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 709, Visits: 4,520
In the 2008 version, there's a whole chapter on Customizing Security.
Post #1560113
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse