Question

Gautam.75801 on Thu, 07 Aug 2014 05:55:39


Hi All,

I installed my SQL server Express setup 2008 r2. The installation failed but i am still able to use SQL.

Then i upgraded the Express to Data center edition

I wanted to install SQL 2008 r2 sp1 when i install it says cannot upgrade please repair your existing SQL setup.

When i installed it said File missing 2 times and the same while repair.

Below is the screen shot of the error after setup completion and the error log.

Can Anyone tell me what to do next please.

If you feel the setup is corrupt then can any one please tell me where can i download SQL Server 2008 r2 Data center edition

I have a product key of my company to license it 

===================================

Log content

=================================

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -595541211
  Exit facility code:            1152
  Exit error code:               49957
  Exit message:                  Failed: see details below
  Start time:                    2014-08-07 01:11:15
  End time:                      2014-08-07 01:25:36
  Requested action:              Repair
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140807_010700\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.4000.0%26EvtType%3d0xCEC86A55%400xDC80C325

Machine Properties:
  Machine name:                  AIRWATCHPOC
  Machine processor count:       4
  OS version:                    Future Windows Version
  OS service pack:               
  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 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Data Center Edition  10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Data Center Edition  10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Data Center Edition  10.50.1600.1    No        
  Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Data Center Edition  10.50.1600.1    No        
  Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Data Center 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:                       1
  Installation location:         E:\Test\x64\setup\
  Installation edition:          DATA_CENTER

User Input Settings:
  ACTION:                        Repair
  AGTDOMAINGROUP:                <empty>
  AGTSVCACCOUNT:                 E2KLAB\GMCSAACCT
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Automatic
  ASCONFIGDIR:                   Config
  ASDOMAINGROUP:                 <empty>
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 *****
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140807_010700\ConfigurationFile.ini
  ENU:                           True
  FAILOVERCLUSTERGROUP:          <empty>
  FAILOVERCLUSTERNETWORKNAME:    <empty>
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
  FTSVCPASSWORD:                 *****
  HELP:                          False
  INDICATEPROGRESS:              False
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  PASSPHRASE:                    *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  SQLDOMAINGROUP:                <empty>
  SQLSVCACCOUNT:                 <empty>
  SQLSVCPASSWORD:                *****
  UIMODE:                        Normal
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140807_010700\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:      0xDC80C325
  Configuration error description: The system cannot find the file specified
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140807_010700\Detail.txt

  Feature:                       SQL Client Connectivity
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Client Connectivity SDK
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Writer
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Browser
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Full-Text Search
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xDC80C325
  Configuration error description: The system cannot find the file specified
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140807_010700\Detail.txt

  Feature:                       Reporting Services
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Compact Edition Tools
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Compact Edition Runtime
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Management Tools - Complete
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Management Tools - Basic
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Passed

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140807_010700\SystemConfigurationCheck_Report.htm

The following warnings were encountered while configuring settings on your SQL Server.  These resources / settings were missing or invalid so default values were used in recreating the missing resources.  Please review to make sure they don’t require further customization for your applications:

Service SID support has been enabled on the service.
Service SID support has been enabled on the service.


Gautam.75801



Sponsored



Replies

Olaf Helper on Thu, 07 Aug 2014 06:31:52


  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
...
  Configuration error description: The system cannot find the file specified
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140807_010700\Detail.txt

Hello,

Please check also that log file for further details.

I suggest to uninstall SQL Server completly and re-install it; it's faster and more secure then a repair.

Shanky_621 on Thu, 07 Aug 2014 08:54:30


Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Data Center Edition  10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Data Center Edition  10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Data Center Edition  10.50.1600.1    No        
  Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Data Center Edition  10.50.1600.1    No        
  Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Data Center Edition  10.50.1600.1    No        

Package properties:
  Description:                   SQL Server Database Services 2008 R2
                 0

Gautam.75801


Hi,

As per logs you already have Data center installation present for SQL server 2008 r2. You need to manually remove this from add remove program. Take help of this link to uninstall SQL Server 2008 r2.

Also as noted by Olaf C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140807_010700\Detail.txt details.txt file would tell us more information. refer to it. You can post it on skydrive/shared location for analysis



Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

My TechNet Wiki Articles


Gautam.75801 on Thu, 07 Aug 2014 20:02:02


Hi Olaf / Shanky,

Thank you for your valuable time in providing various steps to investigate the issue further.

But i found the solution. Getting the setup for SQL server 2008 r2 Datacenter edition directly in the internet was very difficult. But some how i got 1.  When i go and install the express edition from the downloaded setup. Where it asks me for the product key i selected the express edition as i did not have the product key with me. Later i used the same setup to upgrade the edition.

This error comes when i install the express edition from the installation setup.
In case in the beginning only if i enter the CD KEY instead of selecting express edition the installation is successful without Zero errors and also the SP1 installs fine with Zero errors.

Hence i un installed it fully and installed a fresh copy by entering the CD Key

So the conclusion is - There is a issue or missing file in the setup when i install the express version.
And when i install the same setup by giving the product key everything is fine and green.

Thanks all for your valuable help and time.