corner102
asked on
Installation failure installing SQL Server 2008 R2 Standard on Windows Server 2008 R2 Enterprise
I can't seem to get the installtion to complete on this windows server. It keeps stating that an "External component has thrown an exception" and provides the following log file.
Below is a copy of the log file
-------------------------- ---------- ---------- ---------- ---------- ---------- --------
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): -391544739
Exit facility code: 169
Exit error code: 32861
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-12-30 13:36:52
End time: 2011-12-30 13:55:47
Requested action: Install
Log with failure: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\Detail .txt
Exception help link: http%3a%2f%2fgo.microsoft. com%2ffwli nk%3fLinkI d%3d20476% 26ProdName %3dMicroso ft%2bSQL%2 bServer%26 EvtSrc%3ds etup.rll%2 6EvtID%3d5 0000%26Pro dVer%3d10. 50.1600.1% 26EvtType% 3d0x987D26 93%400xE8A 9805D
Machine Properties:
Machine name: MDFI
Machine processor count: 8
OS version: Windows Server 2008 R2
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 SQLEXPRESS MSSQL.1 Database Engine Services 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 SQLEXPRESS MSSQL.1 SharedTools 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 Tools 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 ToolsClient 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 ToolsClient\Connectivity 1033 Express Edition 9.00.1399.06 No
Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation location: C:\Share\SQL Server 2008 R2 Standard (x86, x64, ia64) - DVD (English)\x64\setup\
Installation edition: STANDARD
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: XANDER\Administrator
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV ER\OLAP\Ba ckup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV ER\OLAP\Co nfig
ASDATADIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV ER\OLAP\Da ta
ASDOMAINGROUP: <empty>
ASLOGDIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV ER\OLAP\Lo g
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: XANDER\Administrator
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: XANDER\Administrator
ASTEMPDIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV ER\OLAP\Te mp
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\Config urationFil e.ini
CUSOURCE:
ENABLERANU: False
ENU: True
ERRORREPORTING: False
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FEATURES: SQLENGINE,REPLICATION,FULL TEXT,AS,RS ,BIDS,CONN ,IS,BC,SDK ,BOL,SSMS, ADV_SSMS,O CS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: False
IACCEPTSQLSERVERLICENSETER MS: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: c:\Program Files\Microsoft SQL Server\
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: XANDER\Administrator
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
NPENABLED: 0
PASSPHRASE: *****
PCUSOURCE:
PID: *****
QUIET: False
QUIETSIMPLE: False
ROLE: <empty>
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: XANDER\Administrator
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_ AS
SQLSVCACCOUNT: XANDER\Administrator
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: XANDER\Administrator
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: True
TCPENABLED: 1
UIMODE: Normal
X86: False
Configuration file: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\Config urationFil e.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xE8A9805D
Configuration error description: External component has thrown an exception.
Configuration log: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\Detail .txt
Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xE8A9805D
Configuration error description: External component has thrown an exception.
Configuration log: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\Detail .txt
Feature: Full-Text Search
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xE8A9805D
Configuration error description: External component has thrown an exception.
Configuration log: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\Detail .txt
Feature: Analysis Services
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Reporting Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xE8A9805D
Configuration error description: External component has thrown an exception.
Configuration log: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\Detail .txt
Feature: Integration Services
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Client Tools Connectivity
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Management Tools - Complete
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Management Tools - Basic
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Client Tools SDK
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Client Tools Backwards Compatibility
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Business Intelligence Development Studio
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: SQL Server Books Online
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Microsoft Sync Framework
Status: Passed
MSI status: Passed
Configuration status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\System Configurat ionCheck_R eport.htm
Below is a copy of the log file
--------------------------
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): -391544739
Exit facility code: 169
Exit error code: 32861
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-12-30 13:36:52
End time: 2011-12-30 13:55:47
Requested action: Install
Log with failure: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133
Exception help link: http%3a%2f%2fgo.microsoft.
Machine Properties:
Machine name: MDFI
Machine processor count: 8
OS version: Windows Server 2008 R2
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 SQLEXPRESS MSSQL.1 Database Engine Services 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 SQLEXPRESS MSSQL.1 SharedTools 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 Tools 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 ToolsClient 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 ToolsClient\Connectivity 1033 Express Edition 9.00.1399.06 No
Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation location: C:\Share\SQL Server 2008 R2 Standard (x86, x64, ia64) - DVD (English)\x64\setup\
Installation edition: STANDARD
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: XANDER\Administrator
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV
ASDATADIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV
ASDOMAINGROUP: <empty>
ASLOGDIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: XANDER\Administrator
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: XANDER\Administrator
ASTEMPDIR: c:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERV
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133
CUSOURCE:
ENABLERANU: False
ENU: True
ERRORREPORTING: False
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FEATURES: SQLENGINE,REPLICATION,FULL
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: False
IACCEPTSQLSERVERLICENSETER
INDICATEPROGRESS: False
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: c:\Program Files\Microsoft SQL Server\
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: XANDER\Administrator
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
NPENABLED: 0
PASSPHRASE: *****
PCUSOURCE:
PID: *****
QUIET: False
QUIETSIMPLE: False
ROLE: <empty>
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: XANDER\Administrator
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_
SQLSVCACCOUNT: XANDER\Administrator
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: XANDER\Administrator
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: True
TCPENABLED: 1
UIMODE: Normal
X86: False
Configuration file: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xE8A9805D
Configuration error description: External component has thrown an exception.
Configuration log: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133
Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xE8A9805D
Configuration error description: External component has thrown an exception.
Configuration log: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133
Feature: Full-Text Search
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xE8A9805D
Configuration error description: External component has thrown an exception.
Configuration log: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133
Feature: Analysis Services
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Reporting Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xE8A9805D
Configuration error description: External component has thrown an exception.
Configuration log: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133
Feature: Integration Services
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Client Tools Connectivity
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Management Tools - Complete
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Management Tools - Basic
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Client Tools SDK
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Client Tools Backwards Compatibility
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Business Intelligence Development Studio
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: SQL Server Books Online
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Microsoft Sync Framework
Status: Passed
MSI status: Passed
Configuration status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133
Is the information posted above the contents of the c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_133 443\Detail .txt file?
ASKER
Yes
Hello, you require x86 bit. If you have windows 7 then ok, otherwise you require to install powershell first before installing the sql server 2008 R2.
SQL Server 2008 R2 can run on 64bit environments.
You have Windows Server 2008 R2 SP 1 64 bit which is well serported for installing SQL Server 2008 R2.
http://msdn.microsoft.com/en-us/library/ms143506.aspx
you have Sql Server 2005 Express installed as the default database AND you are trying to Install SQL Server 2008 R2 as teh default instance.
You can either remove the 2005 instance ,backing up all databasesand then proceed with teh install or you make the sql server 2008 rs2 install a named instance.
You have Windows Server 2008 R2 SP 1 64 bit which is well serported for installing SQL Server 2008 R2.
http://msdn.microsoft.com/en-us/library/ms143506.aspx
you have Sql Server 2005 Express installed as the default database AND you are trying to Install SQL Server 2008 R2 as teh default instance.
You can either remove the 2005 instance ,backing up all databasesand then proceed with teh install or you make the sql server 2008 rs2 install a named instance.
Before installing the 2008 tools, you need to remove any and all "shared" components from 2005. Try going to your Add/Remove programs control panel, find Microsoft SQL Server 2005, and click "Change." Then choose "Workstation Components" and remove everything there (this will not remove your database engine).
ASKER
I don't think that is the problems as I do not have sql server 2005 installed.
ASKER
Not sure why i'm receiving suggestions for a Windows 7 machine when the problem is on a Windows Server 2008.
I believe they are referencing this portion of your log.
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 SQLEXPRESS MSSQL.1 Database Engine Services 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 SQLEXPRESS MSSQL.1 SharedTools 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 Tools 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 ToolsClient 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 ToolsClient\Connectivity 1033 Express Edition 9.00.1399.06 No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 SQLEXPRESS MSSQL.1 Database Engine Services 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 SQLEXPRESS MSSQL.1 SharedTools 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 Tools 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 ToolsClient 1033 Express Edition 9.00.1399.06 No
Sql Server 2005 ToolsClient\Connectivity 1033 Express Edition 9.00.1399.06 No
ASKER
I see, thank you Dustin...:) I still need help and I'm stumped....don't know why I cannot install.
Did you remove SQL Server 2005 client tools?
They were probably part of an installation of another application
They were probably part of an installation of another application
ASKER
Yes, then I tried installing again and no luck same issue.
you may need to reinstall .NET Framework 3.5 SP11
ASKER
thanks, will try that
Just to narrow down possible causes, please try reducing your installation to just the database services and leave out all the extra features for now.
Try installing as a named instance, and let it use the default Local or Network service accounts for the services.
Does this server have UAC turned on?
Try installing as a named instance, and let it use the default Local or Network service accounts for the services.
Does this server have UAC turned on?
ASKER
yes, I do. should I disable it?
Might be worth a shot, as a troubleshooting step.
ASKER
Tried that still doesn't work.
If you go to Start, Run, and launch Winver.exe, does it say anything about being a Checked/Debug build?
ASKER
Yes it says Debug.
Therein lies the problem; you won't be able to install a normal version of SQL on a Debug/Checked version of Windows Server.
ASKER
Thank you Dustin!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.