Thursday, March 3, 2011

SQL Server 2008 R2 Express

Three Hours later...

What a bunch of USELESS CRAP!



For those who lack a life, the text in the box below is...



The following notes apply to this release of SQL Server only.



Microsoft Update



For information about how to use Microsoft Update to identify updates for SQL Server 2008 R2, see the Microsoft Update Web site at http://go.microsoft.com/fwlink/?LinkId=108409.



Samples



By default, sample databases and sample code are not installed as part of SQL Server Setup. To install sample databases and sample code for non-Express editions of SQL Server 2008 R2, see the CodePlex Web site at http://go.microsoft.com/fwlink/?LinkId=87843. To read about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview on the CodePlex Web site at http://go.microsoft.com/fwlink/?LinkId=110391.



Release Notes



For more information about late-breaking changes in this release of SQL Server, see the latest readme file at http://go.microsoft.com/fwlink/?LinkId=141691.



Documentation and Links



To install the .NET Framework SDK, see “Installing the .NET Framework SDK” in SQL Server 2008 R2 Books Online at http://go.microsoft.com/fwlink/?LinkId=141693.



For information about SQL Server 2008 R2 Surface Area Configuration, see the following SQL Server 2008 R2 documentation topics:



In SQL Server 2008 R2 Books Online: “Understanding Surface Area Configuration.”



In SQL Server 2008 R2 Setup Help: “Minimize SQL Server 2008 R2 Surface Area.”



In SQL Server 2008 R2 Books Online on MSDN: Understanding Surface Area Configuration at http://go.microsoft.com/fwlink/?LinkId=141692.
And the log file it left says



Overall summary:

  Final result:                  Failed: see details below

  Exit code (Decimal):           -2068052398

  Exit facility code:            1212

  Exit error code:               1618

  Exit message:                  Failed: see details below

  Start time:                    2011-03-03 15:55:52

  End time:                      2011-03-03 16:52:14

  Requested action:              Upgrade

  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110303_155335\sql_engine_core_inst_ctp6_Cpu32_1.log

  Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1



Machine Properties:

  Machine name:                  WEB1

  Machine processor count:       2

  OS version:                    Windows Server 2003

  OS service pack:               Service Pack 2

  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      SQLEXPRESS           MSSQL10.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      10.1.2531.0     No       

  Sql Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             SQL Server Replication                   1033                 Express Edition      10.1.2531.0     No       

  Sql Server 2008                                                          Management Tools - Basic                 1033                 Express Edition      10.0.1600.22    No       



Package properties:

  Description:                   SQL Server Database Services 2008 R2

  ProductName:                   SQL Server 2008 R2

  Type:                          RTM

  Version:                       10

  SPLevel:                       0

  Installation location:         d:\bf7ec28684b1818f6c3151c67288a7c8\x86\setup\

  Installation edition:          EXPRESS_ADVANCED



User Input Settings:

  ACTION:                        Upgrade

  AGTDOMAINGROUP:                <empty>

  BROWSERSVCSTARTUPTYPE:         Automatic

  CONFIGURATIONFILE:            

  CUSOURCE:                     

  ENU:                           True

  ERRORREPORTING:                False

  FAILOVERCLUSTERROLLOWNERSHIP:  2

  FARMACCOUNT:                   <empty>

  FARMADMINPORT:                 0

  FARMPASSWORD:                  *****

  FTSVCACCOUNT:                  <empty>

  FTSVCPASSWORD:                 *****

  FTUPGRADEOPTION:               Import

  HELP:                          False

  IACCEPTSQLSERVERLICENSETERMS:  False

  INDICATEPROGRESS:              False

  INSTANCEID:                    SQLEXPRESS

  INSTANCENAME:                  SQLEXPRESS

  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService

  ISSVCPASSWORD:                 *****

  ISSVCSTARTUPTYPE:              Automatic

  PASSPHRASE:                    *****

  PCUSOURCE:                    

  PID:                           *****

  QUIET:                         False

  QUIETSIMPLE:                   False

  RSCATALOGSERVERINSTANCENAME:   Unknown

  RSUPGRADEDATABASEACCOUNT:     

  RSUPGRADEPASSWORD:             *****

  SQLDOMAINGROUP:                <empty>

  SQMREPORTING:                  True

  UIMODE:                        AutoAdvance

  X86:                           False



  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110303_155335\ConfigurationFile.ini



Detailed results:

  Feature:                       Database Engine Services

  Status:                        Passed

  MSI status:                    Passed

  Configuration status:          Passed



  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:                       SQL Server Replication

  Status:                        Passed

  MSI status:                    Passed

  Configuration status:          Passed



  Feature:                       SQL Compact Edition Runtime

  Status:                        Passed

  MSI status:                    Passed

  Configuration status:          Passed



  Feature:                       Management Tools - Basic

  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\20110303_155335\SystemConfigurationCheck_Report.htm









Bryan Valencia is a contributing editor and founder of Visual Studio Journey.  He owns and operates Software Services, a web design and hosting company in Manteca, California.

No comments:

Post a Comment

How to Auto-generate Order Line Item numbers for bulk uploads

 I had a problem where I had 17000 line items to insert into 9000 orders. The system required line item numbers, preferably numbered 1throug...