Jump to content

Recommended Posts

Posted

Our librarian's PC died yesterday and it just so happened to be the PC that was running Eclipse.net. I've set up a new PC for her, however, it just will not install SQL Server Express. I tried 2005 first and I kept getting an error that it couldn't start the service and now I'm trying 2008 R2 with Management Studio and getting a Database Engine error and then the installation just crashes. I've got 2 error logs here for 2008. Can anyone help?

 

ERRORLOG:

2013-02-01 09:29:47.10 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) 
Apr  2 2010 15:53:02 
Copyright (c) Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1  (Build 2600: Service Pack 3)

2013-02-01 09:29:47.10 Server      (c) Microsoft Corporation.
2013-02-01 09:29:47.10 Server      All rights reserved.
2013-02-01 09:29:47.10 Server      Server process ID is 2492.
2013-02-01 09:29:47.10 Server      Authentication mode is WINDOWS-ONLY.
2013-02-01 09:29:47.10 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2013-02-01 09:29:47.10 Server      This instance of SQL Server last reported using a process ID of 4064 at 01/02/2013 09:20:17 (local) 01/02/2013 09:20:17 (UTC). This is an informational message only; no user action is required.
2013-02-01 09:29:47.10 Server      Registry startup parameters: 
 -d c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\master.mdf
 -e c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG
 -l c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2013-02-01 09:29:47.10 Server      Command Line Startup Parameters:
 -m SqlSetup
 -T 4022
 -T 4010
 -T 1905
2013-02-01 09:29:47.12 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-02-01 09:29:47.12 Server      Detected 4 CPUs. This is an informational message; no user action is required.
2013-02-01 09:29:47.45 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2013-02-01 09:29:47.45 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.
2013-02-01 09:29:47.48 Server      Node configuration: node 0: CPU mask: 0x0000000f:0 Active CPU mask: 0x0000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-02-01 09:29:47.50 Server      Database Mirroring Transport is disabled in the endpoint configuration.
2013-02-01 09:29:47.51 spid7s      Warning ******************
2013-02-01 09:29:47.51 spid7s      SQL Server started in single-user mode. This an informational message only. No user action is required.
2013-02-01 09:29:47.51 spid7s      Starting up database 'master'.
2013-02-01 09:29:47.56 spid7s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2013-02-01 09:29:47.68 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
2013-02-01 09:29:47.89 spid7s      SQL Trace ID 1 was started by login "sa".
2013-02-01 09:29:47.98 spid7s      The resource database has been detected in two different locations. Attaching the resource database in the same directory as sqlservr.exe at 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\sqlservr.exe' instead of the currently attached resource database at 'e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\mssqlsystemresource.mdf'.
2013-02-01 09:29:47.98 spid7s      Starting up database 'mssqlsystemresource'.
2013-02-01 09:29:48.00 spid7s      The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2013-02-01 09:29:48.18 spid7s      Error: 15209, Severity: 16, State: 1.
2013-02-01 09:29:48.18 spid7s      An error occurred during encryption.
2013-02-01 09:29:48.18 spid7s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

 

ERRORLOG.1

2013-02-01 09:20:12.63 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) 
Apr  2 2010 15:53:02 
Copyright (c) Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1  (Build 2600: Service Pack 3)

2013-02-01 09:20:12.73 Server      (c) Microsoft Corporation.
2013-02-01 09:20:12.73 Server      All rights reserved.
2013-02-01 09:20:12.73 Server      Server process ID is 4064.
2013-02-01 09:20:12.73 Server      Authentication mode is WINDOWS-ONLY.
2013-02-01 09:20:12.74 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2013-02-01 09:20:12.85 Server      Registry startup parameters: 
 -d c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\master.mdf
 -e c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG
 -l c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2013-02-01 09:20:12.85 Server      Command Line Startup Parameters:
 -m SqlSetup
 -f
 -Q
 -q Latin1_General_CI_AS
 -T 4022
 -T 4010
 -T 3659
 -T 3610
 -d c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Template Data\master.mdf
 -l c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf
2013-02-01 09:20:13.01 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.
2013-02-01 09:20:13.07 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-02-01 09:20:13.07 Server      Detected 4 CPUs. This is an informational message; no user action is required.
2013-02-01 09:20:13.99 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2013-02-01 09:20:14.01 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.
2013-02-01 09:20:15.07 Server      Node configuration: node 0: CPU mask: 0x0000000f:0 Active CPU mask: 0x0000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-02-01 09:20:15.21 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.
2013-02-01 09:20:15.32 spid7s      Warning ******************
2013-02-01 09:20:15.37 spid7s      SQL Server started in single-user mode. This an informational message only. No user action is required.
2013-02-01 09:20:15.48 spid7s      Starting up database 'master'.
2013-02-01 09:20:16.02 spid7s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2013-02-01 09:20:16.80 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
2013-02-01 09:20:16.90 spid7s      Server started with '-f' option. Auditing will not be started. This is an informational message only; no user action is required.
2013-02-01 09:20:16.91 spid7s      Starting up database 'mssqlsystemresource'.
2013-02-01 09:20:16.93 spid7s      The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2013-02-01 09:20:17.34 spid7s      Error: 15209, Severity: 16, State: 1.
2013-02-01 09:20:17.34 spid7s      An error occurred during encryption.

Posted
A mixture of the above fix and also the fact that the installer did not like using the NETWORK SERVICE account. I set it as the Domain Admin account and it's now installed happily.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...