We Changed our server/instance name that contains our sde databases. As a result all of our connections in MXD/aprx documents are broken. I've used the arcpy.findAndReplace data connections module in python and the template script offered by ESRI, however the links are still broken. My thought is the actual data source "Database Connections/prod.sde" isn't what was changed, it was the server or instance name that can be found using layer -->properties.
Any thoughts on what layer or MXD property needs to be accessed in python to update a new server name? Also need to do it for Pro documents.
Any help is appreciated!