Web Platform- Database

Question

Using Web Platform Installer 2.0, I tried installing 

1. SQL Server Express 2008 R2 (Failed to install)

2. SQL Server 2008 R2 Management Studio Express (Failed to install)

3. SQL Server 2008 Management Objects (Successfully installed)

 

The logs say

 

Summary.txt

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):           -2068578304

  Exit facility code:            1204

  Exit error code:               0

  Exit message:                  Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted).

  Requested action:              Install

Machine Properties:

  Machine processor count:       2

  OS version:                    Windows XP

  OS service pack:               Service Pack 3

  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:         c:\b9606f109ad5d7c9abd6\x86\setup\

  Installation edition:          EXPRESS_ADVANCED

User Input Settings:

  ACTION:                        Install

  ADDCURRENTUSERASSQLADMIN:      True

  AGTSVCACCOUNT:                 <empty>

  AGTSVCPASSWORD:                *****

  AGTSVCSTARTUPTYPE:             Manual

  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:             

  CUSOURCE:                      

  ENABLERANU:                    False

  ENU:                           True

  ERRORREPORTING:                False

  FARMACCOUNT:                   <empty>

  FARMADMINPORT:                 0

  FARMPASSWORD:                  *****

  FEATURES:                      SSMS

  FILESTREAMLEVEL:               0

  FILESTREAMSHARENAME:           <empty>

  FTSVCACCOUNT:                  <empty>

  FTSVCPASSWORD:                 *****

  HELP:                          False

  IACCEPTSQLSERVERLICENSETERMS:  True

  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:                    <empty>

  INSTANCENAME:                  <empty>

  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService

  ISSVCPASSWORD:                 *****

  ISSVCSTARTUPTYPE:              Automatic

  NPENABLED:                     0

  PASSPHRASE:                    *****

  PCUSOURCE:                     

  PID:                           *****

  QUIET:                         True

  QUIETSIMPLE:                   False

  ROLE:                          AllFeatures_WithDefaults

  RSINSTALLMODE:                 FilesOnlyMode

  RSSVCACCOUNT:                  <empty>

  RSSVCPASSWORD:                 *****

  RSSVCSTARTUPTYPE:              Automatic

  SAPWD:                         *****

  SECURITYMODE:                  <empty>

  SQLBACKUPDIR:                  <empty>

  SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS

  SQLSVCACCOUNT:                 <empty>

  SQLSVCPASSWORD:                *****

  SQLSVCSTARTUPTYPE:             Automatic

  SQLSYSADMINACCOUNTS:           <empty>

  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\20100628_171039\ConfigurationFile.ini

Detailed results:

  Feature:                       Management Tools - Basic

  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\20100628_171039\SystemConfigurationCheck_Report.htm

Exception summary:

The following is an exception stack listing the exceptions in outermost to innermost order

Inner exceptions are being indented

Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException

    Message: 

        Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted).

    Data: 

      SQL.Setup.FailureCategory = InputSettingValidationFailure

      DisableWatson = true

    Stack: 

        at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.LogAllValidationErrorsAndThrowFirstOne(ValidationState vs)

        at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)

        at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

        at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

    Inner exception type: Microsoft.SqlServer.Configuration.Sco.DirectoryAttributesMissmatch

        Message: 

                Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted).

webpi14.txt

DownloadManager Information: 0 : Loading product xml from 'https://go.microsoft.com/fwlink/?LinkId=193533'

DownloadManager Information: 0 : Product manager downloading: https://go.microsoft.com/fwlink/?LinkId=193533

DownloadManager Information: 0 : Loading product xml from 'https://www.microsoft.com/web/webpi/2.0/WebApplicationList.xml'

DownloadManager Information: 0 : Product manager downloading: https://www.microsoft.com/web/webpi/2.0/WebApplicationList.xml

DownloadManager Information: 0 : Filtering by majorOS: 5, minorOS: 1, majorSP: 3, minorSP: 0, productType: 1, architecture: x86

DownloadManager Information: 0 : Filtering by majorOS: 5, minorOS: 1, majorSP: 3, minorSP: 0, productType: 1, architecture: x86

DownloadManager Information: 0 : Adding product SQL Server Express 2008 R2 (SQLExpress) to cart

DownloadManager Information: 0 : Product 'SQLExpress' was already in cart.

DownloadManager Information: 0 : Configuring SQL

DownloadManager Information: 0 : Using SQL mixed mode authentication

DownloadManager Information: 0 : No MySQL to configure

DownloadManager Information: 0 : Setting current install to 1

DownloadManager Information: 0 : Starting install sequence

DownloadManager Information: 0 : Install exit code for product 'SQL Server Express 2008 R2' is -2068578304

DownloadManager Error: 0 : Install return code for product 'SQL Server Express 2008 R2' is Failure

DownloadManager Information: 0 : Product SQL Server Express 2008 R2 done install completed

DownloadManager Information: 0 : Increasing current install to 2

DownloadManager Information: 0 : Clearing cart

DownloadManager Information: 0 : Adding product SQL Server Express 2008 R2 (SQLExpress) to cart

DownloadManager Information: 0 : Removing product SQL Server Express 2008 R2 (SQLExpress) from cart

DownloadManager Information: 0 : Adding product SQL Server Express 2008 R2 (SQLExpress) to cart

DownloadManager Information: 0 : Removing product SQL Server Express 2008 R2 (SQLExpress) from cart

DownloadManager Information: 0 : Adding product SQL Server Express 2008 R2 (SQLExpress) to cart

DownloadManager Information: 0 : Adding product SQL Server 2008 R2 Management Studio Express (SQLManagementStudio) to cart

DownloadManager Information: 0 : Adding product SQL Server 2008 Management Objects (SMO) to cart

DownloadManager Information: 0 : Product 'SQLExpress' was already in cart.

DownloadManager Information: 0 : Product 'SQLManagementStudio' was already in cart.

DownloadManager Information: 0 : Product 'SMO' was already in cart.

DownloadManager Information: 0 : Adding dependency 'SQLNativeClient' for product 'SMO'

DownloadManager Information: 0 : Product 'SQLNativeClient' being added to install list

DownloadManager Information: 0 : Configuring SQL

DownloadManager Information: 0 : Using SQL mixed mode authentication

DownloadManager Information: 0 : No MySQL to configure

DownloadManager Information: 0 : Setting current install to 1

DownloadManager Information: 0 : Starting install sequence

DownloadManager Information: 0 : MSI install return value for product 'SQL Server Native Client' is 0

DownloadManager Information: 0 : Install return code for product 'SQL Server Native Client' is Success

DownloadManager Information: 0 : Product SQL Server Native Client done install completed

DownloadManager Information: 0 : Increasing current install to 2

DownloadManager Information: 0 : MSI install return value for product 'SQL Server 2008 Management Objects' is 0

DownloadManager Information: 0 : Install return code for product 'SQL Server 2008 Management Objects' is Success

DownloadManager Information: 0 : Product SQL Server 2008 Management Objects done install completed

DownloadManager Information: 0 : Increasing current install to 3

DownloadManager Information: 0 : Install exit code for product 'SQL Server Express 2008 R2' is -2068578304

DownloadManager Error: 0 : Install return code for product 'SQL Server Express 2008 R2' is Failure

DownloadManager Information: 0 : Product SQL Server Express 2008 R2 done install completed

DownloadManager Information: 0 : Increasing current install to 4

DownloadManager Information: 0 : Install exit code for product 'SQL Server 2008 R2 Management Studio Express' is -2068578304

DownloadManager Error: 0 : Install return code for product 'SQL Server 2008 R2 Management Studio Express' is Failure

DownloadManager Information: 0 : Product SQL Server 2008 R2 Management Studio Express done install completed

DownloadManager Information: 0 : Increasing current install to 5

Please let me know what the issue is.

Thanks!

 

Answer 1

Hi Pradeep,

 

From the setup log of “SQL Server Management Studio Express” (SSMSE), we have seen the following error messages:

Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted).

 

From the error message, it seems that the folder has “Compressed” attribute. However the SSMSE has to be installed on a folder without attribute “Compressed”. If we install it to a folder with “Compressed” attribute, the installation will fail.

 

In the case of this folder is compressed, please follow the steps below:

1.       Right-click the folder and select “Properties”
generally, the SSMSE will be installed on this folder: C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

2.       In the tab of “General”, please click “Advanced…” button

3.       In the “Advanced Attributes” dialog, please uncheck “Compress contents to save disk space” and click “OK”
meanwhile, if “Folder is ready for archiving” and “Encrypt contents to secure data” is checked too, please uncheck them too.

4.       In the “Properties” dialog, “Click OK”

5.       In the dialog of “Confirm Attribute Changes” popup, please select “Apply changes to this folder, subfolders and files” and click “OK”

 

If there is anything unclear, please let me know.

Answer 2

Thank you so much for the response.

I followed the 5 steps and the installation went through successfully.