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
"Gé Brander" wrote:
>> No, I don't.
>>
>>
>> "Gé Brander" wrote:
>>
>>>> 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
(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:
>>>>>>>>>>> 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%...
>>>>>>>
>>>>>>> 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:
>>>>>>> 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:
>>>>>>> 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:
>>>>>>> FAILOVERCLUSTERGROUP:
>>>>>>> FAILOVERCLUSTERIPADDRESSES:
>>>>>>> FAILOVERCLUSTERNETWORKNAME:
>>>>>>> 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:
>>>>>>> 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
