DO NOT INSTALL ArcSDE 10 Service Pack 2!!!

[AaronBarkhurst]

Installation of ArcSDE 10 Service Pack 2 has effectively (verifiably) broken the esri_sde service and cannot be started....rendering sde geodatabase useless without going through a direct connection. I am very disappointed and hope that there will be a remedy for this SOON!

[ForrestJones]

Hi Aaron,

It sounds like something is out of sync...Would you be able to provide the error you receive when trying to start the service, please? Also, what were the steps used to upgrade? Something like the following?

1- Install ArcGIS Desktop 10 SP2
2- Make a direct connection to the sde geodatabase as sde user
3- Run upgrade (from the workspace properties)

Did you also install the ArcSDE 10 SP2 service pack on the sde server?

Thanks,

[AlexeyTereshenkov]

Well, the steps are well outlined in the help page:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Upgrade_Geodatabase/0017000000q7000000...
and
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_ArcSDE_geodatabase_upg...

as well as at the Resource Center:
http://resources.arcgis.com/content/patches-and-service-packs?fa=viewPatch&PID=66&MetaID=1748#instal...

[AaronBarkhurst]

My sincerest apologies! I was able to work through this and get it fixed and working. This was rather frustrating when first attempting to get everything working properly and had many of our services stopped. This was however a result of an oversight on my part and NOT and issue with service pack.

[DeminHu]

I have the same issue, how you fixed ?

Thanks !!