Skip to Content
Former Member
Jan 21, 2020 at 07:19 PM

Changing the OBDC for a lot of reports



One of the databases that has 180 reports pointing at it - is moving server.

There database is keeping the same name but there is no DNS alias on the existing server

The odbc driver will need to be updated to SQL server native client 11 and the Application Intent set to read only and Multi subnet fail over set to true

My problem is I will have to go into all 180 reports individually and set Datasource Location to the new server once set up. Then probably need to reschedule the reports that scheduled to pick up the new odbc

Is there any quicker way of doing this?