none
Logon Failure while trying to install the SQL server 2008 R2 RRS feed

  • שאלה

  • hi,

    I was trying to install the sql server 2008 R2

    the exe file is: SQLFULL_x86_ENU.

    at the end of the installation, I've got the following message

    "the service did not start due to logon failure

    The installation log is pasted at the end of this message.

    Anyway, I must say that I have already install the SQL server management 2008 on the same PC and uninstall it due to I wanted to install the Express edition.

    but now, as I described above, it failed to be installed.

     

    Thanks,

    Efi

     

    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-10-18 13:22:26
      End time:                      2010-10-18 15:42:26
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101018_132001\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%3d0xB4A84AA1%400xC24842DB

    Machine Properties:
      Machine name:                  GUY
      Machine processor count:       2
      OS version:                    Windows XP
      OS service pack:               Service Pack 3
      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
      Sql Server 2008 R2   SQLEXPRESS           MSSQL10_50.SQLEXPRESS          Database Engine Services                 1033                 Express Edition      10.50.1600.1    No       
      Sql Server 2008 R2   SQLEXPRESS           MSSQL10_50.SQLEXPRESS          SQL Server Replication                   1033                 Express Edition      10.50.1600.1    No       
      Sql Server 2008 R2   SQLEXPRESS           MSSQL10_50.SQLEXPRESS          Full-Text Search                         1033                 Express Edition      10.50.1600.1    No       
      Sql Server 2008 R2   SQLEXPRESS           MSRS10_50.SQLEXPRESS           Reporting Services                       1033                                      10.50.1600.1    No       
      Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Express Edition      10.50.1600.1    No       

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         C:\Documents and Settings\shakti bansuri\My Documents\downloads\x86\setup\
      Installation edition:          EXPRESS_ADVANCED

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      False
      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:         Disabled
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101018_132001\ConfigurationFile.ini
      CUSOURCE:                     
      ENABLERANU:                    True
      ENU:                           True
      ERRORREPORTING:                True
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SQLENGINE,REPLICATION,FULLTEXT,RS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  efi
      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:                    MSSQLSERVER
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PCUSOURCE:                    
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      ROLE:                          <empty>
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  GUY\efi
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  Hebrew_CI_AS
      SQLSVCACCOUNT:                 efi
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           GUY\efi
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  True
      TCPENABLED:                    0
      UIMODE:                        Normal
      X86:                           False

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101018_132001\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:      0xC24842DB
      Configuration error description: The service did not start due to a logon failure. 
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101018_132001\Detail.txt

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0xC24842DB
      Configuration error description: The service did not start due to a logon failure. 
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101018_132001\Detail.txt

      Feature:                       Full-Text Search
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0xC24842DB
      Configuration error description: The service did not start due to a logon failure. 
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101018_132001\Detail.txt

      Feature:                       Reporting Services
      Status:                        Failed: see logs for details
      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\20101018_132001\SystemConfigurationCheck_Report.htm

    יום שני 18 אוקטובר 2010 16:26

כל התגובות

  • היי גיא,

    על פי הלוגים רואים שהגדרת את ה SERVICES לעלות עם NT AUTHORITY\NETWORK SERVICE
    תנסה לשנות ל SYSTEM ותראה אם זה עוזר.

    אתה יכול להתקין מחדש או להכנס ל Services.msc ולשנות ידנית.

     


    Ami Levin, SQL Server MVP. CTO, DBSophic LTD. - http://www.dbsophic.com/ --Performance is the most significant driver in maintaining data and service availability.--
    • הוצע כתשובה על-ידי DanMaxic יום חמישי 07 אפריל 2011 22:41
    יום רביעי 20 אוקטובר 2010 14:04
  • נראה כאילו ההתקנה נכשלה לחלוטין, לכן לא נראה את השירותים שלSQL כלל,

     מציע לך לעקוב לפי ההוראות של MSDN:

    http://msdn.microsoft.com/en-us/library/ms143219.aspx

     

    בברכה,

    לכל שאלה אנו כאן :)

    דניאל


    יום חמישי 07 אפריל 2011 22:43