Hi, I have lots of reports created using the version ssrs 2008 and the data source is oracle. All the reports are connected to one DB server. But soon db sever is going to change. So whenever there is a change in the db server I want all the reports to be automatically connected to that new server. So I don't need to individually change the data source of all the reports manually. Please help me to find a solution to this problem. Thanks.

Hello Marian, Have you used a "Shared Datasource" for your reports? Then you only Need to modify this one datasource.Olaf Helper Blog Xing

Hello Marian, One of the default best practices is to always use SQL Aliases when attaching to a datasource. As long as a SQL Alias Exists and the DBNames do not change your datasource will appear the same, and SQL Aliases are easy to modify. We always do this when setting up new DB servers and is a best practice. However, we also ha clients that need to migrate their applications to a new server and think they have to re-install, its kind of funy but they think your a genius just because you can save them endless hours of headaches by implementing aliases. From the command line Enter CLICONFGHighlight TCPIP, Click EnableClick on the Alias Tab, and Click AddClick the TCPIP Radio ButtonEnter the Old SQL Server Name in the Server Alias BoxEnter the New SQL Server Name in the Server Name BoxUncheck, Dynamically AssignEnter Port 1433, and Click OK. Make sure on your new SQL Server that you don't have an inbound rule blocking Port 1433.On the old SQL Server Stop the SQL ServicesOn the new Cloned Servers start the SharePoint ServicesRun IISReset Now test your SSRS Reports... -IvanIvan Sanders My LinkedIn , My Blog, @iasanders, BI in SP2013, SP2013 Content Packs.

Hi Olaf, Thanks for your response. There is a shared datasource. But that is possible for reports in one project, right? All the reports are created in different projects.

Hi Ivan, Thanks for your reply. But my data source is Oracle.

Hello Marian, You can used shared datasources over several report projects, as long has the shared datasource do have the same context (same database + creditials). In the already deployed reports your can change the datasource to an existing shared datasource.Olaf Helper Blog Xing

Hi Olaf, I used have same database and credentials for my shared data source. I am new to SSRS. So if you can explain me the steps, it would be great help. In which location, do I need to modify the data source? Bu still my goal is not just that. The solution you suggested can apply only to existing shared data source. Actually I want my reports to be connected to new data source. I saw something in the link below. But I couldn't find any option like "Report Parameters" in SSRS 2008. http://www.sqlservercentral.com/articles/Development/2945/ Thanks.

Hello, Did you create .rdl report in Report Designer and deploy to report server? The "Report Parameter" pane in above link is display in the report data pane in SSRS 2008. (If you did find the report data pane, cilck "View" in menu bar and select "Report Data".) In your issue, there is no need to create a dynamic connection string by using parameter. After deploy the report project to Report Server or Sharepoint site, we can create and manage shared data sources separately from the reports. For example, we can modify the shared data source by change connection string. Reference:Create, Delete, or Modify a Shared Data Source Regards, Fanny Liu Fanny Liu TechNet Community Support

Hello, Did you create .rdl report in Report Designer and deploy to report server? The "Report Parameter" pane in above link is display in the report data pane in SSRS 2008. (If you did find the report data pane, cilck "View" in menu bar and select "Report Data".) In your issue, there is no need to create a dynamic connection string by using parameter. After deploy the report project to Report Server or Sharepoint site, we can create and manage shared data sources separately from the reports. For example, we can modify the shared data source by change connection string. Reference:Create, Delete, or Modify a Shared Data Source Regards, Fanny Liu Fanny Liu TechNet Community Support

Hi Fanny, Thanks for the reply. What you told is exactly right. I got this info from some other source. I tried it and worked.