Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL 2008 installation

Posted on 2011-09-26
6
Medium Priority
?
3,124 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 7

Expert Comment

by:mozcullu
ID: 36599543
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
ID: 36599579
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
ID: 36599901
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:JayHine
ID: 36600024
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 2000 total points
ID: 36707631
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
ID: 36709480
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

636 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