topic arcpy.DisconnectUser is throwing this error - RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection in Python Questions

arcpy.DisconnectUser is throwing this error - RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection

BenVan_Kesteren1 — Sun, 12 Dec 2021 00:01:23 GMT

Hi All,

I have three different levels of database connection in ArcCatalog on my PC which I use to connect to our Enterprise GDB for various reasons.

I have my user level connection for data editing.

I have one called GISADMIN which is the Data Owner.

And another with is called SDE which is the Geodatabase Admin User.

I have no access to the Database Admin User, this is managed by our in house I.T Dept.

I am trying to use the arcpy.DisconnectUser function in a python script, but no matter which of the connections mentioned above I use, I get the following error:

>>> arcpy.DisconnectUser(r'Database Connections\SDE@SDE_Spatial@SDE-DB.sde',123494)
Runtime error 
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\__init__.py", line 1086, in DisconnectUser
    return gp.disconnectUser(sde_workspace, users)
  File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\geoprocessing\_base.py", line 504, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection
>>> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I have confirmed this by trying to use all three connections, also trying to disconnect several different connections from my Enterprise GDB.

Something strange is that if I put a completely random session ID in my python snippet, the exact same error is returned....

I am perplexed as to why this is happening to me, and I am unable to track down why this seems to have started happening all of a sudden.

Anyone have any troubleshooting ideas for me?

Nathan Duncan‌

Cheers

-Ben

Re: arcpy.DisconnectUser is throwing this error - RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection

BenVan_Kesteren1 — Mon, 19 Dec 2016 23:56:11 GMT

Just to close off my own question, it turns out that for some reason the permissions had changed on my Geodatabase Admin (SDE) User and this was causing the problem.

I had to elevate to my in house IT Dept to resolve.

Re: arcpy.DisconnectUser is throwing this error - RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection

DonnaRiebe — Fri, 18 Aug 2017 14:46:43 GMT

This same thing happened to me. I suspect the solution will be the same.

Re: arcpy.DisconnectUser is throwing this error - RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection

BenVan_Kesteren1 — Sat, 19 Aug 2017 02:30:39 GMT

I believe what happened is that our IT team audited the SQL Server permissions and noticed our SDE account had quite high privileges, and as I am not located 'within' the IT team this is against business rules, so they revoked my access as SDE Admin, which in turn caused this error to rear its head.

Once my IT team restored previous permissions all was good again.

Cheers

Re: arcpy.DisconnectUser is throwing this error - RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator conn

LDreyfuss — Sat, 08 Mar 2025 00:37:31 GMT

I know this was quite some time ago now, but any idea what permissions were restored to the SDE user? I'm getting the same error using the arcpy.DisconnectUser, only this time on a 10.9.1 geodatabase.