topic Re: Python Script to Disconnect all users from a database in Python Questions

Python Script to Disconnect all users from a database

BenDrury — Fri, 09 May 2014 17:21:45 GMT

I am not very Python savvy... trying to develop a script to disconnect all users from a 10.2.2 SDE database. Can anyone tell me what I'm doing wrong?

import arcinfo

import arcpy

# Variables:
sde_TestServer = "\\\\computer\\c$\\Users\\user\\AppData\\Roaming\\ESRI\\Desktop10.2\\ArcCatalog\\sde@TestServer.sde"

#Disconnect Users
arcpy.DisconnectUser ("sde_TestServer", "ALL")

THANKS!

Re: Python Script to Disconnect all users from a database

JoshuaChisholm — Sat, 11 Dec 2021 06:36:02 GMT

You are python savvy Katherine! You're only missing one thing: take the quotes away from sde_TestServer. Like this:

import arcinfo
import arcpy

# Variables:
sde_TestServer = "\\\\computer\\c$\\Users\\user\\AppData\\Roaming\\ESRI\\Desktop10.2\\ArcCatalog\\sde@TestServer.sde"

#Disconnect Users
arcpy.DisconnectUser (sde_TestServer, "ALL")

The reason: if python sees "sde_TestServer" it reads it as the string "sde_TestServer". If python sees sde_TestServer it looks for a variable that was previously set using that name.

Re: Python Script to Disconnect all users from a database

AimeiChen — Tue, 21 Oct 2014 14:52:14 GMT

Hi, Josh

Id like to have this handy tool as well. But I was running into an error, says Connection information provided was for a non-administrative user. But the user "msdgc" can disconnect user from ArcCatalog. would you please help, thanks!

Amy

import arcinfo
import arcpy

# Variables:
sde_Server = "c:\\Users\\user\\AppData\\Roaming\\ESRI\\Desktop10.1\\ArcCatalog\\msdgc@msdtest.sde"

arcpy.DisconnectUser(sde_Server, "ALL")

Traceback (most recent call last):

File "C:\Program Files (x86)\SystemScheduler\disconnectuser.py", line 8, in <module>

arcpy.DisconnectUser(sde_Server, "ALL")

File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\__init__.py", line 1040, in DisconnectUser

return gp.disconnectUser(sde_workspace, users)

File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\geoprocessing\_base.py", line 498, in <lambda>

return lambda *args: val(*gp_fixargs(args, True))

RuntimeError: Connection information provided was for a non-administrative user

Re: Python Script to Disconnect all users from a database

BenDrury — Tue, 21 Oct 2014 18:32:22 GMT

Are you using a SDE user Connection to establish this? It needs to be either the SDE user or possibly the SA user for it to work properly, preferably the SDE user

Re: Python Script to Disconnect all users from a database

AimeiChen — Fri, 24 Oct 2014 16:37:39 GMT

I switched to SDE user but still got same error message. Thanks!

Re: Python Script to Disconnect all users from a database

AsrujitSengupta — Fri, 24 Oct 2014 19:02:17 GMT

Does the sde user have "processadmin" fixed server role?