In ArcMap 10.0, how do I find where the connection file is that is being used to connect to ArcSDE 10 on Sql Server 2008?
Some non administrative users are hooking up to SDE as the user 'sde' with db auth. The users are passed around a few mxds and I am trying to find the connection file to delete it.
If the connection file is embedded in the mxd I suppose I could use python to comb the network and individual c drives finding all the mxd that connect up with db auth and sde user.
Is there a way to block this at the db level or some other? Thanks.
Best Answer
I was working with SDE connection files today. You can search C: for .sde files, or in Win 7 you can find them in C:\%userprofile%\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\
But the layer definition will store connection info in the mxd as well. See this forum post.
In any case, like the others say, it sounds like you should change the sde password. Then the mxd layers will not connect, but you can right-click on each and Repair Data Source, or use a script like the one cited in the above forum post.