ArcSDE 10.1 service, esri_sde, creation failed

[xiannianchen]

Hi, friends,

I am doing MS SQL Server (2012 version) based ArcSDE (10.1). I followed the installation guide to do create and start the service. But when I started the service, it is always failed. No matter what I do, I always get the error message of "The ArcSDE Service (esri_sde) service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs".

Since I am following the installation guide and I want to create the service on the local server machine, I want to ask experts questions based on the steps.

1. for creating the service, I use the default service name, which is esri_sde. My machine name is TEST1, and the SQL Server instance name is: MSSQLSERVER.
In the sample command line: sdeservice -o create -d SQLSERVER,MYSERVER\SSINSTANCE -i sdesvc -p keepout
For the d parameter, if I use TEST1\MSSQLSERVER, it gives me the error message: Database service MSSQL$MSSQLSERVER does not exist. Use option -n to exclude MSSQL$MSSQLSERVER from ArcSDE dependent service..
If I use only machine name, it works.
For me, the working command line is: sdeservice -o create -d SQLSERVER,CATEVAC2 -p keepout.

2. for register operation of ADMIN_DATABASE , the sample command is:
sdeservice -o register -d SQLSERVER,MYSERVER\SSINSTANCE -r ADMIN_DATABASE -v mygdb
In my case, I changed MYSERVER\SSINSTANCE to TEST1.
My questions are: what is ADMIN_DATABASE?
How to set it? There is no database mygdb in the instance.
Should this database pre-exist? I created a sde database by using the Database Management Studio, and I changed "mygdb" to "sde".
So, in my case, the register database opertion command line is:
sdeservice -o register -d SQLSERVER,TEST1 -r ADMIN_DATABASE -v sde

3. for register operation of SDE_DBA_USER, the sample command is:
sdeservice -o register -d SQLSERVER,MYSERVER\SSINSTANCE -r SDE_DBA_USER -v "localhost\network service" -i sdesvc
I changed MYSERVER\SSINSTANCE to TEST1 and removed -i sdesvc since I want to use the default service name. So, my working verion of command line is:
sdeservice -o modify -d SQLSERVER,TEST1 -r SDE_DBA_USER -v "localhost\network service"


In my case, three commands were executed successfully. But when I tried to start up the esri_sde, I got error messages as I mentioned before.

Any else setting that I left out?

Thanks for any help.

-Mike

[BubbaHey]

I'm not that familiar with SDE, but this may help:
http://blogs.esri.com/esri/supportcenter/2012/06/20/connecting-to-be-or-not-to-be-with-arcsde-10-1/

[AbhijitSarkar]

Here are the steps if it's sde schema geodatabase:

i) Write the unique ArcSDE service name and port number (example: esri_sde   5151/tcp) in SDEHOME/services.sde and windows service file (located at C:\Windows\System32\drivers\etc\services)

ii) Make sure the SDEHOME is set (echo %SDEHOME%) correctly. if not "set SDEHOME= 'correct SDEHOME path'"

iii) execute the following command: sdeservice -o create -d SQLSERVER,SQLSERVERINSTANCE -p <password> -i 5151

iv) then execute "sdeservice -o register -d SQLSERVER, SQLSERVERINSTANCE -r ADMIN_DATABASE -v <Database Name> -i 5151"

v) Try starting the service from windows service panel.

ADMIN_DATABASE would write on the windows registry regarding the database value for that ArcSDE service. That's how you would know that 5151 service is running/registered for which database.

I hope this helps. Let us know how it goes.

Thanks..

[xiannianchen]

Thanks, first.

But, basically, that's about the same as the installation instruction, except the service name is 5151 other than the default name of esri_sde.

I did try your suggestion. The service can't be started. The same error message appeared again.

Any other suggestions?

Thanks,

Mike

Here are the steps if it's sde schema geodatabase:

i) Write the unique ArcSDE service name and port number (example: esri_sde   5151/tcp) in SDEHOME/services.sde and windows service file (located at C:\Windows\System32\drivers\etc\services)

ii) Make sure the SDEHOME is set (echo %SDEHOME%) correctly. if not "set SDEHOME= 'correct SDEHOME path'"

iii) execute the following command: sdeservice -o create -d SQLSERVER,SQLSERVERINSTANCE -p <password> -i 5151

iv) then execute "sdeservice -o register -d SQLSERVER, SQLSERVERINSTANCE -r ADMIN_DATABASE -v <Database Name> -i 5151"

v) Try starting the service from windows service panel.

ADMIN_DATABASE would write on the windows registry regarding the database value for that ArcSDE service. That's how you would know that 5151 service is running/registered for which database.

I hope this helps. Let us know how it goes.

Thanks..

[AbhijitSarkar]

Can you post the following: sdeservice -o list -i 5151 ?