Re: SQL Sever 2008 RC0 fail to install almost all services

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é


"Pedro Gonçalves" <PedroGonalves@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A4884266-EA40-4C0A-8EBF-D6F1B22DA337@xxxxxxxxxxxxxxxx
No, I don't.


"Gé Brander" wrote:

Do you have your filesystem encrypted?

Gé

"Pedro Gonçalves" <PedroGonalves@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D46FFAF0-361F-4CC7-999F-AA4E6F40C5D7@xxxxxxxxxxxxxxxx
> 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.
>
>
>
> "Gé Brander" wrote:
>
>> 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.
>>
>> "Gé Brander" <ge brander microsoft> wrote in message
>> news:1B1D7137-32DA-49CE-B1D3-7176B801FAE1@xxxxxxxxxxxxxxxx
>> >> 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
>> >
>> > What does this file mention? The SQL Server Error Log file, is what >> > I
>> > mean
>> > here.
>> >
>> > Gé Brander
>> >
>> >
>> > "Pedro Gonçalves" <PedroGonalves@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> > message news:F040789D-E6D9-4B4E-BA8B-FB82CE7F2D17@xxxxxxxxxxxxxxxx
>> >> 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

.

Relevant Pages

  • Re: SQL Sever 2008 RC0 fail to install almost all services
    ... > SQL server services. ... This is an informational message only. ... no user action is required. ...
    (microsoft.public.sqlserver.setup)
  • SQL Issues with winserver 2003 small business standard
    ... I have a 2003 small business server, a few days ago it was working perfect ... sql, i noticed that the sql service has stopped i tried to start but i ... This is an informational message only; no user action is required. ...
    (microsoft.public.windows.server.sbs)
  • SBS Console Other Alerts Not Available
    ... A few weeks ago our server started having an issue with the "Other Alerts" on ... at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, ... This is an informational message only; no user action is required. ...
    (microsoft.public.windows.server.sbs)
  • Cannot move msdb/model even with -T3608
    ... Our SQL instance is a named one and has the following ... This is an informational message only. ... no user action is required. ... System databases master, model, msdb, and tempdb cannot be detached. ...
    (comp.databases.ms-sqlserver)
  • Re: Starting SQL Server Resource Group failed
    ... It looks like the Cluster Service cannot connect to the SQL Service to determine whether it is responsive or not. ... MS has not documented a process to fix this without uninstalling and reinstalling SQL Server. ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.clustering)
Loading