cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

clas_hortien
Active Contributor
0 Kudos

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
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Gurus,

I Am trying to performa system copy.

I Have installed ECC6 on windows server 2003 Standard edition and SQL server 2005.

While I am trying to perform system copy using R3LOAD, i get the following error.

Please suggest the solution for the following error.

ERROR 2008-05-29 17:55:19.854

FRY-00001 Cannot load library C:/DOCUME1/ADMINI1/LOCALS~1/Temp/sapinst_exe.4980.1212074375/iamodapp.dll: Last error = 3765269347.

ERROR 2008-05-29 17:55:19.854

FCO-00011 The step createTempLicense with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_MSS|ind|ind|ind|ind|2|0|createTempLicense was executed with status ERROR ( Last error reported by the step :Cannot load library C:/DOCUME1/ADMINI1/LOCALS~1/Temp/sapinst_exe.4980.1212074375/iamodapp.dll: Last error = 3765269347.).

Regards,

Sree

Former Member
0 Kudos

SQL Server 2005 has a bug on x64 bit environment of Windows. The resolution is to install .NET framework 2.0 seperately for x64 Bit and then start SQL2005 setup. Let me know whether that works.

Thanks-Mubeen

Former Member
0 Kudos

Microsoft SQL Server 2005 9.00.1399.06

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

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

Do you have the recommended Service Pack and hotfixes installed for Windows 2003

Note 985137 - Service Pack Installation for SQL Server 2005

Note 799058 - Setting Up Microsoft SQL Server 2005