arcsde/sdelayer failing to log into sqlserver

BobBoey — Mon, 19 Jul 2010 18:00:37 GMT

I'm working my way through ArcGIS Server Enterprise Configuration and Tuning for SQL Server. Sdelayer will not connect, giving me a bad login user error (-9). I'm logged in as the administrator account, with SQL Server set up to accept mixed authentication. The giomgr_esri_sde log file lists this:
Mon Jul 19 13:45:37 2010 - ****** Spatial Database I/O Manager ******
Mon Jul 19 13:45:37 2010 - SDE System Startup Initiated . . .
Mon Jul 19 13:45:37 2010 - Validated System Paths.
Mon Jul 19 13:45:37 2010 - SDE IOMGR going into background . . .
Mon Jul 19 13:45:37 2010 - System Parameter table 'SERVER_CONFIG' Read.
Mon Jul 19 13:45:37 2010 - Initialized Shared Memory Segment.
Mon Jul 19 13:45:37 2010 - Validated License.
Mon Jul 19 13:45:37 2010 - IOMGR Process ID (PID):           4200
Mon Jul 19 13:45:37 2010 - Initialized Client Tables.
Mon Jul 19 13:45:37 2010 - Server Validated.
Mon Jul 19 13:45:37 2010 - Waiting for Client Requests . . .
Mon Jul 19 13:48:18 2010 - Error (-9):Couldn't Start Server Task.

Mon Jul 19 13:48:18 2010 - Process 3840, no shared information block established

Mon Jul 19 13:48:18 2010 - SDE Server 3840 exit'd with status 3

and sde_esri_sde log lists this:

Connected to instance . . .
DBMS Connection established...
RDBMS:     "SQL Server"
Instance Name:    "esri_sde"
IOMGR Process ID (PID):           4200

IDBInitialize::Initialize Failed
CAN'T OPEN INSTANCE: esri_sde.
Spatial Engine Connection Failed (-9).
Cannot Get Access to Instance esri_sde
[Mon Jul 19 13:48:18 2010] [0] [GIOMGR] Error (-9):Couldn't Start Server Task.

I understand that authentication is getting rejected, but I do not know where. I even tried forcing the dbinit file to the sde user name and password, but that did not work.

I'm running everything on one machine, which is running Windows 7.

Re: arcsde/sdelayer failing to log into sqlserver

AlanStearns — Mon, 26 Jul 2010 19:28:01 GMT

I've been having the same problem since upgrading our raster geodatabase to 9.3.1. Every week or so, the giomgr service will stop accepting connections and I am unable to stop or restart it without first killing all the existing app server connections. It's a Linux box, so I use "ps -ef | grep sderas" to locate all the existing app server connections (sderas is the name I assigned to the port) and then the "kill {pid}" command to terminate the connections. The non-raster geodatabases are fine.

topic Re: arcsde/sdelayer failing to log into sqlserver in Data Management Questions

arcsde/sdelayer failing to log into sqlserver

Re: arcsde/sdelayer failing to log into sqlserver