Authentication
Hi, I'm working on a reporting services system in order to provide access to reports for customers. I want them to have to log in, and then only see report information that is relevant to them. I assume this breaks down to two problems - I need to have a custom authentication process in order to check their credentials, and from those credentials I can ascertain the customer ID which I use as a condition in all of the report queries. I'm new to reporting services so any assistance in doing this would be greatly appreciated. Thanks, Barguast
November 30th, 2010 10:25am

Hi Barguast, "have a custom authentication process in order to check their credentials" You can configure the reporting Services use Custom or Forms Authentication. See http://msdn.microsoft.com/en-us/library/cc281383.aspx on how to Configure Custom or Forms Authentication in Reporting Services and its sample code. "from those credentials I can ascertain the customer ID which I use as a condition in all of the report queries" You must a table to map the customer IDs and their own data. On the reporting services, there is a built-in field called "User!UserID" to return the current user ID, which can be associated with their data id via the mapping table. So, via the data id, the report can only show their information. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 10:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics