Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

SQL Server Standard 2005 sp2 32bit running on Windows 2003 Standard 32bit service pack 2.

I attempted a service pack upgrade from sp2 to sp4 using SQLServer2005SP4-KB2463332-x86-ENU.exe and received the following error:

Property(S): UpgradeInstruction = Connect to SQL instance MYSERVER as sysadmin
Launch SQL statement USE master
Launch script file d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\sysdbupg.sql
Launch script file d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\DbEngine_hotfix_install.sql
Launch script file d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\repl_hotfix_install.sql
Stop service MSSQLSERVER
Property(S): SqlUpgradeMessage = SQL Server Setup failed to parse the SQL script "d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\DbEngine_hotfix_install.sql". The error code is The system cannot find the file specified.
. To continue, correct the problem, and then run SQL Server Setup again.

The file d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\DbEngine_hotfix_install.sql is missing and I have tried this upgrade from two different SQLServer2005SP4-KB2463332-x86-ENU.exe files.

After the service pack install completed, I was able to start SQL Server and the version was 9.0.5000. There were no other errors in the logs, but I did rollback the server using a vmware snapshot taken before installing SP4.

I googled around but didn't find anything useful.

Why would the file DbEngine_hotfix_install.sql file be missing from the service pack installation ?

share|improve this question
    
I'd try upgrading from SP2 to SP3, then SP3 to SP4, and see if that makes a difference. –  Jon Seigel Sep 13 '12 at 13:18
    
I actually did consider that shouldn't be necessary right? I'd like to understand what happened or someone tell me that sp2 to sp3 and then sp3 to sp4 is the only solution –  Craig Efrein Sep 13 '12 at 13:35
    
This user appears to have had the same issue, but I'm not sure there's anything of usefulness in the accepted answer? –  Jon Seigel Sep 13 '12 at 17:08

1 Answer 1

Almost every time I've had an SP installation issue on a stand-alone server, it was because the resource database was moved or it was not in the same directory as the master database.

Many articles I'm finding correlate your error to this exact conclusion including this one.

I would start there and if you find it to be the case, move the system databases back to where the resource database is.

If that doesn't work, try re-applying SP2. If all of the components weren't patched during the SP2 upgrade, you could experience this issue.

Lastly, verify service account permissions and permissions of the account you are running the SP4 with.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.