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