SQL 2008 installation

I have an SBS 2003 server and I am installing ACT! which uses SQL 2008.

The installation runs and seems ok but right at the end of the SQL bit it fails with:

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2068052377
  Exit facility code:            1212
  Exit error code:               1639
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:                    2011-09-26 15:07:39
  End time:                      2011-09-26 15:14:27
  Requested action:              Install
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110926_150459\sql_engine_core_inst_Cpu32_1.log
  Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1

Machine Properties:
  Machine name:                  SERVER
  Machine processor count:       2
  OS version:                    Windows Server 2003
  OS service pack:               Service Pack 2
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x86
  Process architecture:          32 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         E:\Dependencies\SQL Express 2008 R2\x32\x86\setup\
  Installation edition:          EXPRESS

User Input Settings:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      True
  AGTSVCACCOUNT:                 NT AUTHORITY\SYSTEM
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Disabled
  ASBACKUPDIR:                   Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   Config
  ASDATADIR:                     Data
  ASDOMAINGROUP:                 <empty>
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 *****
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <empty>
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Automatic
  CONFIGURATIONFILE:            
  CUSOURCE:                      
  ENABLERANU:                    True
  ENU:                           True
  ERRORREPORTING:                False
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FEATURES:                      SQLENGINE
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 *****
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  False
  INDICATEPROGRESS:              False
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <empty>
  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
  INSTANCEID:                    ACT7
  INSTANCENAME:                  ACT7
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  NPENABLED:                     0
  PASSPHRASE:                    *****
  PCUSOURCE:                    
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  ROLE:                          AllFeatures_WithDefaults
  RSINSTALLMODE:                 FilesOnlyMode
  RSSVCACCOUNT:                  <empty>
  RSSVCPASSWORD:                 *****
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         *****
  SECURITYMODE:                  SQL
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
  SQLSVCACCOUNT:                 NT AUTHORITY\SYSTEM
  SQLSVCPASSWORD:                *****
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           HURSTASSOCIATES\administrator
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBLOGDIR:               <empty>
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SQMREPORTING:                  False
  TCPENABLED:                    0
  UIMODE:                        AutoAdvance
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110926_150459\ConfigurationFile.ini

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Failed: see details below
  MSI error code:                0x1639
  MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110926_150459\sql_engine_core_inst_Cpu32_1.log
  MSI error description:        
  Configuration status:          Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110926_150459\SystemConfigurationCheck_Report.htm


To me it seems that the problem has something to do with the Native client. I have uninstalled it and reinstalled but the same error occurs.

I have Symantec Backup Exec installed which has a SQL instance and sahrepoint is there but it is not used.

Please can someone tell me how I can get it to install.
LVL 1
Optima SystemsNetwork EngineerAsked:
Who is Participating?
 
Metehan OzculluSQL Service ManagerCommented:
it looks like Microsoft has retired this product last year due to conflicts with Office 2007. Anyway it is still downloadable from other links like: http://majorgeeks.com/Windows_Installer_CleanUp_Utility_d4459.html
0
 
Metehan OzculluSQL Service ManagerCommented:
What does this log say:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110926_150459\sql_engine_core_inst_Cpu32_1.log
0
 
Optima SystemsNetwork EngineerAuthor Commented:
Her is the log:

=== Verbose logging started: 26/09/2011  15:14:09  Build type: SHIP UNICODE 4.05.6001.00  Calling process: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setup100.exe ===
MSI (c) (10:48) [15:14:09:347]: Resetting cached policy values
MSI (c) (10:48) [15:14:09:347]: Machine policy value 'Debug' is 0
MSI (c) (10:48) [15:14:09:347]: ******* RunEngine:
           ******* Product: E:\Dependencies\SQL Express 2008 R2\x32\x86\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi
           ******* Action:
           ******* CommandLine: **********
MSI (c) (10:48) [15:14:09:347]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (10:48) [15:14:09:347]: Grabbed execution mutex.
MSI (c) (10:48) [15:14:09:363]: Cloaking enabled.
MSI (c) (10:48) [15:14:09:363]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (10:48) [15:14:09:363]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (BC:88) [15:14:09:363]: Running installation inside multi-package transaction E:\Dependencies\SQL Express 2008 R2\x32\x86\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi
MSI (s) (BC:88) [15:14:09:363]: Grabbed execution mutex.
MSI (s) (BC:A8) [15:14:09:378]: Resetting cached policy values
MSI (s) (BC:A8) [15:14:09:378]: Machine policy value 'Debug' is 0
MSI (s) (BC:A8) [15:14:09:378]: ******* RunEngine:
           ******* Product: E:\Dependencies\SQL Express 2008 R2\x32\x86\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi
           ******* Action:
           ******* CommandLine: **********
MSI (s) (BC:A8) [15:14:09:378]: Machine policy value 'TransformsSecure' is 1
MSI (s) (BC:A8) [15:14:09:378]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (BC:A8) [15:14:09:378]: Specified instance {B5153233-9AEE-4CD4-9D2C-4FAAC870DBE2} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (BC:A8) [15:14:09:378]: MainEngineThread is returning 1639
MSI (s) (BC:88) [15:14:09:378]: User policy value 'DisableRollback' is 0
MSI (s) (BC:88) [15:14:09:378]: Machine policy value 'DisableRollback' is 0
MSI (s) (BC:88) [15:14:09:378]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (BC:88) [15:14:09:378]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (BC:88) [15:14:09:378]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (BC:88) [15:14:09:378]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (BC:88) [15:14:09:378]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (BC:88) [15:14:09:378]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (s) (BC:88) [15:14:09:378]: Restoring environment variables
MSI (c) (10:48) [15:14:09:378]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (10:48) [15:14:09:378]: MainEngineThread is returning 1639
=== Verbose logging stopped: 26/09/2011  15:14:09 ===

0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Metehan OzculluSQL Service ManagerCommented:
this log says there are some orphaned installations and it does not support reinstallation. The below link tells how to clean them.

http://sqlpost.blogspot.com/2009/06/orphan-msi-entries-during-sql-server.html
0
 
Optima SystemsNetwork EngineerAuthor Commented:
Thanks. I have downloaded the MSI inventory software but the link for the clean up utility points to office products and I am not sure what to download. Could you tell me where i can get the right utility for Server 2003 and SQL 2008.
0
 
Optima SystemsNetwork EngineerAuthor Commented:
ran both programs and removed all references to SQL 2008 with the same id number. Worked perfectly when i reinstalled. Many thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.