Deploying Reports to a New Server

I developed some reports on one system that I would like to move to another
system. I copied the rdl file to the new system and uploaded it via Report
Manager.
The data source the report uses is based upon SQL views which I created on
the new server.
I'm having a problem with the data source. I've tried creating a new custom
data source by going to the properties of the report and clicking on Data
Sources. I've also tried creating a new data source by clicking New Data
Source from the home page of the Reports.
I've received login errors using the sa account and I've seen that, despite
picking a new data source, it still seems to use the old data source.
What do I need to do to point the report to a the current server's data?
--
Charles Allen, MVPIf both the servers are accessible on your network, just go to report project
properties and change the server to your new server and deploy it, instead of
you doing it does the job perfectly, including datasource..
Amarnath
"Charles Allen" wrote:
> I developed some reports on one system that I would like to move to another
> system. I copied the rdl file to the new system and uploaded it via Report
> Manager.
> The data source the report uses is based upon SQL views which I created on
> the new server.
> I'm having a problem with the data source. I've tried creating a new custom
> data source by going to the properties of the report and clicking on Data
> Sources. I've also tried creating a new data source by clicking New Data
> Source from the home page of the Reports.
> I've received login errors using the sa account and I've seen that, despite
> picking a new data source, it still seems to use the old data source.
> What do I need to do to point the report to a the current server's data?
> --
> Charles Allen, MVP
>|||Thank you for replying quickly.
In this case, the machines are not on the same network. One is a test
environment I use and the other is a client's production system.
--
Charles Allen, MVP
"Amarnath" wrote:
> If both the servers are accessible on your network, just go to report project
> properties and change the server to your new server and deploy it, instead of
> you doing it does the job perfectly, including datasource..
> Amarnath
> "Charles Allen" wrote:
> > I developed some reports on one system that I would like to move to another
> > system. I copied the rdl file to the new system and uploaded it via Report
> > Manager.
> >
> > The data source the report uses is based upon SQL views which I created on
> > the new server.
> >
> > I'm having a problem with the data source. I've tried creating a new custom
> > data source by going to the properties of the report and clicking on Data
> > Sources. I've also tried creating a new data source by clicking New Data
> > Source from the home page of the Reports.
> >
> > I've received login errors using the sa account and I've seen that, despite
> > picking a new data source, it still seems to use the old data source.
> >
> > What do I need to do to point the report to a the current server's data?
> > --
> > Charles Allen, MVP
> >|||ok, MS has provided a sample script on "how to deploy the reports using
command prompt", you can have a look at that sample for your solution.
Amarnath
"Charles Allen" wrote:
> Thank you for replying quickly.
> In this case, the machines are not on the same network. One is a test
> environment I use and the other is a client's production system.
> --
> Charles Allen, MVP
>
> "Amarnath" wrote:
> > If both the servers are accessible on your network, just go to report project
> > properties and change the server to your new server and deploy it, instead of
> > you doing it does the job perfectly, including datasource..
> >
> > Amarnath
> >
> > "Charles Allen" wrote:
> >
> > > I developed some reports on one system that I would like to move to another
> > > system. I copied the rdl file to the new system and uploaded it via Report
> > > Manager.
> > >
> > > The data source the report uses is based upon SQL views which I created on
> > > the new server.
> > >
> > > I'm having a problem with the data source. I've tried creating a new custom
> > > data source by going to the properties of the report and clicking on Data
> > > Sources. I've also tried creating a new data source by clicking New Data
> > > Source from the home page of the Reports.
> > >
> > > I've received login errors using the sa account and I've seen that, despite
> > > picking a new data source, it still seems to use the old data source.
> > >
> > > What do I need to do to point the report to a the current server's data?
> > > --
> > > Charles Allen, MVP
> > >