Upgrading ArcSDE 10 installation to sp2

Discussion created by fraxinus on Jun 8, 2011
Latest reply on Jan 15, 2015 by jplovato
I am trying to upgrade a SQL Server 2005 setup, on 32-bit Windows Server 2003, to ArcSDE 10 sp2 - but it won't start after the service pack is applied!

All I get is:
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

And the log file says:
ArcSDE 10.0  for SQL Server Build 1343 Thu Feb 17 11:45:42  2011
Connected to instance . . .
WARNING: SDETMP: Setting temp path to c:\temp
ERROR in checking system stored procedures (1).
Run the Upgrade Geodatabase tool to install/upgrade system tables.
Refer ArcSDE installation guide for instructions.

I have tried to rebuild the service, but that doesn't help. giomgr_esri_sde.log doesn't contain anything useful.