SQL Server - SQL Sever 2008 RC0 fail to install almost all services

Asked By PedroGonalve on 23-Jun-08 04:50 AM
Hi,

I've a new and clean installation of Windows 2008 Standard and I'm trying to
install SQL Server 2008 RC0 but almost all services failed to install:
databse engine, replication services, full-text search services, reporting
services, and books online(!)

I read the logs but can't understand exactly what is the problem and how to
fix it.
Can someone help me, please?

The Summary log file:
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:                    2008-06-18 23:19:59
End time:                      2008-06-18 23:57:51
Requested action:              Install
Log with failure:              C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20080618_231335\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.1442.32%26EvtType%3dMicrosoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart%40Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException%401306%4024

Machine Properties:
Machine name:                  MYSERVER
Machine processor count:       2
OS version:                    Windows Server 2008
OS service pack:               Service Pack 1
OS region:                     Portugal
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:         D:\x86\setup\
Installation edition:          STANDARD

User Input Settings:
ACTION:                        Install
ADDCURRENTUSERASSQLADMIN:      False
AGTDOMAINGROUP:                <empty>
AGTSVCACCOUNT:                 MYDOMAIN\SQLServerServices
AGTSVCPASSWORD:                *****
AGTSVCSTARTUPTYPE:             Automatic
ASBACKUPDIR:                   C:\Program Files\Microsoft SQL
Server\MSAS10.MSSQLSERVER\OLAP\Backup
ASCOLLATION:                   Latin1_General_CI_AS
ASCONFIGDIR:                   C:\Program Files\Microsoft SQL
Server\MSAS10.MSSQLSERVER\OLAP\Config
ASDATADIR:                     C:\Program Files\Microsoft SQL
Server\MSAS10.MSSQLSERVER\OLAP\Data
ASDOMAINGROUP:                 <empty>
ASLOGDIR:                      C:\Program Files\Microsoft SQL
Server\MSAS10.MSSQLSERVER\OLAP\Log
ASPROVIDERMSOLAP:              1
ASSVCACCOUNT:                  MYDOMAIN\SQLServerServices
ASSVCPASSWORD:                 *****
ASSVCSTARTUPTYPE:              Automatic
ASSYSADMINACCOUNTS:            MYDOMAIN\administrador
ASTEMPDIR:                     C:\Program Files\Microsoft SQL
Server\MSAS10.MSSQLSERVER\OLAP\Temp
BROWSERSVCSTARTUPTYPE:         Manual
CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20080618_231335\ConfigurationFile.ini
ENABLERANU:                    False
ERRORREPORTING:                True
FAILOVERCLUSTERDISKS:          <empty>
FAILOVERCLUSTERGROUP:          <empty>
FAILOVERCLUSTERIPADDRESSES:    <empty>
FAILOVERCLUSTERNETWORKNAME:    <empty>
FAILOVERCLUSTERROLLOWNERSHIP:  2
FEATURES:
SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,BOL,SSMS,ADV_SSMS,OCS
FILESTREAMLEVEL:               3
FILESTREAMSHARENAME:           MSSQLSERVER
FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD:                 *****
FTUPGRADEOPTION:               Import
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:                    MSSQLSERVER
INSTANCENAME:                  MSSQLSERVER
ISSVCACCOUNT:                  MYDOMAIN\SQLServerServices
ISSVCPASSWORD:                 *****
ISSVCSTARTUPTYPE:              Automatic
MEDIASOURCE:                   D:\
NPENABLED:                     0
PID:                           *****
QUIET:                         False
QUIETSIMPLE:                   False
RSCATALOGSERVERINSTANCENAME:   Unknown
RSINSTALLMODE:                 DefaultNativeMode
RSSVCACCOUNT:                  MYDOMAIN\SQLServerServices
RSSVCPASSWORD:                 *****
RSSVCSTARTUPTYPE:              Automatic
RSUPGRADEDATABASEACCOUNT:
RSUPGRADEPASSWORD:             *****
RULES:                         <empty>
SAPWD:                         *****
SECURITYMODE:                  <empty>
SQLBACKUPDIR:                  <empty>
SQLCOLLATION:                  Latin1_General_CI_AS
SQLDOMAINGROUP:                <empty>
SQLSVCACCOUNT:                 MYDOMAIN\SQLServerServices
SQLSVCPASSWORD:                *****
SQLSVCSTARTUPTYPE:             Automatic
SQLSYSADMINACCOUNTS:           MYDOMAIN\administrador
SQLTEMPDBDIR:                  <empty>
SQLTEMPDBLOGDIR:               <empty>
SQLUSERDBDIR:                  <empty>
SQLUSERDBLOGDIR:               <empty>
SQMREPORTING:                  True
TCPENABLED:                    1
X86:                           False

Configuration file:            C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20080618_231335\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:                       Analysis Services
Status:                        Passed
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:                        Passed
MSI status:                    Passed
Configuration status:          Passed

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

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

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

Feature:                       Client Tools Backwards Compatibility
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                       Business Intelligence Development Studio
Status:                        Passed
MSI status:                    Passed
Configuration status:          Passed

Feature:                       SQL Server Books Online
Status:                        Failed: see logs for details
MSI status:                    Passed
Configuration status:          Failed: see details below
Configuration error code:
Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException@1306@24
Configuration error description: Wait on the Database Engine recovery
handle failed. Check the SQL Server error log for potential causes.
Configuration log:             C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20080618_231335\Detail.txt

Feature:                       Microsoft Sync Framework
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\20080618_231335\SystemConfigurationCheck_Report.htm




ge brander microsoft replied on 25-Jun-08 06:02 AM
What does this file mention? The SQL Server Error Log file, is what I mean
here.

Gé Brander
PedroGonalve replied on 25-Jun-08 12:57 PM
Hi,

I understand... but the detail.txt file has 2.5 MB!!! I can't repreduce it
here.

I was hopping that someone could, at least, tell me where in the detail file
should I look for the problem description.

The first error reported is about Redist.cab media file. It says that is
corrupted but I did download the DVD iso file 3 times and save it with 2
different DVD players. The problem has to be elsewhere.

But, please ask what you need to help me with this.

Here is the first and second (that match "fail" in find) error occurrence in
the Detail.txt file:

2008-06-18 23:24:35 Slp: Running Action: Install_BOL_Cpu32_Action
2008-06-18 23:24:35 Slp: Target package: "D:\x86\setup\SqlServer2008_BOL.msi"
2008-06-18 23:25:21 Slp: MSI Error: 1335 The cabinet file 'Redist.cab'
required for this installation is corrupt and cannot be used. This could
indicate a network error, an error reading from installation media, or a
problem with this package.
2008-06-18 23:39:35 Slp: Sco: Attempting to write hklm registry key
SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft
SQL Server\100\Setup
Bootstrap\Log\20080618_231335\Registry_SOFTWARE_Microsoft_Microsoft SQL
Server.reg_
2008-06-18 23:39:35 Slp: Sco: Attempting to write hklm registry key
SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program
Files\Microsoft SQL Server\100\Setup
Bootstrap\Log\20080618_231335\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2008-06-18 23:39:35 Slp: Sco: Attempting to write hklm registry key
SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL
Server\100\Setup
Bootstrap\Log\20080618_231335\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2008-06-18 23:39:41 Slp: The cabinet file 'Redist.cab' required for this
installation is corrupt and cannot be used. This could indicate a network
error, an error reading from installation media, or a problem with this
package.
2008-06-18 23:39:41 Slp: Watson bucket for Msi based failure has been created
2008-06-18 23:39:43 Slp: InstallPackage: MsiInstallProduct returned the
result code 1603.
2008-06-18 23:39:43 Slp: No retry-able MSI return code detected.
2008-06-18 23:39:43 Slp: Checkpoint: INSTALL_BOL_CPU32_ACTION
2008-06-18 23:39:43 Slp: Completed Action: Install_BOL_Cpu32_Action,
returned False
2008-06-18 23:39:43 Slp: Error: Action "Install_BOL_Cpu32_Action" failed
during execution.
------------------------------------------------------
........
------------------------------------------------------
2008-06-18 23:52:08 Slp: Running Action:
SLP_Writer_Dumper_install_postmsi_Cpu32
2008-06-18 23:52:08 Slp: Action Data:
2008-06-18 23:52:08 Slp:   Feature = SQL_WRITER_SqlWriter_Cpu32
2008-06-18 23:52:08 Slp:   Scenario = install
2008-06-18 23:52:08 Slp:   Timing = ConfigNonRC
2008-06-18 23:52:08 Slp:   ConfigObjectType =
Microsoft.SqlServer.Configuration.SetupExtension.SlpDumperPrivateConfig
2008-06-18 23:52:08 Slp:   FeatureName = SQL_WRITER
2008-06-18 23:52:08 Slp:   FeatureCpuType = Cpu32
2008-06-18 23:52:08 Slp:   FeaturePackageId = SqlWriter
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Creating error dump
folder: C:\Program Files\Microsoft SQL Server\100\Shared\ErrorDumps\
2008-06-18 23:52:08 Slp: Sco: Attempting to set directory full path
2008-06-18 23:52:08 Slp: Sco: Attempting to normalize directory path
C:\Program Files\Microsoft SQL Server\100\Shared\ErrorDumps\
2008-06-18 23:52:08 Slp: Sco: Attempting to check if directory C:\Program
Files\Microsoft SQL Server\100\Shared\ErrorDumps\ exists
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Done creating error
dump folder: C:\Program Files\Microsoft SQL Server\100\Shared\ErrorDumps\
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Creating Error Dump
registry name/value pairs under hive: \SOFTWARE\Microsoft\Microsoft SQL
Server\100
2008-06-18 23:52:08 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine
2008-06-18 23:52:08 Slp: Sco: Attempting to create registry subkey
\SOFTWARE\Microsoft\Microsoft SQL Server\100
2008-06-18 23:52:08 Slp: CreateSubkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Set value:
EnableErrorReporting = 1
2008-06-18 23:52:08 Slp: Sco: Attempting to set value EnableErrorReporting
2008-06-18 23:52:08 Slp: SetValue:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100, Name =
EnableErrorReporting
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : set  value:
CustomerFeedback = 1
2008-06-18 23:52:08 Slp: Sco: Attempting to set value CustomerFeedback
2008-06-18 23:52:08 Slp: SetValue:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100, Name =
CustomerFeedback
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Set  value:
ErrorReportingDir = C:\Program Files\Microsoft SQL
Server\100\Shared\ErrorDumps\
2008-06-18 23:52:08 Slp: Sco: Attempting to set value ErrorReportingDir
2008-06-18 23:52:08 Slp: SetValue:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100, Name =
ErrorReportingDir
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Set  value:
CollectorParameters =
2008-06-18 23:52:08 Slp: Sco: Attempting to set value CollectorParameters
2008-06-18 23:52:08 Slp: SetValue:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100, Name =
CollectorParameters
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Set  value:
TimeOfReporting = 240
2008-06-18 23:52:08 Slp: Sco: Attempting to set value TimeOfReporting
2008-06-18 23:52:08 Slp: SetValue:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100, Name =
TimeOfReporting
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Done creating registry
name/value pairs
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Setting access control
security () for folder: C:\Program Files\Microsoft SQL
Server\100\Shared\ErrorDumps\
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Done setting access
control security
2008-06-18 23:52:08 Slp: -- SlpDumperPrivateConfig : Setting access control
security () for registry key: \SOFTWARE\Microsoft\Microsoft SQL Server\100
2008-06-18 23:52:08 Slp: SlpConfigAction.ExecuteAction(actionId:
SLP_Writer_Dumper_install_postmsi_Cpu32) completed
2008-06-18 23:52:08 Slp: Checkpoint: INSTALL:CONFIGNONRC:SQL_WRITER
2008-06-18 23:52:08 Slp: Completed Action:
SLP_Writer_Dumper_install_postmsi_Cpu32, returned True
2008-06-18 23:52:08 Slp: Action
will return false due to the following conditions:
2008-06-18 23:52:08 Slp: Condition "Feature dependency condition for action:
ConfigEvent_SQL_BooksOnline_Redist_BOL_Cpu32_Install_ConfigNonRC_postmsi The
condition tests feature: SQL_BooksOnline_Redist_BOL_Cpu32. There are 1
dependant features. The feature is tested for results: ValidateResult,
Result." did not pass as it returned false and true was expected.
2008-06-18 23:52:08 Slp: Condition is false because the required feature
SQL_BooksOnline_Redist_BOL_Cpu32 failed in result Result
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature configuration state
for feature SQL_BooksOnline_Redist, version
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature flag
ConfigurationState for feature SQL_BooksOnline_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2008-06-18 23:52:08 Slp: Sco: Attempting to get registry value
SQL_BooksOnline_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature configuration state
for feature SQL_BooksOnline_Redist, version
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature flag
ConfigurationState for feature SQL_BooksOnline_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2008-06-18 23:52:08 Slp: Sco: Attempting to get registry value
SQL_BooksOnline_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature configuration state
for feature SQL_BooksOnline_Redist, version
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature flag
ConfigurationState for feature SQL_BooksOnline_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2008-06-18 23:52:08 Slp: Sco: Attempting to get registry value
SQL_BooksOnline_Redist
2008-06-18 23:52:08 Slp: Error: Action
failed during execution.
2008-06-18 23:52:08 Slp: Action "SLP_BOL_Dumper_install_postmsi_Cpu32" will
return false due to the following conditions:
2008-06-18 23:52:08 Slp: Condition "Feature dependency condition for action:
SLP_BOL_Dumper_install_postmsi_Cpu32 The condition tests feature:
SQL_BooksOnline_Redist_BOL_Cpu32. There are 1 dependant features. The feature
is tested for results: ValidateResult, Result." did not pass as it returned
false and true was expected.
2008-06-18 23:52:08 Slp: Condition is false because the required feature
SQL_BooksOnline_Redist_BOL_Cpu32 failed in result Result
2008-06-18 23:52:08 Slp: Error: Action
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature configuration state
for feature SQL_Browser_Redist, version
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature flag
ConfigurationState for feature SQL_Browser_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2008-06-18 23:52:08 Slp: Sco: Attempting to get registry value
SQL_Browser_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to set feature configuration state
FailedConfigured for feature SQL_Browser_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to set feature flag
ConfigurationState for machine , feature SQL_Browser_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2008-06-18 23:52:08 Slp: Sco: Attempting to set value SQL_Browser_Redist
2008-06-18 23:52:08 Slp: SetValue:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\100\ConfigurationState, Name = SQL_Browser_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature configuration state
for feature SQL_Browser_Redist, version
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature flag
ConfigurationState for feature SQL_Browser_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2008-06-18 23:52:08 Slp: Sco: Attempting to get registry value
SQL_Browser_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature configuration state
for feature SQL_Browser_Redist, version
2008-06-18 23:52:08 Slp: Sco: Attempting to get feature flag
ConfigurationState for feature SQL_Browser_Redist
2008-06-18 23:52:08 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
2008-06-18 23:52:08 Slp: Sco: Attempting to open registry subkey
SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2008-06-18 23:52:08 Slp: Sco: Attempting to get registry value
SQL_Browser_Redist
2008-06-18 23:52:08 Slp: ---- Flush datastore cache before calling
configuration action 'SLP_Browser_Dumper_install_postmsi_Cpu32'
2008-06-18 23:52:08 Slp: ---- Flush datastore cache before calling
configuration action 'SLP_Browser_Dumper_install_postmsi_Cpu32'
2008-06-18 23:52:08 Slp: ---- Flush datastore cache before calling
configuration action 'SLP_Browser_Dumper_install_postmsi_Cpu32'
ge brander microsoft replied on 25-Jun-08 04:53 PM
Try to look in the SQL Server errorlog file. That is the file in the
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory.
PedroGonalve replied on 26-Jun-08 05:06 AM
Hi Gé,

The SQL Server Log File reports an error 15209, "An error occurred during
encryption.". What can be the causes for that?

I found this Microsoft article http://support.microsoft.com/kb/920114/en-us,
but I can't find the folder C:\Documents and
Settings\NetworkService\Application Data\Microsoft that they mentioned. Could
it be the same error? And where I find that folder at Win2008?

Note that I use a specific account named SQLServerServices to install all
SQL server services. So I think that I sould look for this account and not
the Network Service account. Is that correct?
An isn't true that for that folder exists I've first to log in with that
account?
I read in a forum that the solution was adding that account to
Administrators Group and first log in with it before try to install. Could
that be the solution?


Content of Errorlog file:
---------------------------
2008-06-18 23:53:27.92 Server      Microsoft SQL Server 2008 (CTP) -
10.0.1442.32 (Intel X86)
May 30 2008 00:02:15
Copyright (c) 1988-2007 Microsoft Corporation
Standard Edition on Windows NT 6.0 <X86> (Build 6001: Service Pack 1)

2008-06-18 23:53:27.95 Server      (c) 2005 Microsoft Corporation.
2008-06-18 23:53:27.95 Server      All rights reserved.
2008-06-18 23:53:27.95 Server      Server process ID is 3092.
2008-06-18 23:53:27.95 Server      Authentication mode is WINDOWS-ONLY.
2008-06-18 23:53:27.95 Server      Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2008-06-18 23:53:27.96 Server      Registry startup parameters:
-d C:\Program Files\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2008-06-18 23:53:27.96 Server      Command Line Startup Parameters:
-m SqlSetup
-f
-Q
-q Latin1_General_CI_AS
-T 4022
-T 3659
-T 3610
-T 4010
2008-06-18 23:53:27.98 Server      Warning: The server instance was started
using minimal configuration startup option (-f). Starting an instance of SQL
Server with minimal configuration places the server in single-user mode
automatically.  After the server has been started with minimal configuration,
you should change the appropriate server option value or values, stop, and
then restart the server.
2008-06-18 23:53:27.99 Server      SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is required.
2008-06-18 23:53:27.99 Server      Detected 2 CPUs. This is an informational
message; no user action is required.
2008-06-18 23:53:28.38 Server      Perfmon counters for resource governor
pools and groups failed to initialize and are disabled.
2008-06-18 23:53:28.42 Server      Using dynamic lock allocation.  Initial
allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is
an informational message only.  No user action is required.
2008-06-18 23:53:29.09 Server      Node configuration: node 0: CPU mask:
0x00000003 Active CPU mask: 0x00000003. This message provides a description
of the NUMA configuration for this computer. This is an informational message
only. No user action is required.
2008-06-18 23:53:29.27 Server      Support for distributed transactions was
not enabled for this instance of the Database Engine because it was started
using the minimal configuration option. This is an informational message
only. No user action is required.
2008-06-18 23:53:29.34 spid7s      Warning ******************
2008-06-18 23:53:29.36 spid7s      SQL Server started in single-user mode.
This an informational message only. No user action is required.
2008-06-18 23:53:29.55 spid7s      Starting up database 'master'.
2008-06-18 23:53:29.77 spid7s      Recovery is writing a checkpoint in
database 'master' (1). This is an informational message only. No user action
is required.
2008-06-18 23:53:30.03 spid7s      FILESTREAM: effective level = 0,
configured level = 3, file system access share name = 'MSSQLSERVER'.
2008-06-18 23:53:30.05 spid7s      Server started with '-f' option. Auditing
will not be started. This is an informational message only; no user action is
required.
2008-06-18 23:53:30.06 spid7s      Starting up database 'mssqlsystemresource'.
2008-06-18 23:53:30.10 spid7s      The resource database build version is
10.00.1442. This is an informational message only. No user action is required.
2008-06-18 23:53:30.43 spid7s      Error: 15209, Severity: 16, State: 1.
2008-06-18 23:53:30.43 spid7s      An error occurred during encryption.
ge brander microsoft replied on 26-Jun-08 01:16 PM
Do you have your filesystem encrypted?

Gé
PedroGonalve replied on 26-Jun-08 05:12 PM
No, I do not.
ge brander microsoft replied on 27-Jun-08 03:28 AM
Hmmm... Try searching on the errormessage...

Then you find: http://support.microsoft.com/kb/920114

Good luck!
ge brander microsoft replied on 27-Jun-08 03:32 AM
And:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=356054&SiteID=1
http://www.phwinfo.com/forum/ms-sqlserver-setup/182584-sql-server-2005-setup-failed-sql-service-failed-start.html

So I think it has to do with some security settings on File or Registry
level. Try the Sysinternals tools to check during setup what file or
registry entry setup wants access to, but is not able to. You will find
whats wrong that way.

Good luck!

Gé
ge brander microsoft replied on 27-Jun-08 03:40 AM
http://sqlserver-qa.net/blogs/tools/archive/2007/11/07/unable-to-install-sql-server-express-error-sql-server-service-failed-to-start.aspx

This article and the others clearly state SQL Express and 2005, but it may
be of use to you too.

Gé
PedroGonalve replied on 10-Jul-08 06:11 AM
Thanks for all your help.

After reading all sort of document and newsgroups questions I finally could
install all services without exceptions.

The solution was simple: add the SQLServerServices account, that I used to
start all services, to the local Administrators security group.

After that the installation was fully succesfull.
Now I removed the account from local Administrators group. Lets see if it
still work...

Regards all,
Pedro Gonçalves