Link to home
Start Free TrialLog in
Avatar of curiouswebster
curiouswebsterFlag for United States of America

asked on

SSRS Deployment problem

I thought I understood a bit about SSRS and deployed my working report to production. I did this from an instance of Visual Studio 2005, loaded as an Administrator. First, I changed the deployment string to point at the production server, rather than the QA server where tests showed the report was ready to go live.

After this one change, I right clicked the one report to deploy and clicked "Deploy". I got a success message and was done. I checked the URL to the Prod server and found the two new columns I added were there, so I considered my task complete. Then I was told ALL reports "looked weird".

The QA database suddenly became the source database for hundreds of reports in production.

What are the steps to deploy a single SSRS report to a different server?

Thanks
Avatar of D Patel
D Patel
Flag of India image

Right Click on the solution and Click Properties

In Active Configuration > General Tab you will need to set two properties...

1. Target Report Folder and
2. Target Server URL

After setting deploy your report and then check.

Hope this will resolve your problem.

Regards,
D Patel
SOLUTION
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of curiouswebster

ASKER

> alter the project properties to never overwrite the data sources if they already exist.

This seems like the best solution for me. How do I do this?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks