Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

share|improve this question
2  
I am pretty sure the connection information is embedded in the mxd. As for db level changes, anything that breaks their connection could break the SDE user's abilities as well (i.e. don't disable the sde account). Easiest way might be to change the SDE user's password. –  Michael Todd Sep 4 '12 at 20:21
1  
+1, time to change that password and pronto. –  blah238 Sep 4 '12 at 21:59

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer
1  
And, for 10.1 users, they are located in: C:\%userprofile%\AppData\Roaming\ESRI\Desktop10.1\ArcCatalog\ –  Michael Todd Sep 5 '12 at 21:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.