curiouswebster
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
This seems like the best solution for me. How do I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
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