Answered by:
Probem after installing SQL server 2008 R2 express edition

Question
-
Hi,
I tried to install SQL server 2008 R2 express edition, but there were many error, So I can't now create sdf files in VS , here is the repporte that was created :
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): -2068119551
Exit facility code: 1211
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: 2010-09-03 11:36:31
End time: 2010-09-03 19:37:53
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100903_113214\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.50.1600.1%26EvtType%3d0xD9F8DE8D%400x0A2FBD17%401211%401
Machine Properties:
Machine name: NASREDDINE-PC
Machine processor count: 2
OS version: Windows 7
OS service pack:
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: n:\e03938ec0a1d3e9c07\x86\setup\
Installation edition: EXPRESS_ADVANCED
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: True
AGTSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
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,REPLICATION,FULLTEXT,RS,BIDS,SSMS,SNAC_SDK,OCS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
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: SQLEXPRESS
INSTANCENAME: SQLEXPRESS
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
NPENABLED: 0
PASSPHRASE: *****
PCUSOURCE:
PID: *****
QUIET: False
QUIETSIMPLE: False
ROLE: AllFeatures_WithDefaults
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: NT AUTHORITY\SYSTEM
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: Arabic_CI_AS
SQLSVCACCOUNT: NT AUTHORITY\SYSTEM
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: Nasreddine-PC\Nasreddine
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\20100903_113214\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\20100903_113214\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\20100903_113214\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\20100903_113214\Detail.txt
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\20100903_113214\Detail.txt
Feature: Management Tools - Basic
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: Business Intelligence Development Studio
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\20100903_113214\SystemConfigurationCheck_Report.htm
Saturday, September 4, 2010 6:29 AM
Answers
-
Hi Nasreddine,
If we want to use .sdf file in Visual Studio, please make sure the driver for SQL Server Compact 3.5 SP2 is installed correctly.
I recommend that you uninstall driver for SQL Server Compact 3.5 SP2, then download it from this link and try again: http://www.microsoft.com/downloads/details.aspx?familyid=E497988A-C93A-404C-B161-3A0B323DCE24&displaylang=en
For further investigation on the installation issue, could you please provide us the error messages logged into the setup log files which are located in the %Program files%\Microsoft SQL server\100\Setup bootstrap\Log\ folder by sending mail to _sqltnsp_at_microsoft_dot_com_(please replace dot with dot sign) with the following format:#Sample
Subject: MSDN/TechNet forum question: <Thread Title>
Attachments: <files>
Hi Tom,
ThreadURL:<URL>
<Additional information>
#End
For more information about "How to View and Read SQL Server Setup Log Files:", you could refer to this link: http://msdn.microsoft.com/en-us/library/ms143702.aspx
If anything is unclear, please let me know.
Regards,
Tom Li- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 16, 2013 4:28 PM
Tuesday, September 7, 2010 10:38 AM
All replies
-
Hi,
Could you please post error message from below location?
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100903_113214\Detail.txt
Before that,
Run setup in "Run as Administrator" method. Right click and choose "run as administrator". This option provide full installation right to setup file.
Ramesh S
www.sequalserver.comSaturday, September 4, 2010 1:51 PM -
Just see if you are hitting this bug :
http://support.microsoft.com/kb/968829
http://support.microsoft.com/kb/960781
Regards
Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/Saturday, September 4, 2010 2:24 PM -
I run the the setup as admin and no way the error stay exist. here is the content of the file that you have mentioned:
http://www.mediafire.com/?ba8vaun4ccozd31
Sunday, September 5, 2010 9:49 AM -
The problem was with SQLBrowser component.Sunday, September 5, 2010 9:50 AM
-
Hi Nasreddine,
The problem was with SQLBrowser component.
Did you mean you have solved this issue?
If this issue still exists, please feel free to let me know.
Regards,
Tom LiTuesday, September 7, 2010 6:08 AM -
Yes the problem still exist and I am looking for a solution. any help ?Tuesday, September 7, 2010 9:06 AM
-
Hi Nasreddine,
If we want to use .sdf file in Visual Studio, please make sure the driver for SQL Server Compact 3.5 SP2 is installed correctly.
I recommend that you uninstall driver for SQL Server Compact 3.5 SP2, then download it from this link and try again: http://www.microsoft.com/downloads/details.aspx?familyid=E497988A-C93A-404C-B161-3A0B323DCE24&displaylang=en
For further investigation on the installation issue, could you please provide us the error messages logged into the setup log files which are located in the %Program files%\Microsoft SQL server\100\Setup bootstrap\Log\ folder by sending mail to _sqltnsp_at_microsoft_dot_com_(please replace dot with dot sign) with the following format:#Sample
Subject: MSDN/TechNet forum question: <Thread Title>
Attachments: <files>
Hi Tom,
ThreadURL:<URL>
<Additional information>
#End
For more information about "How to View and Read SQL Server Setup Log Files:", you could refer to this link: http://msdn.microsoft.com/en-us/library/ms143702.aspx
If anything is unclear, please let me know.
Regards,
Tom Li- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 16, 2013 4:28 PM
Tuesday, September 7, 2010 10:38 AM