Connecting – To Be or Not To Be with ArcSDE [10.1]

Are you working to put together a migration plan for the transition to ArcSDE 10.1?  There are some new changes for connecting and disconnecting users with ArcSDE 10.1!

Good to Know

One of the more significant changes with ArcSDE 10.1 is that the default means of connecting to the geodatabases is via Direct Connections. And gone is the script, i.e. sde:sqlserver:servername, replaced by simply providing the instance name where the RDBMS resides.

[Note:  ArcSDE service connections are still available through the use of geoprocessing tools or Python script to connect to an enterprise geodatabase.]

The geodatabase administrator can now disconnect users from a geodatabase from the Connections tab on the Administer Geodatabase dialog box in ArcGIS for Desktop.

  1. Right-click the database connection in the Catalog tree, point to Administration, then click Administer Geodatabase.
  2. Click the Connections tab.
  3. Choose the user connection (or connections) you want to remove.
  4. Right-click the connections and click Disconnect.

[Please note, the geodatabase administrator may need to be granted certain permissions to do this, e.g., for SQL Server the administrator must be added to the processadmin fixed server role.]

And for administrators, there is a new tool that allows you to prevent connections during those times when you need to perform maintenance.

  1. Right-click the database connection in the Catalog tree and click Properties.
  2. Click the Connections tab.
  3. Uncheck Geodatabase is accepting connections.

Way to prepare client systems with ArcSDE 10.1

Make sure you have the correct RDBMS client for your Windows client systems. One way to download the correct RDMBS client is through your Esri Customer Care Portal downloads folder. All of the supported RDBMS clients are located in the Software Downloads section under the DBMS Support Files link.

Phillip W – Geodata Support Analyst


This entry was posted in Geodatabase and tagged , , . Bookmark the permalink.

Leave a Reply

3 Comments

  1. cookeville says:

    I was really looking forward to taking advantage of this new feature!! However, when I click the username under the connections tab and click disconnect…I get an error message that says “DBMS does not support this function”…

    We use postgresql 8.3. Is this function going to be supported on postgresql?

  2. mrs_robbins says:

    I would like to use this feature within a model (preferably) or a script. Is there or will there a tool created? Is there any automated way to do this?