topic Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues in ArcGIS Pro Questions

ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

MollyMoore — Thu, 17 Mar 2022 12:09:37 GMT

I am using ArcGIS Pro 2.9.2 software. When I make a connection to an SDE geodatabase on our SQL Server, I can access and open the geodatabase fine until I rename the connection. Once I rename the connection file, it breaks the connection to the geodatabase.

I've never had an issue with this in my 3+ years using Pro, but I see this may have been a bug back in 2014. Is anyone else struggling with this in the 2.9 upgrade?

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

ABishop — Thu, 17 Mar 2022 12:34:28 GMT

Hello Molly,

This thread may shed light on your issue:

https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-database-connection-rename-issue/m-p/295381#M12816

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

MollyMoore — Thu, 17 Mar 2022 12:40:02 GMT

Yes, I saw this thread - it seems the same issue has re-emerged in 2.9, at least for me. None of the suggestions (using Catalog view and pane, hitting enter, etc.) solved this issue for me.

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

ABishop — Thu, 17 Mar 2022 12:47:25 GMT

Have you tried repairing your installation?

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

MollyMoore — Thu, 17 Mar 2022 13:22:17 GMT

I tried repairing and tried a full uninstall/reinstall with no luck.

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

ABishop — Thu, 17 Mar 2022 13:25:37 GMT

That's strange. I am working off the latest copy of ArcGIS Pro and I was able to go in and rename a database connection and still connect to it and all. Hmmmmm

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

Robert_LeClair — Thu, 17 Mar 2022 15:22:02 GMT

When I see strange things like this, I rename my ESRI folder to ESRI_OLD in the c:/users/<user_profile>/appdata/local and c:/users/<user_profile>/appdata/roaming - I used ArcGIS Pro 2.9.2 as well with eGDB's and don't have any issues renaming the *.sde connections.

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

MollyMoore — Thu, 17 Mar 2022 16:01:11 GMT

This is a good idea. Unfortunately, I continue to have the same issue with renaming the .sde connections.

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

ABishop — Thu, 17 Mar 2022 16:09:13 GMT

I agree with what @Robert_LeClair stated. This brings up another question for me. When you uninstalled/reinstalled/repaired your ArcPro, did you check to see if all the old folders for ArcMap and Pro were removed first before reinstalling? Sometimes fragments of these folders cause issues with certain things.

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

Robert_LeClair — Thu, 17 Mar 2022 16:30:09 GMT

So I'm testing this renaming issue. If you rename it in the Catalog Pane, it correctly renames. I did run into some error messages on the rename if I deleted the *.sde extension on the rename but not if I just rename the connection to the left of the ".sde" extension. If I rename the connection file in File Explorer and then try to refresh in the Catalog Pane it does break the link. Is this what you're experiencing?

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

MollyMoore — Thu, 17 Mar 2022 17:04:23 GMT

I'll try the reinstall again and try to make sure to delete these folders prior.

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

MollyMoore — Thu, 17 Mar 2022 17:05:52 GMT

I am using the Catalog Pane to rename and not messing with the ".sde" extension. I usually am just adding the name and version as designators to the left side of the extension.

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

ABishop — Thu, 17 Mar 2022 18:49:29 GMT

Just a hunch.... what is the naming convention you are using for the name and version? If you are using characters like (.,-_*) try to eliminate those and definitely no spaces.

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

MollyMoore — Thu, 17 Mar 2022 19:00:40 GMT

This appears to be the issue! Our organization-wide protocol is to rename connections: "<gdbname>.<version>.<servername>.sde"

This has always worked since I started in 2016, but it appears the periods are now breaking the connection file.

Thanks for troubleshooting this and giving me ideas to try!

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

ABishop — Thu, 17 Mar 2022 20:30:48 GMT

Yay! So glad it worked!

Re: ArcGIS Pro 2.9.2 SDE Database Connection Rename Issues

CarmenDurham — Fri, 24 Jun 2022 14:00:46 GMT

Molly,

I am experiencing the same issue and we have named our connections using nearly the same protocol as you since 2006 or so. I don't want to change the connection strings because they are in an awful lot of python scripts. A little annoying when you are first trying to setup a bunch of new connections in Catalog.

I have had to get around it by closing Pro, accessing the folder containing the connections string, renaming it directly and then reopening Pro.

In all cases, it seemed to truncate the rename to just <servername>.<GDBname>.sde instead of what I tried to use which was <servername>.<GDBname>.<username>.sde