changing SQL instance name with a cname, what is the effect on registered data stores?

08-16-2021 01:50 PM
New Contributor III

I.T. is wondering if they can give the SQL database instance a cname when they upgrade SQL server onto a new server. The services I have published are referencing an sde connection  from a sql instance that does not have a cname. The new instance will be aliased as the original instance.

What, if anything,  will happen to my services that use the existing registered database connections if a cname is used? Will the connection break? I am using Enterprise 10.8.   SQL server is being upgraded form 2014 to 2019.

0 Kudos
1 Reply
Esri Esteemed Contributor

In general, you can rename the server and not damage a geodatabase. Altering the database name would invalidate a registered geodatabase, though . 

You might need to change your connection files if the new name can't be found by Microsoft's connection library using the old name.

- V

0 Kudos