Last month I blogged about the problems I had when trying to upgrade to SQL Express SP2 (and MS's refusal to let me open a support incident on it). As the Scottish Developers day draws closer and one of my presentations depended on SQL Express I decided to try to clean everything up and try again. Eventually I managed to uninstall SQL Developer Edition.

Once the machine was clean, and had I hand deleted a bunch of left over registry entries I tried the SQL Express SP2 install. It worked! Bliss. So next was installing SQL Developer Edition. This was problematic to say the least. Eventually I tracked down the problem to SQLXML; SQL Developer Edition saw there was a newer version installed and died, instead of continuing. So I uninstalled SQLXML and tried again. This time all the server components installed perfectly (although it took 2 hours). Then it tried to install the UI. No dice.

Books Online installed fine, so I have help text, but I cannot get Workbench or the BI Studio to install at all. The log files are wonderfully unhelpful;

Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.  Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe, command: /setup

Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.  Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe, command: /setup

Great. I tried running SqlWb.exe /setup and no errors appeared. Actually nothing happened. There's nothing in the event log either. So whilst I have a working SQL instance I can't manage it (well I assume it's working, after all how do you check?)

So it's time to post on the SQL Setup forum, and see if anyone actually answers and helps this time.

It's utterly stupid that I end up having to go through these hoops.

 

Technorati tags: ,