Monday, September 25, 2006

SQL Server 2005 SP1

I had a wierd problem trying to install SP1 on SQL Server 2005 today...

Originally I had the upgrade file (SQLServer2005SP1-KB913090-x86-ENU.exe) on an external USB hard drive, I found that I had to copy the file from an external USB hard disk to my local machine and then remove the external USB drive from my system for the install to work. Before I removed the USB drive the upgrade tool was putting the unpacked files on the USB drive (probably as it had most free space) and for some wierd reason they would not install from there. Once the USB drive was removed the installer unpacked the files to drive D: and the installer worked fine.