The server administrator (dbo) can disconnect users from a geodatabase. To do so, the server administrator must open the Connected Users tab of the Geodatabase Administration dialog box, which is accessed from the context menu of a database connection. Therefore, the server administrator must save a connection to the individual geodatabase to access this menu.
When your database server is licensed through ArcGIS for Desktop or ArcGIS Engine, the number of connections that can be made to the database server is limited. If a user leaves a connection open and idle for a long period of time, you might need to drop that user's connection so someone else can connect and work.
To remove a connection from a geodatabase that is on a database server, follow these steps:
- Log in to the machine where ArcGIS for Desktop is installed as a user who is a server administrator on the database server.
- Connect to the database server in the Catalog tree.
- Right-click the geodatabase from which you want to disconnect users and click Save Connection.
A connection to the geodatabase is created under the Database Connections node.
- Expand the Database Connections node, right-click the new connection, point to Administer, and click Administer Geodatabase.
- Click the Connections tab.
The sessions currently connected to the geodatabase are listed. Your own connection appears in italics. If the same user is connected to the database server from multiple clients, the same user can appear multiple times in the connected users list.
- Choose the user connection (or connections) you want to remove.
- Right-click the connections and click Disconnect.
An error message is returned if you do not have the privileges required to disconnect users. An error message is also returned if you attempt to remove your own connection.
The session is dropped and all locks that session held are also dropped. When the user attempts to use the session, an error message is returned indicating that the server is inaccessible or that there is a network I/O problem.