?
Solved

SQL 2008 installation

Posted on 2011-09-26
6
Medium Priority
?
3,086 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 

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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

765 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