topic Error using sdemon in Data Management Questions

Error using sdemon

RonVincent — Thu, 15 May 2014 19:55:38 GMT

I'm just trying to create a test GDB using SQL Server Express 2008 R2 with ArcSDE 10.2. I can direct connect just fine but I'd like to be able to export out the DBTUNE table using sdedbtune so I've tried creating the SDE service using sdeservice. It works without error. However, when I go to start the service using sdemon I get this error:

esri_sde service failed during initialization.
Please check event log or error log files.
Error starting esri_sde service(0)
Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.

In the log file I'm seeing this error:

-------------------------------------------------------
10.2 geodatabase
-------------------------------------------------------
Failed to connect. Denali error: 18456, [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sde'.
2008 error: 18456, [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sde'.
2005 error: 0, IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
init_DB DB_instance_open_as_dba: -93
DBMS error code: 18456
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sde'.

The SDE user exists and I can log in using it from ArcCatalog and SSMS.

Any ideas?

Thanks,

Ron

Re: Error using sdemon

AsrujitSengupta — Thu, 15 May 2014 20:11:12 GMT

Why not use the Direct Connect syntax to export out the dbtune file? Even that will so the same thing.

sdedbtune -o export -f 'location where the file would be exported' -i sde:sqlserver:sqlserver_instance_name -D database_name -u sde -p sde_password

example:
sdedbtune -o export -f c:\dbtune.sde -i sde:sqlserver:db_server\sqlexpress -D test_gdb -u sde -p sde

Re: Error using sdemon

RonVincent — Fri, 16 May 2014 11:53:56 GMT

Why not use the Direct Connect syntax to export out the dbtune file? Even that will so the same thing.

sdedbtune -o export -f 'location where the file would be exported' -i sde:sqlserver:sqlserver_instance_name -D database_name -u sde -p sde_password

example:
sdedbtune -o export -f c:\dbtune.sde -i sde:sqlserver:db_server\sqlexpress -D test_gdb -u sde -p sde

That worked. Thanks.

Re: Error using sdemon

AsrujitSengupta — Fri, 16 May 2014 13:10:31 GMT

Great! .