locked
Probem after installing SQL server 2008 R2 express edition RRS feed

  • 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
    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.com
    Saturday, 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 Li
    Tuesday, 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
    Tuesday, September 7, 2010 10:38 AM