Summary of Database Registration problems encountered when ArcGIS Server 10.1 released the element Service (I)

Yesterday, the ArcGIS Server was upgraded to 10.1, And the 10.0 service had to be re-built. It took three days to complete. However, the oldest issue was that when I published the element service, the database registration problem had plagued me for two days .... now, let's summarize the problems that have been encountered so that people who have encountered the same problems as me can have a reference and take less detours. Some unsolved problems will also be mentioned in this article, I also hope that the great gods who pass by can solve the problem and help you give pointers. I am very grateful.

 

Working environment of this article:

Windows 7 64-bit flagship Edition

ArcGIS Server 10.1

ArcGIS Desktop 10.1

In IIS 7.0

At the beginning, we thought that 10.1 was the same as 10.0, and we needed to install ArcSDE. Later, we checked the information and found that we didn't need it. We just needed to directly connect the database.

 

First, let me talk about the process of releasing the element service. Here we follow this article:

Http://blog.csdn.net/arcgis_all/article/details/8202684

According to the process in this article, the previous process is correct.

However, the following error always occurs during analyze:

Severity Status Code Description name type data frame
High unresolved 00090 feature service requires a registered database layers data frame Layers

Although I have registered the geographical data here, the following registration information is displayed when I double-click an error:

Click to view the connection properties as follows:

After reading the materials for half a day, I posted a help post in ESRI and asked for help in the group. After two days, I finally found a solution:

Method 1: Open the windows service list, stop ArcGIS Server, click Properties, and change its logon identity to a local logon identity:

Then start the service. Then, when publishing a service to register a database, select the operating system authentication in the database connection settings:

Click OK to register the connected database connection as follows:

Remember to check the same as publisher Database Connection check box. Then, the database authentication method for serevr database connection is operating system authentication.

Click OK. Finally, click analyze to find that the error has not been found. Then click Publish to publish it successfully.

Solution 2:

The login method of ArcGIS Server is ArcGIS Server account, as shown in:

The difference is that the Database Registration Section.

Here, the database connection settings are still the operating system authentication method.

Click Edit in the server database connection box, select the database authentication method in the authentication type, and enter the user name and password. Generally, the user name is SDE and the password is set by yourself. As shown in:

Click OK to return to the registered database page,

The method here is different: Server database connection. Remember not to check same as publisher database connection

Geodata service can be selected or not. In this article, ArcGIS Server already exists, and geodata service is displayed in the gray check status.

Do not check same as publisher database connection. Otherwise, the following error occurs:

Note: In the reference text given at the beginning of the article, it selects same as publisher database connection, but I have never succeeded on my own machine. I don't know why I want to be confused.

That is, the ArcGIS Server cannot access the database.

Click analyze to solve the error and click Publish.

Solution 3:

All of the above are registered databases. Here we choose to register managed databases. For more information about the process, see

Http://blog.csdn.net/arcgis_all/article/details/8202631

A good example is provided here. After the editing element is registered as a managed database, click analyze. The error is also fixed. click Publish to publish it successfully.

 

Summary:

Solution 1 and solution 2 databases are directly registered with ArcGIS Server. The difference is that the identity of ArcGIS Server login. One is the local system and the operating system logon identity (Windows identity), and the other is the ArcGIS Server user identity. We recommend that you log on as the ArcGIS Server account. This mainly takes into account that the windows identity logon fails during the distributed installation of ArcGIS Server. However, Windows identity logon is more secure than ArcGIS Server account logon because it adopts a certificate-based security mechanism.

Here we will also find that there are some differences between serevr database connection and publisher database connection.

Method 1: Because ArcGIS Server uses a local system account, all serevr database connections are the operating system authentication method.

In method 2, because ArcGIS Server uses the ArcGIS Server account identity to log on, serevr database connection adopts the database authentication method.

The publisher database connection method is the operating system authentication method.

Although publisher database connection can be successfully registered when the database authentication method is used, the error message indicating that the database is not registered is still displayed when the element service is released.

 

Solution 3: hosted registration is used. At this time, the geographic database will copy to the ArcGIS Server, which is generally not recommended because when the database is large, the copy operation will take up a lot of space.

The above is a summary of the problem. I personally think that the ArcGIS Server still has the permission to access the database, but I have never understood the mechanism. Write so much for now!

ESRI Reference documents:

Http://resources.arcgis.com/zh-cn/help/main/10.1/index.html#/na/015400000505000000/

Http://resources.arcgis.com/zh-cn/help/main/10.1/index.html#//00sq000000m4000000

Http://resources.arcgis.com/zh-cn/help/main/10.1/index.html#/na/01540000039r000000/

ESRI video:

Http://video.esri.com/watch/1545/registering-database-data-with-arcgis-101-for-server

 

(Copyright. indicate the source for all reposts)