Re-install SSE on 8.12 Deployment Server

The SSE engine on a 8.12 won't start. I think my best option is to detach the databases and re-install SSE then reattach the databases.

Anyone here ever just re-installed SSE without uninstalling and re-installing all of JDE on the deployment server?

Mike,

Give these instructions a try.

After you detach the databases -

From add/remove programs....

Uninstall Microsoft SQL Server 2005/2008
Remove instances one at a time. Most likely you will have a deafult SQLSERVER instance and a JDESSELocal instance.

Uninstall SQL Native Client

Uninstall Setup Support Files

Uninstall VSS Writer

Uninstall MSXML 6.0 Parser

Delete entire Microsoft SQL Server directory from x:\Program Files,
then reboot

Install SQL Server 2005 from x:\JDEdwards\E812\OneWorld Client
Install\ThirdParty\SSE\SQLEXPR.EXE

Choose default instance.

Run this command in a command prompt from this location:
x:\jdedwards\e812\oneworld client
install\thirdparty\SSE>DotNetSSESetup.exe -PSaSaSa11 -IJDESSELocal

Run this command from this location:
e:\jdedwards\e812\system\bin32>ReconfigureMSDE.exe -TSSE
-I(local)\JDESSELocal -pSaSaSa11

Run SSE_attach_planner.bat
Run SSE_attach_metadata.bat

Thanks for the response but I found out that we are actually using MSDE on the deloyment server. Do you have similar instructions for MSDE rather than SSE?

I would then suggest migrating from MSDE to SSE. There are instructions on the Oracle support site that detail the process.

Per CNCjunior's suggestion, I would migrate to SSE from MSDE. I do not have similar instructions with MSDE.