Solved

SQL 2008 installation

Posted on 2011-09-26
6
2,981 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:JayHine
  • 3
  • 3
6 Comments
 
LVL 7

Expert Comment

by:mozcullu
Comment Utility
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
 

Author Comment

by:JayHine
Comment Utility
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
 
LVL 7

Expert Comment

by:mozcullu
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:JayHine
Comment Utility
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
 
LVL 7

Accepted Solution

by:
mozcullu earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:JayHine
Comment Utility
ran both programs and removed all references to SQL 2008 with the same id number. Worked perfectly when i reinstalled. Many thanks
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video discusses moving either the default database or any database to a new volume.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now