Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am trying to install SQL Server 2005 Service Pack 3 and it keeps failing. Comes back with the following:

Microsoft SQL Server 2005 - Update 'Service Pack 3 for SQL Server Database Services 2005 ENU (KB955706)' could not be installed. Error code 1603.

The detailed dump reveals the following:

MSI (s) (90:C8) [13:50:17:776]: Note: 1: 1729 MSI (s) (90:C8) [13:50:17:776]: Transforming table Error.   
MSI (s) (90:C8) [13:50:17:776]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (90:C8) [13:50:17:792]: Transforming table Error.   
MSI (s) (90:C8) [13:50:17:792]: Transforming table Error.    
MSI (s) (90:C8) [13:50:17:792]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (90:C8) [13:50:17:792]: Transforming table Error.    
MSI (s) (90:C8) [13:50:17:792]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (90:C8) [13:50:17:792]: Transforming table Error.    
MSI (s) (90:C8) [13:50:17:792]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (90:C8) [13:50:17:792]: Transforming table Error.
MSI (s) (90:C8) [13:50:17:792]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (90:C8) [13:50:17:807]: Transforming table Error.    
MSI (s) (90:C8) [13:50:17:807]: Transforming table Error.    
MSI (s) (90:C8) [13:50:17:807]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (90:C8) [13:50:17:807]: Transforming table Error.  
MSI (s) (90:C8) [13:50:17:807]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (90:C8) [13:50:17:807]: Transforming table Error.  
MSI (s) (90:C8) [13:50:17:807]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (90:C8) [13:50:17:807]: Product: Microsoft SQL Server 2005 -- Configuration failed.

Does it mean anything to anybody?

Btw, this Q originally came from SO (936895)

share|improve this question
    
i got a similar gripe from wsus about an SP I applied by hand and when I try to run it from wsus to clear it, it fails. odd. –  MikeJ Jun 1 '09 at 22:07
    
Angry- The useful part of the error message is directly above what you pasted (what you have just says that the MSI installer had a problem). Is there a <Func Name> section and/or more information about which component is failing to install (and therefore messing up the whole install)? –  Sean Earp Jun 1 '09 at 22:34
    
The Database Services part failed. –  AngryHacker Jun 1 '09 at 22:52
    
Have you re-downloaded the SP3 bits in case there was some sort of corruption? –  SQLChicken Jun 2 '09 at 13:36
    
i have found that most sql install problems differentiate slightly but all have the same route problem. better explained.. –  user74494 Mar 15 '11 at 5:40

6 Answers 6

up vote 9 down vote accepted

This fixed it for me

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic23830.aspx

Essentially:-

Remove the following registry subkeys that store SID settings:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\SQLGroup HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\AGTGroup HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\FTSGroup HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\ASGroup

share|improve this answer
    
This did the trick. Thanks. –  AngryHacker Aug 6 '09 at 16:50

This seems to be an issue when you have installed a named instance in a location other than the default - possibly in a folder named "MSSQLServer".

You might be able to move the instance to another location and complete the installation.

"MSSQLServer" is the default service name of the Database Services component.

share|improve this answer

This doesn't seem directly related, but may be worth a shot:

From MS KB 925336:

When you try to install a large Microsoft Windows Installer (.msi) package or a large Microsoft Windows Installer patch (.msp) package on a computer that is running Microsoft Windows Server 2003 or Microsoft Windows XP, you receive the following error message: Error 1718. File FileName was rejected by digital signature policy.

It's the single most common problem I've had installing Service Packs on SQL Servers.

share|improve this answer

I just encountered this problem yesterday and found a different solution.

Product: Microsoft SQL Server 2005 Express Edition - Update 'GDR 4053 for SQL Server Database Services 2005 ENU (KB970892)' could not be installed. Error code 1603.

I was able to get SP3 to install by modifying just this single registry value:

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup
    • If you have multiple instances of SQL Server installed, the key might be different for you.
  • Find the Resume REG_DWORD and change its value from 1 to 0.
  • Try installing the update again.
share|improve this answer

Make sure permission on the Microsoft SQL Server folder contained the SQLServer2005MSSQLUser$ - whether user is missing in the permissions. Also Make sure that no other service or application is automatically starting SQL Server service(s) when they are not running. Then stop the SQL Server services and install SP3 by hand.

share|improve this answer

I ran into a similar issue for 2005 SP4 on a SCOM 2007 server. The Report Server would fail on upgrade with similar issues. In this case I shutdown all SQL services and SCOM services and it ran correctly.

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.