+ Post New Thread
Results 1 to 3 of 3
Windows Thread, SQL Server Installation Failing in Technical; Our librarian's PC died yesterday and it just so happened to be the PC that was running Eclipse.net. I've set ...
  1. #1
    Zoom7000's Avatar
    Join Date
    Feb 2006
    Location
    London
    Posts
    785
    Thank Post
    226
    Thanked 61 Times in 38 Posts
    Rep Power
    28

    SQL Server Installation Failing

    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:
    Code:
    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 <X86> (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
    Code:
    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 <X86> (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.

  2. #2

  3. Thanks to Sam_Brown from:

    Zoom7000 (1st February 2013)

  4. #3
    Zoom7000's Avatar
    Join Date
    Feb 2006
    Location
    London
    Posts
    785
    Thank Post
    226
    Thanked 61 Times in 38 Posts
    Rep Power
    28
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Installing Moodle on Windows Server, SQL Server, IIS
    By apearce in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 11th October 2011, 04:34 PM
  2. SQL Server 2005 Not installing properly
    By Bugs in forum Windows
    Replies: 4
    Last Post: 20th May 2009, 01:29 PM
  3. SIMS SQL Server 2005 re-install
    By philserre in forum MIS Systems
    Replies: 6
    Last Post: 14th October 2008, 08:44 PM
  4. SQL Server KB948109 patch fails
    By cookie_monster in forum Windows
    Replies: 6
    Last Post: 30th July 2008, 09:06 AM
  5. Not enough space for SQL server 2005 install
    By zag in forum MIS Systems
    Replies: 4
    Last Post: 10th October 2007, 08:02 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •