Report deploment to multiple servers SQL Reporting 2005

Hi

Another issue I would like your help:

We are writing reports for different clients. We need to deploy the same reports to different clients (thus also different DataSources). What is the best way to handle this? The folder names would probably be the same.

Andre

Sounds like you need a custom installer that will accept the required input (database name, credentials, folder path) and deploy the reports by calling down to the Report Server APIs. Or, you can script the objects and use the rs.exe utility to deploy. You may also find the RSScripter utility useful.sql

Report Builder Question

Please help!!!!

We have recently implemented an SQL Server 2005 and when i click on the report builder button (reporting services) for the user i am getting the message "Application Download did not succeed. Check your network connection or contact your system administrator or Network Service Provider"

This is actually performed while the user has administrator privledges.

If someone has this problem or a solution, could you please post.

Thanks

This sounds like at authentication problem. If the logged-in user's default Windows credentials are not appropriate or sufficient for authenticating to the report server, then ClickOnce cannot download the application. In these cases (i.e. when you are not using Windows Auth), you need to go into IIS and allow anonymous access to the ReportBuilder virtual folder.

Hope that helps.

sql