ArcSDE 10.1 Installation, configuration, connectivity (SQL Server 2008)

Transferred from: http://blog.csdn.net/esrichinacd/article/details/8510224

1 overview

The installation configuration for ArcSDE 10.1 has some notable changes compared to ARCSDE 10.0 and earlier, such as canceling the Post Install Wizard, and many of the previous administrative operations have changed to use geoprocessing tools. Many users are not comfortable with the initial contact, this article will show you how to install, configure and connect to ArcSDE 10.1, the test database is selected by Microsoft SQL Server R2 Enterprise Edition SP3, the operating system is Windows 7 x64 SP1, the machine called AGS-02, notice that the AGS-02 firewall needs to be shut down.

2 Installing 2.1 SQL Server2008 R2 Installation

The installation of SQL Server 2008 is not much here, just a few points to note.

2.1.1 Instance Configuration

It is important to note whether you are using a default configuration or a named instance, for example, this article uses a named instance:

2.1.2 Directory Configuration

Second, note that the data store directory, the default directory is a subdirectory under the SQL Server installation directory, so if you need to store the data to another disk or path, you need to set up a data root directory, such as:

The main is the instance name and data storage path need attention, other settings in accordance with the general installation experience.

2.2 ArcSDE10.1 Installation

After you have installed SQL Server 2008, you can install ARCSDE, for example, to select a corresponding installation item:

There is nothing special about the installation of the ARCSDE software, as long as next is on the line. After you install ARCSDE, the Post Install Wizard does not pop up as before, and you need to follow the steps below to configure it.

3 Configuration

The configured machine needs to have arcgisdesktop 10.1 installed in order to use geoprocessing tools.

3.1 Creating a Geodatabase

A new "Geodatabaseadministration" toolset has been added to the toolbox, which contains several tools for geodatabase administration operations, as shown in:

Double-click to open the "Create enterprisegeodatabase" tool and enter the parameters as shown:

Parameter description:

Database Platform: This article chooses Sql_server, has no controversy;

Instance: Need to fill in the SQL Server instance name, this article is "AGS-02\ESRICD";

Database: Geodatabase name, the default is SDE, you can also fill in other names;

Authorization file: Authorization files, i.e.. ECP files, and ArcGIS Server authorization files are the same;

The other is to enter the password for the database administrator, the Geodatabase administrator.

After setting the parameters, click OK to start creating the Geodatabase, which is equivalent to the original post Install, the SDE system table is created, and so on.

After the creation is complete, you can view the results in SQL Server Management Studio, such as:

If the parameters are set correctly, you can see that the database has more than one SDE library, including the SDE system table. If an error occurs, the database connection configuration needs to be checked in addition to the input parameters, the license file, for example, the author encounters a database connection error, such as:

Because my database server is loaded with SQL Server2008 R2 Enterprise Edition and is a SP3 patch, and I am a SQL Server Express on the client, and there is no patching, the connection will fail, and creating the geodatabase will naturally fail. It is therefore necessary to ensure that the client and server versions of SQL Server are consistent and can be successfully connected.

4 connections

The Geodatabase has been created successfully, and then you can connect to the Geodatabase. Direct Connect is recommended in ArcGIS 10.1, so the SDE system service is not created by default.

4.1 Direct Connect

Direct connect connection is relatively simple, under "Database Connections" double-click "Add Database Connection", such as:

Pop up the Direct Connect parameter Settings window and set the direct connection parameters, such as:

Note the instance here, and the need to create a geodatabase consistent, and then select the Geodatabase to connect to, enter the user password, click OK, you can connect, such as:

Now it's empty, and then we'll test the Shapefile feature class into this SDE library with the following results:

Indicates that the direct Connect method is already working with the ARCSDE library.

4.2 Service Connections

In addition to the recommended direct connection, there are times when we need to create an ARCSDE service and then connect to the Geodatabase in the same way that the. SDE connection file is used by the client.

4.2.1 Creating an ARCSDE service

There are three main steps to creating an ARCSDE service: Manually modifying Service files, command-line installation Services, and starting services.

The first is to manually modify the service files, including the ArcSDE service.sde files and the Windows system service files, as in the following two graphs:

In these two files, add "Esri_sde 5151" separately and save as shown in:

Then use the command line to create the ARCSDE service, this example command line is as follows:

Sdeservice-o create-d sqlserver,ags-02\esricd-psde-i Esri_sde

The execution results are as follows:

After the creation is successful, the service can be started with the following command line:

Sdemon-o start-i esri_sde-p SDE

After execution, you will be asked to enter the SDE user password, which can then be started, as shown in:

The SDE service is started and can then be connected by service mode.

4.2.2 Creating a service Connection file

First find the "Create ArcSDE Connection File" tool, as shown in:

Open the tool and enter the parameters as shown in:

Here you need to set the machine name or IP where the SDE service is located (in this case, AGS-02), the SDE service name (in this case, ESRI_SDE or 5151), and enter the database name (in this case, SDE) and the username password.

Click OK to complete the creation of the. SDE Service connection file, then locate the connection file in the specified directory, double-click to connect to the Geodatabase, as shown (the data imported in the direct-attached test is clearly visible):

Explains how the service connection is working correctly with the ARCSDE library.