I have serious issues installing SQL server 2008 on my vista...The issues are majorly during installing the package.
-
Saturday, April 14, 2012 8:52 AM
Following is the full error log report that i received latest
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): -2068643839
Exit facility code: 1203
Exit error code: 1
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: 2012-04-14 12:49:49
End time: 2012-04-14 13:22:30
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745\Detail.txt
Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024
Machine Properties:
Machine name: MENKA-PC
Machine processor count: 2
OS version: Windows Vista
OS service pack: Service Pack 2
OS region: India
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
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: E:\x86\setup\
Installation edition: DEVELOPER
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: NT AUTHORITY\SYSTEM
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Backup
ASCOLLATION: Latin1_General_CI_AI
ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Config
ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data
ASDOMAINGROUP: <empty>
ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: NT AUTHORITY\SYSTEM
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: menka-PC\menka
ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Temp
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745\ConfigurationFile.ini
ENABLERANU: False
ERRORREPORTING: False
FEATURES: SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: 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: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: E:\
NPENABLED: 0
PID: *****
QUIET: False
QUIETSIMPLE: False
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: NT AUTHORITY\SYSTEM
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: Latin1_General_CI_AI
SQLSVCACCOUNT: NT AUTHORITY\SYSTEM
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: menka-PC\menka
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: False
TCPENABLED: 0
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745\ConfigurationFile.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: 0xBE03358B@1306@24
Configuration error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745\Detail.txt
Feature: SQL Client Connectivity SDK
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xBE03358B@1306@24
Configuration error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745\Detail.txt
Feature: Full-Text Search
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0xBE03358B@1306@24
Configuration error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745\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: 0xBE03358B@1306@24
Configuration error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745\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\20120414_124745\SystemConfigurationCheck_Report.htm
I have done a majority of diagonistics mentioned in the msdn website but to no avail. When the installation completes it shows errors on Database engine services and also i am unable to start the services manually
- Moved by Tom Phillips Monday, April 16, 2012 7:26 PM Setup Question (From:SQL Server Database Engine)
All Replies
-
Saturday, April 14, 2012 10:48 AM
have you installed .NET 3.5 SP1? it is required for the installation of SQL Server 2008.
are you trying to install RTM version of SQL Server 2008?
Try to install first Service Pack 3 for SQL Server 2008 as it does update the support files and avoiding some problems with the installation. After executing SP3 and installing the support files, you install SQL Server 2008 normally and after the installation you need to re-execute SP3 to apply the SP3 to the SQL Server 2008 installation.
Did you use .ISO download and extract the files with Winzip ? than you need to use WinRAR to extract the files as Winzip does not extract them correctly or burn to .ISO to a DVD or use a .ISO mount software. In addition it's recommand to copy the files to local disk and install from there.
-
Saturday, April 14, 2012 11:12 AM
thanks for replying mate....
I am installing a standard version sql 2008
i already have .net 3.5 framework installed and yes, it is required.
i am using a dvd-media to install sql server, there are no iso or zip files whatsoever
the problem iam facing is during installation that it says "Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes."
I tried doing everything that's mentioned on the msdn forum related to my query
i have a small question here: are there any specific problems with installing sql server 2008 on windows vista
puneet
-
Monday, April 16, 2012 4:41 PMModerator
Hi Scrapy coco,
For further investigation, please post the error messages in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745\Detail.txt.
Thanks,
MaggiePlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
-
Monday, April 16, 2012 8:18 PMModerator
Can you share
SQLServer_ERRORLOG*.txt under
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120414_124745
Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread. -
Tuesday, April 17, 2012 9:28 AMModerator
Hi Scrapy coco,
SQL Server 2008 Standard (32-bit) is supported in Windows Vista Ultimate, Windows Vista Enterprise and Windows Vista Business.
To resolve it, follow these steps:
When the installation throws this error, click on OK and allow it to proceed. It will fail for Database Engine, but the SQL Server service should have been created. Check the Services console.
If the service is present, perform the following steps:
1. Go to SQL Server Configuration manager, right click on the SQL Server service, and change the service account (if it is local system, give it a windows level account, and vice-versa). It might throw a WMI error but you will see the account getting updated anyway. If not, then use the Services console. Change the account for SQL Agent as well.
2. Next, try to start the service. It should come online.
3. However, you will not be able to log in to the SQL Server.
4. Now stop the service and start it from the command prompt using -m -c -T3608 parameters.
5. Now try logging in to the server using admin connection from sqlcmd (sqlcmd admin:<server name>\<instance name> ...)
6. Once logged in, use the sp_addsrvrolemember '<domain\username>','sysadmin'. Also add the builtin/administrators to the sysadmin role.
7. Now stop the service from the command prompt and start it from SQL Server configuration manager.
You should be able to log in to the server now.
For more information, please refer to http://blogs.msdn.com/b/sqljourney/archive/2012/03/16/sql-2008-r2-setup-fails-with-quot-wait-on-the-database-engine-recovery-handle-failed-quot.aspx .
Thanks,
Maggie
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- Edited by Maggie LuoMicrosoft Contingent Staff, Moderator Tuesday, April 17, 2012 9:29 AM
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Monday, April 23, 2012 2:53 PM
-
Wednesday, April 18, 2012 8:14 PM
SQL 2008 installation can be tricky... Here are some things I would try.
1. Check this registry key and make sure all values are set to 1*
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState
*If you don't see this registry key- don't worry just ignore this step.
2. Extract the latest service pack and use it when doing your installation
x86 command: SQLServer2008SP3-KB2546951-x86-ENU.exe /x:C:\SQLSP3
x64 command: SQLServer2008SP3-KB2546951-x64-ENU.exe /x:C:\SQLSP3
3. Run SQL Support installation from the service pack extracted files
x86 command: C:\SQLSP3\x86\setup\1033\sqlsupport.msi
x64 command: C:\SQLSP3\x64\setup\1033\sqlsupport.msi
4. Run Setup from the command prompt using the installation media for SQL
Setup.exe /PCUSource=C:\SQLSP3 /SkipRules=Cluster_VerifyForErrors /Action=Install
5. Follow normal installation procedures from this point.
