Using SQL Enterprise Manager, open up your CCM03XX database. Go into Tables, and find the table named 'Scratch'. Right-click on it, pick Open Table, and pick Return All Rows. There are a lot of lines in this table. The ones you're looking for have 'IPMA-WIZARD-RUN-STATUS' and 'IPMA-STATUS' in the Name column. Delete these rows. There could be multiple instances of them - there is on my database, but I'm pretty sure that's due to me hacking around. At any rate, be sure you kill all instances of those lines.
This will delete all the information that the IPMA Wizard stores on whether or not it's been run and what it was run with.
When you go to Service|Service Parameters|Cisco IP Manager Assistant. The SUB should be the primary.
If you are getting an error when using PUB but connects using SUB, its completitley normal, since IPMA service will be active only in one server at a time.
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.