Install error: Unknown Property

질문하기

2011년 12월 15일 목요일 오후 7:09

0
This is a single user installation. OS is Windows7 Professional. Processpr is 64-bit. I'm trying to install the SQL2008R2 Enterprise that comes with the Dynamics products. When trying to install the 64-bit version, I am not allowed to change the shared feature directory which is defaulted to the Program Files(x86) folder for both 32 and 64 bit. Switching to the 32-bit installation, I get past that point and start to actually install the software when I receive an error:

SQL Server Setup has encounterd the following error:

Unknown property.

.

The Windows Event log entry shows:

Log Name:      Application
Source:        Windows Error Reporting
Date:          12/15/2011 9:22:00 AM
Event ID:      1001
Task Category: None
Level:         Information
Keywords:      Classic
User:          N/A
Computer:      Accounting1
Description:
Fault bucket , type 0
Event Name: SQL100Exception
Response: Not available
Cab Id: 0

Problem signature:
P1: SQL Server 2008 R2@RTM@
P2: 0xCDDA72F9
P3: 0xCDDA72F9
P4: 0xC24842DB
P5: 0xC24842DB
P6: Install_sqlncli
P7: Unknown
P8: Unknown
P9: Unknown
P10: Unknown

Attached files:
C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111215_091749\Watson_1\LogFiles.cab

These files may be available here:
C:\ProgramData\Microsoft\Windows\WER\ReportArchive\Critical_SQL Server 2008 _799490d4b44292db7c672e3e4bf764fb84a571_020cedf7

Analysis symbol:
Rechecking for solution: 0
Report Id: 252f3e2f-2728-11e1-b62f-d067e513fe17
Report Status: 1
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Windows Error Reporting" />
    <EventID Qualifiers="0">1001</EventID>
    <Level>4</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2011-12-15T14:22:00.000000000Z" />
    <EventRecordID>4661</EventRecordID>
    <Channel>Application</Channel>
    <Computer>Accounting1</Computer>
    <Security />
</System>
<EventData>
    <Data>
    </Data>
    <Data>0</Data>
    <Data>SQL100Exception</Data>
    <Data>Not available</Data>
    <Data>0</Data>
    <Data>SQL Server 2008 R2@RTM@</Data>
    <Data>0xCDDA72F9</Data>
    <Data>0xCDDA72F9</Data>
    <Data>0xC24842DB</Data>
    <Data>0xC24842DB</Data>
    <Data>Install_sqlncli</Data>
    <Data>Unknown</Data>
    <Data>Unknown</Data>
    <Data>Unknown</Data>
    <Data>Unknown</Data>
    <Data>
C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111215_091749\Watson_1\LogFiles.cab</Data>
    <Data>C:\ProgramData\Microsoft\Windows\WER\ReportArchive\Critical_SQL Server 2008 _799490d4b44292db7c672e3e4bf764fb84a571_020cedf7</Data>
    <Data>
    </Data>
    <Data>0</Data>
    <Data>252f3e2f-2728-11e1-b62f-d067e513fe17</Data>
    <Data>1</Data>
</EventData>
</Event>

Thanks for your assistance!

Stuart Nottingham
- 이동됨 Sethu SrinivasanMicrosoft Employee, Moderator 2012년 8월 13일 월요일 오전 12:53 setup issue (From:Getting started with SQL Server)
- 응답
- 인용

모든 응답

2011년 12월 15일 목요일 오후 9:42

중재자

0

Hi Stuart, can you post the contents of the summary.txt file which is by default found here:

%programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\

That should hopefully contain a more readable error message.

Thanks,
Sam Lester (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
- 응답
- 인용
2011년 12월 16일 금요일 오후 12:45

0

Sam, I'm including the contents of two files. The first is the summary text from the 64-bit installation attempt. It will show that I canceled the process which I did when I couldn't change the shared resource directory for the 64-bit components. The second is the 32-bit attempt showing the Unknown Property error.

64-Bit Summary

Overall summary:
Final result:                  User cancelled
Exit code (Decimal):           -2068380094
Exit facility code:            1207
Exit error code:               1602
Exit message:                  User has cancelled.
Start time:                    2011-12-15 10:04:29
End time:                      2011-12-15 10:05:17
Requested action:              Install

Machine Properties:
Machine name:                  ACCOUNTING1
Machine processor count:       4
OS version:                    Windows 7
OS service pack:               Service Pack 1
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 2005      MSSQLSERVER          MSSQL.1                        Database Engine Services                 1033                 Standard Edition     9.3.4035        No
Sql Server 2005      MSSQLSERVER          MSSQL.1                        SQL Server Replication                   1033                 Standard Edition     9.3.4035        No
Sql Server 2005      MSSQLSERVER          MSSQL.1                        Full-Text Search                         1033                 Standard Edition     9.3.4035        No
Sql Server 2005      MSSQLSERVER          MSSQL.1                        SharedTools                              1033                 Standard Edition     9.3.4035        No
Sql Server 2005                                                          Tools                                    1033                 Standard Edition     9.3.4035        No
Sql Server 2005                                                          ToolsClient                              1033                 Standard Edition     9.3.4035        No
Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Standard Edition     9.3.4035        No
Sql Server 2005                                                          ToolsDocument                            1033                 Standard Edition     9.3.4035        No
Sql Server 2005                                                          ToolsDocument\BOL                        1033                 Standard Edition     9.3.4035        No

Package properties:
Description:                   SQL Server Database Services 2008 R2
ProductName:                   SQL Server 2008 R2
Type:                          RTM
Version:                       10
SPLevel:                       0
Installation location:         D:\x64\setup\
Installation edition:          STANDARD

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:                      SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS
FILESTREAMLEVEL:               0
FILESTREAMSHARENAME:           <empty>
FTSVCACCOUNT:                  <empty>
FTSVCPASSWORD:                 *****
HELP:                          False
IACCEPTSQLSERVERLICENSETERMS: False
INDICATEPROGRESS:              False
INSTALLSHAREDDIR:              C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\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:                         False
QUIETSIMPLE:                   False
ROLE:                          AllFeatures_WithDefaults
RSINSTALLMODE:                 FilesOnlyMode
RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
RSSVCPASSWORD:                 *****
RSSVCSTARTUPTYPE:              Automatic
SAPWD:                         *****
SECURITYMODE:                  <empty>
SQLBACKUPDIR:                  <empty>
SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
SQLSVCPASSWORD:                *****
SQLSVCSTARTUPTYPE:             Automatic
SQLSYSADMINACCOUNTS:           <empty>
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\20111215_100337\ConfigurationFile.ini

Detailed results:
Feature:                       Database Engine Services
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       SQL Client Connectivity SDK
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       SQL Server Replication
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Full-Text Search
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Analysis Services
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Reporting Services
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Integration Services
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Client Tools Connectivity
Status:                        Failed: see logs for details
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

Feature:                       Client Tools SDK
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Client Tools Backwards Compatibility
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Business Intelligence Development Studio
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       SQL Server Books Online
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Microsoft Sync Framework
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\20111215_100337\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.CancelException
    Message:
        User has cancelled.
    Stack:
        at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
        at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
        at Microsoft.SqlServer.Configuration.UIExtension.WaypointAction.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)
- 응답
- 인용
2011년 12월 16일 금요일 오후 12:47

0

*********************************************************************************************************
32-bit Summary

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): 1570409569
Exit facility code: 1434
Exit error code: 35937
Exit message: Unknown property.
Start time: 2011-12-15 09:18:36
End time: 2011-12-15 09:22:00
Requested action: Install
Log with failure: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111215_091749\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%3d0xCDDA72F9%400xC24842DB

Machine Properties:
Machine name: ACCOUNTING1
Machine processor count: 4
OS version: Windows 7
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 32 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 MSSQLSERVER MSSQL.1 Database Engine Services 1033 Standard Edition 9.3.4035 No
Sql Server 2005 MSSQLSERVER MSSQL.1 SQL Server Replication 1033 Standard Edition 9.3.4035 No
Sql Server 2005 MSSQLSERVER MSSQL.1 Full-Text Search 1033 Standard Edition 9.3.4035 No
Sql Server 2005 MSSQLSERVER MSSQL.1 SharedTools 1033 Standard Edition 9.3.4035 No
Sql Server 2005 Tools 1033 Standard Edition 9.3.4035 No
Sql Server 2005 ToolsClient 1033 Standard Edition 9.3.4035 No
Sql Server 2005 ToolsClient\Connectivity 1033 Standard Edition 9.3.4035 No
Sql Server 2005 ToolsDocument 1033 Standard Edition 9.3.4035 No
Sql Server 2005 ToolsDocument\BOL 1033 Standard Edition 9.3.4035 No

Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation location: D:\x86\setup\
Installation edition: STANDARD

User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: True
AGTSVCACCOUNT: NT AUTHORITY\SYSTEM
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: C:\Program Files (x86)\Microsoft SQL Server\MSAS10_50.SL2011\OLAP\Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: C:\Program Files (x86)\Microsoft SQL Server\MSAS10_50.SL2011\OLAP\Config
ASDATADIR: C:\Program Files (x86)\Microsoft SQL Server\MSAS10_50.SL2011\OLAP\Data
ASDOMAINGROUP: <empty>
ASLOGDIR: C:\Program Files (x86)\Microsoft SQL Server\MSAS10_50.SL2011\OLAP\Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: NT AUTHORITY\SYSTEM
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: Accounting1\Owner
ASTEMPDIR: C:\Program Files (x86)\Microsoft SQL Server\MSAS10_50.SL2011\OLAP\Temp
BROWSERSVCSTARTUPTYPE: Automatic
CONFIGURATIONFILE: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111215_091749\ConfigurationFile.ini
CUSOURCE:
ENABLERANU: False
ENU: True
ERRORREPORTING: False
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FEATURES: SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: False
IACCEPTSQLSERVERLICENSETERMS: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTANCEID: SL2011
INSTANCENAME: SL2011
ISSVCACCOUNT: NT AUTHORITY\SYSTEM
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: SQL
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: NT AUTHORITY\SYSTEM
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: Accounting1\Owner
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: False
TCPENABLED: 1
UIMODE: Normal
X86: True

Configuration file: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111215_091749\ConfigurationFile.ini

Detailed results:
Feature: SQL Client Connectivity SDK
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Full-Text Search
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Analysis Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Reporting Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Integration Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Client Tools Connectivity
Status: Failed: see logs for details
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

Feature: Client Tools SDK
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Client Tools Backwards Compatibility
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Business Intelligence Development Studio
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: SQL Server Books Online
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Microsoft Sync Framework
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 (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111215_091749\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: System.ComponentModel.Win32Exception
Message:
Unknown property.

Data:
DisableWatson = true
Stack:
at Microsoft.SqlServer.Chainer.Infrastructure.MsiNativeMethodHelpers.GetInstalledSummaryInformationStringProperty(ServiceContainer context, String productCode, SummaryInformationStreamPropertySet propertyId)
at Microsoft.SqlServer.Configuration.SetupExtension.MsiInstallEngineActionBehavior.ModifyAction(String installedProductCode, String installedProductVersion, String pathOfPackageOnMedia, InstallAction pkgAction)
at Microsoft.SqlServer.Configuration.SetupExtension.MSIInstallerEngine.InstallPackage(PackageId pkg, InstallAction pkgAction)
at Microsoft.SqlServer.Configuration.MsiExtension.PackageInstallAction.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
**********************************************************************************************************

Stuart
- 응답
- 인용
2011년 12월 20일 화요일 오전 2:25

중재자

0

Hi Stuart,

From the logs, we need another log file, please post the file in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ 20111215_091749\Detail.txt.
Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- 응답
- 인용
2012년 4월 8일 일요일 오후 11:45

0

I am also having this issue when trying to install sql 2008 R2 on Windows 7 Ultimate.

How do I go about resolving this issue?

MDi
- 응답
- 인용
2012년 8월 3일 금요일 오후 4:40

0

Each time I install SQL 2008 R2, I always remember to remove any existing "Microsoft SQL Server Compact 3.5 SP2 ENU" instances from programs and features - using the "Windows Install Cleanup" utility if needed. The SQL 2008 install will put its own version back.

This has been 100% of the issues with installing SQL 2008 or SQL 2008 R2, for me.

Remove Microsoft SQL Server Compact 3.5 SP2 ENU first !!
- 응답
- 인용