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.