you can setup permissions on report through report manager

If report doesn't have to show real time data - create snapshot or cache it.

It should be 1.0 If you want to use report builder 2.0, then you have to configure that

did you solve this? I have almost identical setup and I need to generate validation key to support state validation (as per msdn). Trying to find the way...

Thanks Lowell. You function works like a charm

You have to be a member of a "Local Admin" group on that machine, I think.

I am assuming that you have some unique key (some kind of ID) for the record displayed in the row of datagrid. Grab it and pass it as a...

You can also create stored proc and exec xp_cmdshell inside it

xp_cmdshell -google it

make sure that you set authentication to "Forms authentication" in webconfig file.

Another way would be to create table where you can store user names, passwords and roles for users. On login button click you will create connection to sql , do...