I have an .mxd with one dataframe that used to contained layers with data source being Oracle 11g, 10.3 Geodatabase. Database credentials were not stored in those layers/.sde connections. As expected the user was prompted to enter credentials upon opening the mxd.
Now I remove all the layers, and the user is still prompted for credentials upon opening the .mxd file. This is unexpected behavior and I need to understand why this is happening (have many such .mxd files and it's a huge problem when the .mxd's actually do store passwords.)
I stripped everything I can find from the .mxd (toolbars, layout elements, etc.). Also have run .mxd Doctor and Defrangementer. The only way to avoid the prompt for credentials is to remove the dataframe. The .mxd was created in ArcMap 10.1, using ArcMap 10.3 instead seems to make no difference.
Any clues are greatly appreciated. Thanks, Tobias
Can you try doing a SaveAs to a new filename to see if the SDE connection information is then removed from the newly saved mxd? If this works you can write a python script to automate this process by walking through the directories that contain your problematic mxds.
Could there be a SDE table remaining in the map? Change your Table of Contents to List By Source.
And if that doesn't work check out the data sources in the MXD through ArcCatalog's "Set Data Sources" thing.
No, there is not layer or table in the Table of Contents.
With ArcCatalog --> Set Data Sources I get the same information: no layers or tables in the mxd.
Like Freddie said there are some defects that are logged regarding this behavior. In order to be associated with one you will need a reproducible workflow to present to support starting with a new map document. Keep us posted if you submit a support case!