What we do (in our SSRS 2000) install is keep the datsources in a separate folder to all of the reports. SSRS2005 does this by default (ie it has a datasources folder). You can then set the security on the data sources folder so that only admins can see it. You change the properties on the report to point to the appropriate datasource in the folder.
HTH,
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply