Install errror in SQLServer 2005 SP1

I have a error instaling SP1 for SQLServer 2005 Standard Edition Spanish.

The log is the following:

.....

Doing Action: SetInstanceProperty
PerfTime Start: SetInstanceProperty : Wed Apr 26 16:02:31 2006
<Func Name='SetInstanceProperty'>
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlOriginalMachineName property. Its value is 'WS03'.
MSI (s) (48!D0) [16:02:31:827]: PROPERTY CHANGE: Adding SqlLegacyRegPath property. Its value is 'MSSQLServer'.
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding PreviousInstId property. Its value is 'MSSQL.1'.
Using instanced id: MSSQL.1
MSI (s) (48!D0) [16:02:31:859]: PROPERTY CHANGE: Adding InstId property. Its value is 'MSSQL.1'.
Previous instance id: MSSQL.1
Using instance name: MSSQLSERVER
MSI (s) (48!D0) [16:02:31:890]: PROPERTY CHANGE: Adding PrevRegRootPath property. Its value is 'Software\Microsoft\Microsoft SQL Server\MSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding Sql2KSxS property. Its value is '1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceName.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'MSSQLSERVER'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixRS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005ReportServerUser$WS03$'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServicePrefixSSIS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005DTSUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'RIEDER\SQLServer2005SQLBrowserUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding QuotedServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'RIEDER\SQLServer2005MSSQLServerADHelperUser$WS03'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding InstanceRegKey.2C8E638F_C982_4AA5_A173_7148A8E8649D property. Its value is 'Microsoft SQL Server\MSSQL.1'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding DataInstanceTxt.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'C:\Archivos de programa\Microsoft SQL Server\MSSQL.1\MSSQL'.
MSI (s) (48!D0) [16:02:31:921]: PROPERTY CHANGE: Adding ServiceNameSQL.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'MSSQLSERVER'.
Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No se ha efectuado ninguna asignación entre los nombres de cuenta y los identificadores de seguridad.
Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Mon Feb 27 02:04:14 2006
Function Name: SetInstanceProperty
Source Line Number: 1223

MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:937]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:937]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 1332
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Transforming table Error.

MSI (s) (48!D0) [16:02:31:952]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48!D0) [16:02:31:952]: Producto: Microsoft SQL Server 2005 -- Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.

Error 29528. El programa de instalación ha detectado un error inesperado al Estableciendo propiedades internas. El error es: Error grave durante la instalación.
.
<Failure Type='Fatal' Error='1332'>
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='0'>
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (48:9C) [16:02:31:952]: Transforming table InstallExecuteSequence.

MSI (s) (48:9C) [16:02:31:952]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
La acción terminó a las 16:02:31: SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Valor devuelto: 3.
La acción terminó a las 16:02:31: INSTALL. Valor devuelto: 3.
Property(S): ProductCode = {FD515EB7-E1C3-4278-9EC2-047672A8B718}
Property(S): ProductLanguage = 3082
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 9.1.2047.00
Property(S): MEDIAPACKAGEPATH = \Setup\
Property(S): ALLUSERS = 1
Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000}
Property(S): ASPNetVersion = 2.0.50727
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152
Property(S): ARPPRODUCTICON = ARPIcon.ico
Property(S): ARPNOREPAIR = 1
Property(S): ARPSYSTEMCOMPONENT = 1
Property(S): MsiHiddenProperties = SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLBROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPasswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;ServicePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProductID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_40C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSWORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_40C9_9837_E70B8D4882C2
Property(S): SecureCustomProperties = SQL_SHOWLIC;UPGRADESQL90
Property(S): SqlServerBuild = 1
Property(S): SqlCluster = 0
Property(S): INSTALLLEVEL = 90
Property(S): FXAssemblyVersion = 2.0.0.0
Property(S): VSAssemblyVersion = 8.0.0.0
Property(S): SqlErrorReporting = #0
Property(S): SqlSqmReporting = #0
Property(S): SqlEnableRanu = 0
Property(S): SqlPatchLevel = 9.1.2047
Property(S): ChannelID = 271
Property(S): PIDTemplate = 77656<````=````=````=````=`````>@.@.@.@.@.
Property(S): mpc = 77656
Property(S): OEMRelease = 0
Property(S): PIDKEY = **********
Property(S): ProgramFilesFolder = C:\Archivos de programa\
Property(S): ProductID = **********
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlClusterSec = 0
Property(S): MDACSXS = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): VersionNT = 502
Property(S): LocalSystemAccount = NT AUTHORITY\SYSTEM
Property(S): DefaultBuiltInAccount = LocalSystemAccount

.....

Thks

Emilio, unfortunately this is a known issue. Here is a snippet from a log I posted previously (from an English log).

The log post reads:

Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.1
GetServiceUserGroup failed for MSSQLSERVER, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.

We are currently investigating this issue, but my guess is that after RTM, someone deleted the user groups that were created during install. SQL setup creates several user groups that are used during setup. It appears that SP1 is also looking to use these and they no longer exist. The user groups are named in this fashion: SQLServer2005MSSQLUser$<MachineName>$<InstanceName>

We are still looking into it and hope to have a solution soon.

Thanks,
Samuel Lester (MSFT)

|||

Is a solution to this available?

Regards,
Eric Lapham

|||

SQL server uses local group for ACLs. When the server is installed the groups are created and their SIDs are stored in the registry. Somewhere along the way, the SID had to change and the SIDs in the registry were not valid anymore. Try to delete the values for the following values in Setup registry key the instance hive [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup]

The registry values are:

AGTGroup

SQLGroup

FTSGroup

ASGroup

Thanks,
Samuel Lester (MSFT)

|||

i deleted the registry value forAGTGroup, SQLGroupF, TSGroup and ASGroup and the setup ended now correct for all product.

Thanks for the help.

Regards,

Emilio

|||

Thank you; SP1 is installed. I found ASGroup in

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup]

The fours keys appeared to be recreated by the install of SP1. Regards, Eric Lapham

|||Correct, I should have mentioned that as well. These keys will get recreated correctly during the following SP1 install. Glad to hear it works for you!

Samuel Lester (MSFT)|||

Samuel, I am getting ready to install SP1. Would you recommend deleting these values prior to any attempt to install SP1

Regards,
Jon

|||

Nope, no need to do this. This error only occurs if someone has explicitly deleted user groups after installing RTM. We haven't seen much of this happening, but in case it has, this is how to clean it up.

Go ahead and install SP1.

Thanks,
Sam

|||

Hello Samuel,

I experienced the same problem when installing SQL 2005 SP2.

I removed the registry values as you suggested; but I still got the failures.

Here are the partial logs :

Configuring ACL for WMI namespace \\.\root\Microsoft\SqlServer\ComputerManagement
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)
<Func Name='SecureWMINamespace'>
No need to protect the namespace security
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Tue Jun 05 16:38:04 2007
MSI (s) (48:0C) [16:38:04:855]: Executing op: ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (48:0C) [16:38:04:855]: Executing op: CustomActionSchedule(Action=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=AddCertificate,CustomActionData=c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\)
MSI (s) (48:CC) [16:38:04:875]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI596.tmp, Entrypoint: AddCertificate
FTECa.DLL: INFO: FTE: AddCertificate(), Entering...
FTECa.DLL: INFO: FTE: AddCertificate: CustomActionData: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
MSI (s) (48:0C) [16:38:05:416]: Executing op: ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: AddCertificate: Succeeded. Added Certificate from c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\msfte.dll
MSI (s) (48:0C) [16:38:05:416]: Executing op: CustomActionSchedule(Action=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=InstallPerfCounters,CustomActionData=c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
MSI (s) (48C) [16:38:05:436]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI597.tmp, Entrypoint: InstallPerfCounters
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Entering...
FTECa.DLL: INFO: InstallPerfCounters: CustomActionData: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\:
FTECa.DLL: INFO: InstallPerfCounters: Instance name obtained:
FTECa.DLL: INFO: InstallPerfCounters: Instance home path: c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\
FTECa.DLL: INFO: Setting acls on c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\msfte.dll
FTECa.DLL: Warning: Failed to get BuiltinPerfMonitoringUsersSid win32error 87, this is only expected to work on w2k3+ systems
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\fdcntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ifdcntrs.ini, msftesqlFD -> msftesqlFD, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ftecntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iftcntrs.ini, msftesql -> msftesql, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\idxcntrs.ini -> c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iindctrs.ini, msftesqlidx -> msftesqlidx, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\ifdcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iftcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\iindctrs.ini have been installed.
MSI (s) (48:0C) [16:38:06:127]: Executing op: ActionStart(Name=CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Exiting...
MSI (s) (48:0C) [16:38:06:127]: Executing op: CustomActionSchedule(Action=CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1025,Source=BinaryData,Target=RemoveFTEServiceDependency,CustomActionData=msftesql)
MSI (s) (48:34) [16:38:06:147]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI598.tmp, Entrypoint: RemoveFTEServiceDependency
FTECa.DLL: INFO: FTE: Enter RemoveFTEServiceDependency()
FTECa.DLL: INFO: FTE: RemoveFTEServiceDependency: Service name obtained: msftesql
MSI (s) (48:0C) [16:38:07:008]: Executing op: ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: Exit RemoveFTEServiceDependency()
MSI (s) (48:0C) [16:38:07:018]: Executing op: CustomActionSchedule(Action=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=SetLaunchPermissions,CustomActionData={68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITY\SYSTEM)
MSI (s) (48:8C) [16:38:07:038]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI599.tmp, Entrypoint: SetLaunchPermissions
MSI (s) (48:0C) [16:38:07:228]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
MSI (s) (48:0C) [16:38:07:238]: Executing op: ProgressTotal(Total=6,Type=1,ByteEquivalent=1300000)
MSI (s) (48:0C) [16:38:07:238]: Executing op: ServiceControl(,Name=SQLWriter,Action=1,Wait=0,)
MSI (s) (48:0C) [16:38:37:277]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:277]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:397]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:407]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:407]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:498]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:498]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:528]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Transforming table Error.

MSI (s) (48:0C) [16:38:37:538]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (48:0C) [16:38:37:538]: Product: Microsoft SQL Server 2005 -- Error 1920. Service 'SQLWriter' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.

Error 1920. Service 'SQLWriter' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.
MSI (s) (48:0C) [16:38:37:568]: User policy value 'DisableRollback' is 0
MSI (s) (48:0C) [16:38:37:568]: Machine policy value 'DisableRollback' is 0
Action ended 16:38:37: InstallFinalize. Return value 3.

Any suggestion are much appreciated

Thanks

David Chan