I'm having issues getting WMX to work after moving everything to a new server (server1 to server2).
I've tried the post install and its output looks like this:
Unable to update GUIDs on table WMX.JTX_ACTIVITY_TYPES
Upgrade failed: Exception from HRESULT: 0x80040354
I can connect to the database and see everything with ArcCatalog.
But in the workflow administrator when the wmx account on server1 is unlocked working with wmx on server 2 works, but when locked on server1, server2 fails connecting.
I checked the help files but had no luck finding anything that would help me move wmx tables to a different server.