Sep23Written by:R Teachout
9/23/2007 3:20 PM 
Search error log for "Return value 3" and trace to find out what you're missing, then install that, then go with it.
Here's how I found and tracked my error:
I searched: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log for
Return value 3
Here was the error that returned at the end of the log
MSI (s) (3C:C4) [15:14:01:390]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 2 for SQL Server Database Services 2005 (64-bit) ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log.
And... when I searched for Return value 3 (with some digging) I found I didn't have SQL Writer / VSS components installed, so I manually installed those msi files, and then it worked correctly. Odd, but resolved. Basically, I made sure all of the proper stuff was installed (well, the stuff MS thinks is proper) and then it would install my SP2 for me correctly..
Tags:1 comment(s) so far...
Re: SQL Server 2005 SP2 Installation Error + Fix (and probably how to find other installation issues also) sweet, this worked perfectly for me. fyi, the VSS Writer install is in the Setup folder in your SQL installl disk called SQLWriter.msi. By rivers on
1/7/2010 12:05 AM
|