Error 1406 while installing SQL server 2005 on windows 2003 64 bit standard

[Former Member]

Hi Gurus,

When I am trying to install SQL SERVER 2005 on Windows Serevr 2005 i get the error code 1406

I tried using the script sql4sap.vbs. and tried to set the named instance.

please suggest

Please find the contents of the Summary.txt

Microsoft SQL Server 2005 9.00.1399.06

==============================

OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)

Time : Mon Apr 14 14:51:07 2008

Machine : UKSAPTEST02

Product : .NET Framework 2.0

Product Version : 2.0.50727

Install : Failed

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST02_.NET Framework 2.0.log

Last Action : InstallFinalize

Error String :Could not write value to key \Software\Classes\.appref-ms

Error Number : 1406

-

---

UKSAPTEST02 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Mon Apr 14 14:52:26 2008

List of log files:

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST02_Core.log

Many thanks

Sreeram

Edited by: sreeram kaki on Apr 14, 2008 6:12 PM

[clas_hortien · Accepted solution]

Hi,

please ensure that you

- have disabled any Anti Virus software during the installation

- run the installation with a local admin account.

Best regards

Clas

[Former Member · Accepted solution]

Hi Clas,

Thanks for the valuable suggestions,

I tried to install the database (sql server 2005) using the local admin password on another server which do not have the antivirus installed. I started the installation at 3:15 PM today and the installation is still in progerss

please see the log below from Summary.txt.

Microsoft SQL Server 2005 9.00.1399.06

==============================

OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)

Time : Tue Apr 15 15:04:28 2008

Machine : UKSAPTEST01

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST01_SQLSupport_1.log

-

---

Machine : UKSAPTEST01

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST01_SQLNCLI_1.log

-

---

Machine : UKSAPTEST01

Product : Microsoft SQL Server VSS Writer

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST01_SqlWriter_1.log

-

---

Machine : UKSAPTEST01

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST01_MSXML6_1.log

-

---

Machine : UKSAPTEST01

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST01_SQLSupport_2.log

-

---

Machine : UKSAPTEST01

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST01_SQLNCLI_2.log

-

---

Machine : UKSAPTEST01

Product : Microsoft SQL Server 2005 Books Online (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST01_BOL_1.log

-

---

Machine : UKSAPTEST01

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_UKSAPTEST01_MSXML6_2.log

-

---

Also see the last few lines of the log file

SQLSetup0001_UKSAPTEST01_SQL.log

Action start 17:10:43: Rollback_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B.

MSI (s) (C0!50) [17:10:43:815]: PROPERTY CHANGE: Deleting Rollback_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B property. Its current value is '1 0 0 Installing Local Groups 50000 SQLServer2005MSFTEUser$UKSAPTEST01$RDE NT AUTHORITY\SYSTEM '.

Action ended 17:10:43: Rollback_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B. Return value 1.

<EndFunc Name='ScheduleActionX' Return='0' GetLastError='0'>

<Func Name='ScheduleActionX'>

<Func Name='SetCAContext'>

MSI (s) (C0!50) [17:10:43:815]: PROPERTY CHANGE: Adding Do_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B property. Its value is '1 1 0 Installing Local Groups 50000 SQLServer2005MSFTEUser$UKSAPTEST01$RDE NT AUTHORITY\SYSTEM '.

MSI (s) (C0!50) [17:10:43:815]: Doing action: Do_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B

<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>

Action start 17:10:43: Do_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B.

MSI (s) (C0!50) [17:10:43:830]: PROPERTY CHANGE: Deleting Do_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B property. Its current value is '1 1 0 Installing Local Groups 50000 SQLServer2005MSFTEUser$UKSAPTEST01$RDE NT AUTHORITY\SYSTEM '.

Action ended 17:10:43: Do_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B. Return value 1.

<EndFunc Name='ScheduleActionX' Return='0' GetLastError='0'>

<EndFunc Name='Write_sqlGroupMember' Return='0' GetLastError='0'>

PerfTime Stop: Write_sqlGroupMember : Tue Apr 15 17:10:43 2008

<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>

MSI (s) (C0:F0) [17:10:43:830]: Doing action: Write_sqlUserSecurity.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B

Action ended 17:10:43: Write_sqlGroupMember.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B. Return value 1.

MSI (s) (C0:50) [17:10:43:830]: Invoking remote custom action. DLL: C:\WINDOWS.0\Installer\MSI1D8.tmp, Entrypoint: Write_sqlUserSecurity

Action start 17:10:43: Write_sqlUserSecurity.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B.

<Func Name='LaunchFunction'>

Function=Write_sqlUserSecurity

<Func Name='SetCAContext'>

<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>

Doing Action: Write_sqlUserSecurity

PerfTime Start: Write_sqlUserSecurity : Tue Apr 15 17:10:43 2008

<Func Name='Write_sqlUserSecurity'>

<Func Name='ScheduleActionX'>

<Func Name='SetCAContext'>

MSI (s) (C0!34) [17:10:43:924]: PROPERTY CHANGE: Adding Do_sqlUserSecurity.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B property. Its value is '0 1 0 Setting User Security 50000 SQLServer2005SQLBrowserUser$UKSAPTEST01 SeServiceLogonRight SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeServiceLogonRight SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeBatchLogonRight SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeAssignPrimaryTokenPrivilege SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeChangeNotifyPrivilege SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeIncreaseQuotaPrivilege SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeServiceLogonRight SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeBatchLogonRight SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeAssignPrimaryTokenPrivilege SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeChangeNotifyPrivilege SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeIncreaseQuotaPrivilege SQLServer2005MSFTEUser$UKSAPTEST01$RDE SeServiceLogonRight SQLServer2005MSFTEUser$UKSAPTEST01$RDE SeBatchLogonRight SQLServer2005MSFTEUser$UKSAPTEST01$RDE SeAssignPrimaryTokenPrivilege SQLServer2005MSFTEUser$UKSAPTEST01$RDE SeChan

MSI (s) (C0!34) [17:10:43:924]: Doing action: Do_sqlUserSecurity.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B

<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>

Action start 17:10:43: Do_sqlUserSecurity.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B.

MSI (s) (C0!34) [17:10:43:924]: PROPERTY CHANGE: Deleting Do_sqlUserSecurity.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B property. Its current value is '0 1 0 Setting User Security 50000 SQLServer2005SQLBrowserUser$UKSAPTEST01 SeServiceLogonRight SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeServiceLogonRight SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeBatchLogonRight SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeAssignPrimaryTokenPrivilege SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeChangeNotifyPrivilege SQLServer2005SQLAgentUser$UKSAPTEST01$RDE SeIncreaseQuotaPrivilege SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeServiceLogonRight SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeBatchLogonRight SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeAssignPrimaryTokenPrivilege SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeChangeNotifyPrivilege SQLServer2005MSSQLUser$UKSAPTEST01$RDE SeIncreaseQuotaPrivilege SQLServer2005MSFTEUser$UKSAPTEST01$RDE SeServiceLogonRight SQLServer2005MSFTEUser$UKSAPTEST01$RDE SeBatchLogonRight SQLServer2005MSFTEUser$UKSAPTEST01$RDE SeAssignPrimaryTokenPrivilege SQLServer2005MSFTEUser$UKSAPTEST01$

Action ended 17:10:43: Do_sqlUserSecurity.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B. Return value 1.

<EndFunc Name='ScheduleActionX' Return='0' GetLastError='0'>

<EndFunc Name='Write_sqlUserSecurity' Return='0' GetLastError='0'>

PerfTime Stop: Write_sqlUserSecurity : Tue Apr 15 17:10:43 2008

<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>

MSI (s) (C0:F0) [17:10:43:940]: Doing action: Write_sqlFileSDDL.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B

Action ended 17:10:43: Write_sqlUserSecurity.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B. Return value 1.

MSI (s) (C0:10) [17:10:43:940]: Invoking remote custom action. DLL: C:\WINDOWS.0\Installer\MSI1D9.tmp, Entrypoint: Write_sqlFileSDDL

Action start 17:10:43: Write_sqlFileSDDL.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B.

<Func Name='LaunchFunction'>

Function=Write_sqlFileSDDL

<Func Name='SetCAContext'>

<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>

Doing Action: Write_sqlFileSDDL

PerfTime Start: Write_sqlFileSDDL : Tue Apr 15 17:10:43 2008

Thanks & Regards,

Sreeram

Edited by: sreeram kaki on Apr 15, 2008 6:45 PM