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

Blog Post created by PWaldron-esristaff Employee on Jun 20, 2012
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.]Disconnect-300x183.jpg

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.
NotAcceptingPics-300x193.jpgWay 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