Back

How to mass update the SQL server name in SmartConnect maps.

Published: Nov 08, 2012
Post Author Written by David Youngquist

After moving the entire Dynamics GP DYNAMICS & Company DB’s to a new Dynamics GP server, all the maps are still pointed toward the old server.  You can manually delete the old entries and add the new ones, but each and every map needs to be opened and edited.  Is there a faster way?

Yes, you can update the TenantBase table to point to the new SQL server. The update statement you will run is:

Update [SmartConnect]..[TenantBase] set ServerName='New Server' where ServerName='Old Server'

Replace ‘New Server’ with the nameinstance of the new server, and replace ‘Old Server’ with the nameinstance of the old server.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.