Connecting - To Be or Not To Be with ArcSDE [10.1]
631
0
06-20-2012 02:14 AM
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.
[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.
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
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.
- Right-click the database connection in the Catalog tree, point to Administration, then click Administer Geodatabase.
- Click the Connections tab.
- Choose the user connection (or connections) you want to remove.
- 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.
- Right-click the database connection in the Catalog tree and click Properties.
- Click the Connections tab.
- Uncheck Geodatabase is accepting connections.
Way to prepare client systems with ArcSDE 10.1Make 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
