Error installing SQL Server 2005 SP3 - Setup Support Files

I just came across an annoying problem when trying to upgrade MS SQL 2005 my development server to SP3. Whatever I did it would fail on the first step of the process - "Setup Support Files". Here's the lines from the log file the patch created:

MSI (s) (B0:C8) [15:22:37:703]: Source for file 'ExceptionMessageBox.dll.476E40C2_BF50_44F5_B79F_85F11E8470B6' is compressed
MSI (s) (B0:C8) [15:22:38:328]: Note: 1: 2360 
MSI (s) (B0:C8) [15:22:38:328]: Note: 1: 2360
MSI (s) (B0:C8) [15:22:38:328]: Note: 1: 2360
MSI (s) (B0:C8) [15:22:38:328]: Note: 1: 2360
MSI (s) (B0:E0) [15:22:38:343]: Assembly Error:Version %d.%d is not a compatible version.
MSI (s) (B0:E0) [15:22:38:343]: Note: 1: 1935 2:  3: 0x80131107 4: IStream 5: Commit 6:  
MSI (s) (B0:C8) [15:22:38:343]: Note: 1: 1304 2: Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
MSI (s) (B0:C8) [15:22:38:406]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 1304. Error writing to file: Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll.  Verify that you have access to that directory.

Error 1304. Error writing to file: Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll.  Verify that you have access to that directory.

This is the core error here:

MSP Error: 1304  Error writing to file: Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll.  Verify that you have access to that directory.

I did a lot of searching but just couldn't find out what could be causing this or how to fix it.

I eventually discovered that the problem was down to the version of .NET I had installed. I *think* I was running the old V1.1 of the .NET assemblies as I had to downgrade to get something running on an ASP website.

Anyway, I installed the latest version of .NET - V3.5 and restarted the SP3 install and it went through without problem.

It's annoying that on the download page for SP3 there is no mention that you need an updated version of .NET installed or that that patch doesn't even tell you! Another Microsoft oversight that has wasted a few hours of my life!

I am assuming this would have worked fine if I had upgraded to V2 of .NET as well.

You can get the latest .NET installer from here

How to get Microsoft Script Debugger to work in IE7 on Vista

I've just come across a problem when installing the Microsoft Script Debugger in IE7 on Vista.
It installs fine, but as soon as I restart IE the browser hangs. I then had to kill the IE task.

At this point an 'Internet Explorer Security' error popup appeared:

I then clicked 'Allow'. However, upon restarting IE it hung again.

Very frustrating until I realised the simple solution. All you have to do is run the browser, let it hang and then kill it. When the above popup appears, tick the box which says 'Do not show me the warning for this program again' and then click 'Allow'.

Now, when you start IE it will start fine without the hang and debugging working perfectly.

Annoying that this is the way to get it to work but at least there is a workaround.

I am running Vista x64 Ultimate for what it's worth.

By the way, if you do any development with IE 7 and Javascript you NEED 'My Debug Bar' - www.my-debugbar.com. It add's a FireBug type debug interface to IE which lets you debug Javascript without the need to drop into the awful Microsoft Visual Debugger thing. The same guy also develops DebugBar which is also a fantastic piece of kit for adding comprehensive debugging to IE.

© 2014 James Allen | Contact Me
This blog runs on the awesome power of BlogCFC - created by Raymond Camden. This blog is running version 5.9.