Community
Select to view content in your preferred language

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

1210
1
08-16-2021 01:50 PM
ChrisJensen
by
Regular Contributor
‎08-16-2021 01:50 PM

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
VinceAngelo
by Esri Esteemed Contributor
Esri Esteemed Contributor
‎08-22-2021 09:56 AM

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