Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raj vardhan43
Starting Member
20 Posts |
 Posted - 2012-05-03 : 16:30:32
|
| Hi All,I need your advice. I had successfully moved all the ssrs reports from our production server(prod1) to development server(dev1). I had used backup and restoration(Encryption Key) method. Issue : I had changed the Datasource(datasource1) connection string in report manager from prod1 to dev1 as shown belowData Source=prod1;Initial Catalog=proddbtoData Source=dev1;Initial Catalog=devdbIdeally this change should be reflected in all the reports which are using datasource1, ie now my reports which are on dev1 server should get the data from 'dev1' not from 'prod1'. But, this is not working!! I have to manually change the datasource of each report dataset. I have nearly 85 reports, so changing manually is not a better idea.Please suggest me a better method to accomplish this.Thanks for your time!!Vardhanraj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-03 : 17:17:34
|
| were reports using a shared datasource?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
DATASOURCES FROM PRODUCTION SERVER TO DEV SERVER f