2 Replies Latest reply on Jan 17, 2020 10:09 AM by Scott Buckley

    Question about using Edit Connection to switch between two Microsoft SQL Servers

    Scott Buckley

      Hello all,

       

      My org moved data from one Microsoft SQL server to another and I need to update my workbooks to point to this new server.  Thought I could use the Edit Connection functionality from Connections area in Data Source pane.  However, when I enter the new server name the change does not happen.  In playing around, I created a brand new simple test workbook and am able to switch between servers using the Edit Connection functionality with no problem.  Can someone tell me if there is something I may not be doing, like skipping a step in order to switch connections?

       

      BTW, I am not working with published data sources.  Just extracts inside a workbook.

       

      I truly appreciate any help with this!

       

      -Scott