October 23, 2007 at 10:50 pm
Does anyone know of any good a-z articles on using Forms Authentication with SQL 2005 Reporting? I've found a lot of bits and bytes but nothing that can take you from a to z.
Our requirements are to have a single sign from the internet, however we need to integrate it with our current site which already has a Custom authentication built. I've looked at some of the SQL 2005 samples and most of them want you to use their Username and password tables...etc.
We also need to define who has rights to what reports but without using windows authentication.
Thanks in advance for shedding any light you can on the subject.
Thanks,
October 25, 2007 at 7:39 am
I don't know of any real detailed description of this. When we were looking at what our options were with Reporting Services, the consultant outlined a custom forms based similar to this. But remember if you want to leverage the same site internally, there may be some conflilcts. And if you source any reports from SSAS, you'll have some other considerations.
Don't know if you've already seen these:
http://msdn2.microsoft.com/en-us/library/ms152825.aspx
http://blogs.msdn.com/bimusings/archive/2005/09/08/462544.aspx
What we considered more seriously, was using Kerberos Protocol transistion with a reverse proxy server. Seemed like less custom code, and we wanted to have the users in Active Directory. Internal, or External to our network, all users were known. We didn't want to allow anonymous access to anything.
I might be able to get you in touch with one of the consultants we talked with. But it sounds like you'd rather just build your own solution.
Good Luck!
Greg E
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply