Home > Forums > Web Platform > Web Platform Installer > SQL Server with Advanced Services install Error

Thread: SQL Server with Advanced Services install Error

Last post 10-02-2009 10:42 AM by richma. 4 replies.

Average Rating Rate It (5)Thank you for the rating!

RSS

Page 1 of 1 (5 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

09-29-2009, 10:17 AM

ddettler
Joined on 09-29-2009, 2:15 PM
Posts 3

SQL Server with Advanced Services install Error

Reply Contact

I am running Windows Vista and am receiving the following errors when installing SQL Server 2008 Express with Advanced Services:

I looked into the provided link - http://support.microsoft.com/kb/300956 - for repairing the performance counter registry hive, but my PC doesn't have the specific files listed in the steps. Specifically the Perfc009.dat and Perfh009.dat. I am unsure how to proceed.

Machine Properties:
Machine name:                  DETTSPC
Machine processor count:       2
OS version:                    Windows Vista
OS service pack:               Service Pack 1
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

Package properties:
Description:                   SQL Server Database Services 2008
SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName:                   SQL2008
Type:                          RTM
Version:                       10
SPLevel:                       0
Installation location:         c:\d6d5ad117074069610b190b0ffdf7d\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:
ENABLERANU:                    True
ERRORREPORTING:                False
FEATURES:                      SQLENGINE,REPLICATION,FULLTEXT,RS,BIDS,SSMS
FILESTREAMLEVEL:               0
FILESTREAMSHARENAME:           <empty>
FTSVCACCOUNT:                  <empty>
FTSVCPASSWORD:                 *****
HELP:                          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:                    SQLEXPRESS
INSTANCENAME:                  SQLEXPRESS
ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
ISSVCPASSWORD:                 *****
ISSVCSTARTUPTYPE:              Automatic
MEDIASOURCE:                   c:\d6d5ad117074069610b190b0ffdf7d\
NPENABLED:                     0
PID:                           *****
QUIET:                         False
QUIETSIMPLE:                   True
RSINSTALLMODE:                 DefaultNativeMode
RSSVCACCOUNT:                  NT AUTHORITY\Network Service
RSSVCPASSWORD:                 *****
RSSVCSTARTUPTYPE:              Automatic
SAPWD:                         *****
SECURITYMODE:                  SQL
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:                  False
TCPENABLED:                    0
X86:                           False

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

Detailed results:
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:                       Reporting Services
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:                       Business Intelligence Development Studio
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\20090929_085013\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.Configuration.RulesEngineExtension.RulesEngineRuleFailureException
    Message:
        The performance counter registry hive is corrupted. To continue, you must repair the performance counter registry hive. For more information, see http://support.microsoft.com/kb/300956.
    Data:
      DisableWatson = true
    Stack:
        at Microsoft.SqlServer.Configuration.RulesEngineExtension.RunRulesAction.ExecuteAction(String actionId)
        at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
        at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
        at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

09-29-2009, 12:56 PM In reply to

ddettler
Joined on 09-29-2009, 2:15 PM
Posts 3

Re: SQL Server with Advanced Services install Error

Reply Contact

When I run the System Configuration Checker from the SQL Installation Center, I receive one rule failure:

'Performance counter registry hive consistency'

Any thoughts on how to correct?

09-29-2009, 10:58 PM In reply to

richma
Joined on 04-06-2009, 12:10 PM
Posts 373

Re: SQL Server with Advanced Services install Error

Reply Contact

Hi Ddettler ,

On Vista you can try the following to rebuild the counters

1. Click Start, expand All Programs, and expand Accessories.
2.Right-click Command Prompt, and then click Run as administrator.
3.At the command prompt, type lodctr /r, and then press ENTER.
Reference : http://technet.microsoft.com/en-us/library/cc774958.aspx

4. Test your SQL installation.

If that does not resolve the issue and your are non-english system I found the following post that may also aply , but I have never tried this before.

http://blogs.msdn.com/joaol/archive/2008/12/18/sql-server-2008-performance-counters-registry-hive-consistency-fails-on-non-english-operating-systems.aspx

Thanks

Richard

10-01-2009, 4:12 PM In reply to

ddettler
Joined on 09-29-2009, 2:15 PM
Posts 3

Re: SQL Server with Advanced Services install Error

Reply Contact

I am using an English version and successfully rebuilt the counters using the command prompt. After uninstalling any related SQL 2008 components, I attempted to reinstall. It seemed as though it was going to be successful because it took considerable longer and went through the install process, but I received the same failure to install window. However, it seems to be a different error, below are the 2 logs:

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):           -2068643839
Exit facility code:            1203
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:                    2009-10-01 09:00:40
End time:                      2009-10-01 09:33:48
Requested action:              Install
Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091001_085532\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.0.1600.22%26EvtType%3d0x6121810A%400x5D9A8C61

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered

Package properties:
Description:                   SQL Server Database Services 2008
SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName:                   SQL2008
Type:                          RTM
Version:                       10
SPLevel:                       0
Installation location:         c:\3b46e366ca443cf28e712df4\x86\setup\
Installation edition:          EXPRESS_ADVANCED

User Input Settings:
ACTION:                        Install
ADDCURRENTUSERASSQLADMIN:      True
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\20091001_085532\ConfigurationFile.ini
ENABLERANU:                    True
ERRORREPORTING:                False
FEATURES:                      SQLENGINE,REPLICATION,FULLTEXT,RS,BIDS,SSMS
FILESTREAMLEVEL:               0
FILESTREAMSHARENAME:           <empty>
FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD:                 *****
HELP:                          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:                    SQLEXPRESS
INSTANCENAME:                  SQLEXPRESS
ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
ISSVCPASSWORD:                 *****
ISSVCSTARTUPTYPE:              Automatic
MEDIASOURCE:                   c:\3b46e366ca443cf28e712df4\
NPENABLED:                     0
PID:                           *****
QUIET:                         False
QUIETSIMPLE:                   True
RSINSTALLMODE:                 DefaultNativeMode
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:                  False
TCPENABLED:                    0
X86:                           False

Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091001_085532\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:      0x0A2FBD17@1211@1
Configuration error description: The specified group does not exist.
Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091001_085532\Detail.txt

Feature:                       SQL Server Replication
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Failed: see details below
Configuration error code:      0x0A2FBD17@1211@1
Configuration error description: The specified group does not exist.
Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091001_085532\Detail.txt

Feature:                       Full-Text Search
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Failed: see details below
Configuration error code:      0x0A2FBD17@1211@1
Configuration error description: The specified group does not exist.
Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091001_085532\Detail.txt

Feature:                       Reporting Services
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Failed: see details below
Configuration error code:      0x0A2FBD17@1211@1
Configuration error description: The specified group does not exist.
Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091001_085532\Detail.txt

Feature:                       Management Tools - Basic
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Business Intelligence Development Studio
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\20091001_085532\SystemConfigurationCheck_Report.htm

AND the 2nd log:

DownloadManager Information: 0 : Loading product xml from 'https://go.microsoft.com/fwlink/?LinkId=158722'
DownloadManager Information: 0 : Product manager downloading: https://go.microsoft.com/fwlink/?LinkId=158722
DownloadManager Error: 0 : Error downloading product file: 'System.Net.WebException: InternetOpenUrl returned 0x80072F19: Unknown error 12057.
   at Microsoft.Web.PlatformInstaller.ManagedWinInet.ThrowGetLastErrorException(String offendingFunction)
   at Microsoft.Web.PlatformInstaller.ManagedWinInet.OpenUrlAndFollowRedirects(Uri& uri, IntPtr& hInetFile, String headers)
   at Microsoft.Web.PlatformInstaller.ManagedWinInet.DownloadFile(Uri uri, String fileName, String& contentDispositionFileName)
   at Microsoft.Web.PlatformInstaller.ProductManager.DownloadFile(Uri url, String cacheFileLocation, DateTime productFileLastModified)
   at Microsoft.Web.PlatformInstaller.ProductManager.Load(Uri productFileUrl, Boolean filterByArchitectureAndOS, Boolean loadEnclosures, Boolean useCachedVersion, String cacheDirectory, Architecture architecture, Int32 majorOS, Int32 minorOS, Int32 majorSP, Int32 minorSP, Int32 osType)
DownloadManager Information: 0 : Loading product xml from 'http://www.microsoft.com/web/webpi/2.0/WebApplicationList.xml'
DownloadManager Information: 0 : Product manager downloading: http://www.microsoft.com/web/webpi/2.0/WebApplicationList.xml
DownloadManager Information: 0 : Remote file has not changed, using local cached file:C:\Users\Derek Dettler\AppData\Local\Microsoft\Web Platform Installer\-1589660071.xml.temp
DownloadManager Information: 0 : Filtering by majorOS: 6, minorOS: 0, majorSP: 1, minorSP: 0, productType: 3, architecture: x86
DownloadManager Information: 0 : Filtering by majorOS: 6, minorOS: 0, majorSP: 1, minorSP: 0, productType: 3, architecture: x86
DownloadManager Information: 0 : Contextual entry products: SQLExpressAdv
DownloadManager Information: 0 : Adding product SQL Server 2008 Express with Advanced Services (SQLExpressAdv) to cart
DownloadManager Information: 0 : Contextual navigation to product 'SQLExpressAdv'
DownloadManager Information: 0 : Product 'SQLExpressAdv' was already in cart.
DownloadManager Information: 0 : Configuring SQL
DownloadManager Information: 0 : Using SQL windows 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 : Using cached file at C:\Users\Derek Dettler\AppData\Local\Microsoft\Web Platform Installer\installers\SQLExpressAdv\BF009BD484F9429307181424F6E4D304D21BE2DE\SQLEXPRADV_x86_ENU.exe instead of downloading from http://download.microsoft.com/download/e/9/b/e9bcf5d7-2421-464f-94dc-0c694ba1b5a4/SQLEXPRADV_x86_ENU.exe
DownloadManager Information: 0 : Starting EXE install for product 'SQL Server 2008 Express with Advanced Services'. Commandline is: 'C:\Users\Derek Dettler\AppData\Local\Microsoft\Web Platform Installer\installers\SQLExpressAdv\BF009BD484F9429307181424F6E4D304D21BE2DE\SQLEXPRADV_x86_ENU.exe /qs /ACTION=Install /SkipRules=RebootRequiredCheck /FEATURES=SQL,RS,TOOLS /INSTANCENAME=SQLEXPRESS /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSVCStartupType=Automatic /RSSVCACCOUNT="NT AUTHORITY\Network Service" /RSSVCStartupType=Automatic /AddCurrentUserAsSqlAdmin /ENABLERANU=1 /hideconsole '
DownloadManager Information: 0 : Waiting for process: 5556 - C:\Users\Derek Dettler\AppData\Local\Microsoft\Web Platform Installer\installers\SQLExpressAdv\BF009BD484F9429307181424F6E4D304D21BE2DE\SQLEXPRADV_x86_ENU.exe
DownloadManager Information: 0 : Install exit code for product 'SQL Server 2008 Express with Advanced Services' is -2068643839
DownloadManager Error: 0 : Install return code for product 'SQL Server 2008 Express with Advanced Services' is Failure
DownloadManager Information: 0 : Product SQL Server 2008 Express with Advanced Services done install completed
DownloadManager Information: 0 : Increasing current install to 2

I would appreciate any additional help.