Re: SQL Sever 2008 RC0 fail to install almost all services
- From: Pedro Gonçalves <PedroGonalves@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 10 Jul 2008 03:11:01 -0700
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:
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é
"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
- Prev by Date: Re: Custom default data folder
- Next by Date: SQL event alerts not working
- Previous by thread: Re: Custom default data folder
- Next by thread: SQL event alerts not working
- Index(es):
Relevant Pages
|
