It seems that SQL Server 2005 won’t upgrade properly to SP1 if you have both SQL Server 2005 and SQL Server Express Edition installed on the same machine. The installation will stop while trying to setup “SQL Server Setup Support”.
The solution is pretty simple according to this Microsoft Knowledge Base article. In our case, you can jump directly to Method 2 and follow the steps outlined.
Leave a Reply