2 Replies Latest reply on Nov 26, 2009 4:49 PM by JENGTI

    sql 2005 express error installation in epo 4

      When i going to install epo 4, but first i install microsoft sql 2005 express i get and error and dont install sql 2005 and cannt install epo 4.

      The error is "the installation of microsoft sql 2005 express failed"


      The server have WSUS sp 1 , w2003 sp 2. English

      This is part of the log :
      1: Setup did not detect any incompatible products on the system. Continuing the install.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Setup did not detect any compatible products on the system. Continuing the clean install.
      1: Start checkSystemForProblems
      1: Loading the following DLL for Use: [C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\{0D8D1459-33B7-409F-8F95-034E0FE7B8AE}\Co mmonSetup.DLL]
      1: Setting the current directory to [C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\{0D8D1459-33B7-409F-8F95-034E0FE7B8AE}].
      1: Unloading the following DLL: [C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\{0D8D1459-33B7-409F-8F95-034E0FE7B8AE}\Co mmonSetup.DLL]
      1: Setting the current directory to [F:\Drivers\epo 4.0\EPO400L].
      1: Setup detected that the HIP upgrade client prompt is not needed.
      1: Setup detected the Workstation service so continue the install.
      1: Operating System lower than Windows Vista so looking for NT LM Security Support Provider Service.
      1: Setup detected the NT LM Security Support Provider Service so continue the install.
      1: End checkSystemForProblems
      1: Loading the following DLL for Use: [C:\WINDOWS\system32\Comctl32.dll]
      1: Setting the current directory to [C:\WINDOWS\system32].
      1: Cluster Service NOT detected so Disabling Cluster UI.
      1: gClusterEnvironmentDetected = [0] gUpgrading = [0]
      1: Setup detected MSI version [3.1.4000.4042] running on the system. bCorrectMSIDetected = [1] nMsiTemp = [1]
      1: MSXML 6.0 (32-bit) detected.
      1: Internet Explorer 6.0 (32-bit) detected.
      1: Microsoft Data Access Components (MDAC) 2.8 (32-bit) detected.
      1: Root key set successfully.
      1: Microsoft SQL 2005 Backward Compatibility detected.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Got "InstalledInstances" value successfully.
      1: Number of MSDE/SQL instances detected is [1]
      1: bInstallMDAC = [0] bInstallSQL2K5BC = [0] bInstallSQL = [0] bShouldSQLInstallBeEnabled = [1] bShouldNextBeEnabled = [1] bUpgradingWithRemoteDB = [0]
      1: MSXML 6.0 (32-bit) detected.
      1: Internet Explorer 6.0 (32-bit) detected.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Got "Install" value successfully.
      1: Microsoft .NET Framework 2.0 detected.
      1: Microsoft Data Access Components (MDAC) 2.8 (32-bit) detected.
      1: Root key set successfully.
      1: Microsoft SQL 2005 Backward Compatibility detected.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Got "InstalledInstances" value successfully.
      1: Number of MSDE/SQL instances detected is [1]
      1: bInstallMDAC = [0] bInstallSQL2K5BC = [0] bInstallSQL = [1] bShouldSQLInstallBeEnabled = [1] bShouldNextBeEnabled = [1] bUpgradingWithRemoteDB = [0]
      1: Start validateePOPrerequisites
      1: bInstallMDAC = [0] bInstallSQL2K5BC = [0] bInstallSQL = [1]
      1: Installing SQL 2005 Express.
      1: Start RunSQL2K5ExpressInstaller
      1: Setting szWorkingDirectory to [F:\Drivers\epo 4.0\EPO400L\Setup\SQL2K5Express]
      1: Setting szLogDirectory to [C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\NAILogs]
      1: Setting Command to Launch to [F:\Drivers\epo 4.0\EPO400L\Setup\SQL2K5Express\SQLEXPR.EXE]
      1: System Language detected as [English(1033)]
      1: Setting Command line to [/qn INSTANCENAME=EPOSERVER ADDLOCAL=SQL_Engine,Connectivity COLLATION=SQL_Latin1_General_Cp1_CI_AS DISABLENETWORKPROTOCOLS=0 REBOOT=R /L*v "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\NAILogs\SQL2K5Inst-MSI.Log"]
      1: LaunchAppAndWait set as follows: bEnvironmentSet = [0] bWorkingDirSet = [1] bWaitToFinish = [1] bShouldBeHidden = [1]
      1: FAILURE: In execute3rdPartyExternalCommand with return code [17058].
      MSI (c) (30:08) [11:28:42:158]: PROPERTY CHANGE: Adding ORIONDATABASESERVERNAME property. Its value is 'UPDATER\EPOSERVER'.
      1: End RunSQL2K5ExpressInstaller
      1: End validateePOPrerequisites
      1: MSXML 6.0 (32-bit) detected.
      1: Internet Explorer 6.0 (32-bit) detected.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Got "Install" value successfully.
      1: Microsoft .NET Framework 2.0 detected.
      1: Microsoft Data Access Components (MDAC) 2.8 (32-bit) detected.
      1: Root key set successfully.
      1: Microsoft SQL 2005 Backward Compatibility detected.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Got "InstalledInstances" value successfully.
      1: Number of MSDE/SQL instances detected is [1]
      1: bInstallMDAC = [0] bInstallSQL2K5BC = [0] bInstallSQL = [1] bShouldSQLInstallBeEnabled = [1] bShouldNextBeEnabled = [1] bUpgradingWithRemoteDB = [0]
      1: Start validateePOPrerequisites
      1: bInstallMDAC = [0] bInstallSQL2K5BC = [0] bInstallSQL = [1]
      1: Installing SQL 2005 Express.
      1: Start RunSQL2K5ExpressInstaller
      1: Setting szWorkingDirectory to [F:\Drivers\epo 4.0\EPO400L\Setup\SQL2K5Express]
      1: Setting szLogDirectory to [C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\NAILogs]
      1: Setting Command to Launch to [F:\Drivers\epo 4.0\EPO400L\Setup\SQL2K5Express\SQLEXPR.EXE]
      1: System Language detected as [English(1033)]
      1: Setting Command line to [/qn INSTANCENAME=EPOSERVER ADDLOCAL=SQL_Engine,Connectivity COLLATION=SQL_Latin1_General_Cp1_CI_AS DISABLENETWORKPROTOCOLS=0 REBOOT=R /L*v "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\NAILogs\SQL2K5Inst-MSI.Log"]
      1: LaunchAppAndWait set as follows: bEnvironmentSet = [0] bWorkingDirSet = [1] bWaitToFinish = [1] bShouldBeHidden = [1]
      1: FAILURE: In execute3rdPartyExternalCommand with return code [17058].
      1: End RunSQL2K5ExpressInstaller
      1: End validateePOPrerequisites
      1: MSXML 6.0 (32-bit) detected.
      1: Internet Explorer 6.0 (32-bit) detected.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Got "Install" value successfully.
      1: Microsoft .NET Framework 2.0 detected.
      1: Microsoft Data Access Components (MDAC) 2.8 (32-bit) detected.
      1: Root key set successfully.
      1: Microsoft SQL 2005 Backward Compatibility detected.
      1: Root key set successfully.
      1: Root key set successfully.
      1: Got "InstalledInstances" value successfully.
      1: Number of MSDE/SQL instances detected is [1]
      1: bInstallMDAC = [0] bInstallSQL2K5BC = [0] bInstallSQL = [1] bShouldSQLInstallBeEnabled = [1] bShouldNextBeEnabled = [1] bUpgradingWithRemoteDB = [0]
      MSI (c) (30:08) [11:31:19:440]: Destroying RemoteAPI object.
      MSI (c) (30:D4) [11:31:19:440]: Custom Action Manager thread ending.
      === Verbose logging stopped: 7/14/2008 11:31:19 ===
        • 1. RE: sql 2005 express error installation in epo 4
          Minkus
          Hi,

          Just ran into the same problem myself - attempting to install ePO 4.0.0 with SQL 2005 Express on a server that already has WSUS 3.0 installed, and finding that the SQL Express 2005 install fails with the following error message:

          "The installation of Mcirosoft SQL 2005 Express failed." (NB the mis-spelling of 'Microsoft'!)

          I managed to fix the problem by downloading the SQL Server 2005 Express Edition SP3 installer from the following location:
          http://go.microsoft.com/fwlink/?LinkId=135970
          Having downloaded 'SQLEXPR.EXE' from the above site, I copied it into my ePO 4.0.0 installation image under the 'Setup\SQL2K5Express' folder, replacing the existing file. I then ran the ePO setup again and the installation went fine.

          Just in case anyone else has the same problem, here are some more errors that I received in my event log:

          Event Type: Error
          Event Source: Application Error
          Event Category: (100)
          Event ID: 1000
          Date: 18/02/2009
          Time: 14:36:21
          User: N/A
          Computer: INFRASERVER
          Description:
          Faulting application msiexec.exe, version 3.1.4000.3959, faulting module msvcr80.dll, version 8.0.50727.1433, fault address 0x00008aa0.

          For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
          Data:
          0000: 41 70 70 6c 69 63 61 74 Applicat
          0008: 69 6f 6e 20 46 61 69 6c ion Fail
          0010: 75 72 65 20 20 6d 73 69 ure msi
          0018: 65 78 65 63 2e 65 78 65 exec.exe
          0020: 20 33 2e 31 2e 34 30 30 3.1.400
          0028: 30 2e 33 39 35 39 20 69 0.3959 i
          0030: 6e 20 6d 73 76 63 72 38 n msvcr8
          0038: 30 2e 64 6c 6c 20 38 2e 0.dll 8.
          0040: 30 2e 35 30 37 32 37 2e 0.50727.
          0048: 31 34 33 33 20 61 74 20 1433 at
          0050: 6f 66 66 73 65 74 20 30 offset 0
          0058: 30 30 30 38 61 61 30 0008aa0

          Event Type: Error
          Event Source: MSSQL$EPOSERVER
          Event Category: (2)
          Event ID: 17058
          Date: 18/02/2009
          Time: 14:38:07
          User: N/A
          Computer: INFRASERVER
          Description:
          initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(error not found).

          For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
          Data:
          0000: a2 42 00 00 10 00 00 00 ¢B......
          0008: 16 00 00 00 49 00 4e 00 ....I.N.
          0010: 46 00 52 00 41 00 53 00 F.R.A.S.
          0018: 45 00 52 00 56 00 45 00 E.R.V.E.
          0020: 52 00 5c 00 45 00 50 00 R.\.E.P.
          0028: 4f 00 53 00 45 00 52 00 O.S.E.R.
          0030: 56 00 45 00 52 00 00 00 V.E.R...
          0038: 00 00 00 00 ....

          Event Type: Error
          Event Source: MsiInstaller
          Event Category: None
          Event ID: 10005
          Date: 18/02/2009
          Time: 14:38:11
          User: ADMIN\Chris
          Computer: INFRASERVER
          Description:
          Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
          The error is (17058) .

          For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
          Data:
          0000: 7b 32 41 46 46 46 44 44 {2AFFFDD
          0008: 37 2d 45 44 38 35 2d 34 7-ED85-4
          0010: 41 39 30 2d 38 43 35 32 A90-8C52
          0018: 2d 35 44 41 39 45 42 44 -5DA9EBD
          0020: 43 39 42 38 46 7d C9B8F}

          Event Type: Error
          Event Source: Service Control Manager
          Event Category: None
          Event ID: 7024
          Date: 18/02/2009
          Time: 14:38:10
          User: N/A
          Computer: INFRASERVER
          Description:
          The SQL Server (EPOSERVER) service terminated with service-specific error 17058 (0x42A2).

          For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

          Event Type: Information
          Event Source: MsiInstaller
          Event Category: None
          Event ID: 11708
          Date: 18/02/2009
          Time: 14:39:01
          User: ADMIN\Chris
          Computer: INFRASERVER
          Description:
          Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.

          For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
          Data:
          0000: 7b 32 41 46 46 46 44 44 {2AFFFDD
          0008: 37 2d 45 44 38 35 2d 34 7-ED85-4
          0010: 41 39 30 2d 38 43 35 32 A90-8C52
          0018: 2d 35 44 41 39 45 42 44 -5DA9EBD
          0020: 43 39 42 38 46 7d C9B8F}
          • 2. Re: RE: sql 2005 express error installation in epo 4

            This is general error we encounter when we try to install another sql instance on the server where WSUS db's sql instance is installed. And this instance is generally the Windows internal database.

             

            In order to successfully installed another sql instance on WSUS db's sql instance:

            > Stop the WSUS db's SQL instance

            > Run the SQL 2005 setup.

            > Uncheck the "hide advanced configuration options" -> Next -> Next

            > Type any name for the new instance, say SQLexpress

            > On "Service Account" settings: Instead of going for the default selected account, generally on WSUS server it will be "Network service" account or "Local system" account that will be selected.

             

            Here instead of the above two accounts, select the radio button "Use a domain user account" -> And use the domain admin or local admin(in this case systemname in domain box)

             

            > It should successfully installed the new sql instance and then you can restart the WSUS db's SQL instance.