Reporting Service—Limit the clients access for their own report only.

• Jackson Ma

  Newbie

  Points: 9

  More actions

  January 22, 2007 at 5:31 pm

  #116027

  Hi, there,

  Our product is web based coded in ASP. We have about 100 clients, each client has its own web site and database. I try to implement SQL 2005 Ad Hoc reporting for the clients.

  What we do is to have a box installed with SQL 2005, use ODBC to point to clients databases, which are SQL 2000 DBs on others boxes. The user will load report builder via the report service web page and create/run reports on their machines, then they should be able to save their report on the server.

  My question is, how to restrict the users only see their own report (or sub folder on the server). SQL2005 offers two levels of permissions, but both have to use windows authentication. Our users are connecting via web access, not on the same LAN.

  Anyone has any idea? Thank you in advance

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  January 29, 2007 at 6:07 pm

  #686339

  You still need a method of authentication so you will know which reports a user can see.

  Reporting services has Forms authentication, but it takes a little work.

   

  http://msdn2.microsoft.com/en-us/library/ms152899.aspx