How does .mdx file store / use .sde connection

Discussion created by tracyworden on Jan 13, 2014
Latest reply on Jan 13, 2014 by vangelo-esristaff

I have a few MXD files that have a reference to a .sde file located in a common shared directory on the hard drive of a server C:\ArcGIS\DataConnections\FileDataConnection.sde. 

The .mdx files and name of the sde file are identical across the servers, but the content of this .sde file changes on each server to point to the appropriate database. 

The mxd files are copied from one server to the next, but I am having an issue when I open the mxd file on the target server, the mxd files are still pointing to the database referenced on the server the file was copied from. 

I have verified the reference to the file .sde file is correct and have verified the .sde file is connecting to the database I expect on the server. 

Does anyone know if ArcGIS embeds the .sde connection in each layer of the mxd file and not use the data from the .sde file as I assumed it would?

Thank you