Hi, I am in the process of moving all the ssrs 2005 reports to 2008 r2. While doing so in the new reporting environment i have to grant access as previously to the users. Is there a better way of doing it rather than do manually? Thanks.........

Hi, Generally, we don't need to grant access permissions manually after migration since the Report Server database contains permissions for accessing report server content and it also has been moved during migration. For more information about Migrate a Reporting Services Installation, please refer to http://msdn.microsoft.com/en-us/library/ms143724.aspx Thanks, Tony ChainTony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi, Thanks for the response. The other question that I have is We have many reports for the Finance, HR, Inventory so created a folder for each report category and most of the reports use Datasource DB1. Instead of having the same datasource in all these folders is it a good practice to create a different folder to store only the .rds files or would this approach degrade report performance. Thanks

Hi, Thanks for the response. The other question that I have is We have many reports for the Finance, HR, Inventory so created a folder for each report category and most of the reports use Datasource DB1. Instead of having the same datasource in all these folders is it a good practice to create a different folder to store only the .rds files or would this approach degrade report performance. Thanks

You don't need to create a separate data source for each set of reports. You can use the same shared data source as long as the reports are hitting the same server. Also, this will have no impact on your report performance but it's just a good practice to organize your content. Hope that helps.