How to fix this SQL server error during installation ?

Question

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually

error log file :

2009-11-02 14:55:14.73 Server Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition on Windows NT 6.1 (Build 7600: )

2009-11-02 14:55:14.78 Server (c) 2005 Microsoft Corporation.
2009-11-02 14:55:14.78 Server All rights reserved.
2009-11-02 14:55:14.78 Server Server process ID is 3208.
2009-11-02 14:55:14.78 Server System Manufacturer: 'Dell Inc.', System Model: 'Inspiron 1318'.
2009-11-02 14:55:14.78 Server Authentication mode is MIXED.
2009-11-02 14:55:14.78 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2009-11-02 14:55:14.79 Server This instance of SQL Server last reported using a process ID of 3928 at 11/2/2009 4:10:39 AM (local) 11/2/2009 9:10:39 AM (UTC). This is an informational message only; no user action is required.
2009-11-02 14:55:14.79 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
2009-11-02 14:55:14.79 Server Command Line Startup Parameters:
-m SqlSetup
-T 4022
-T 4010
-T 1905
2009-11-02 14:55:14.87 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-11-02 14:55:14.87 Server Detected 2 CPUs. This is an informational message; no user action is required.
2009-11-02 14:55:15.07 Server SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure.
2009-11-02 14:55:15.59 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2009-11-02 14:55:15.65 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.
2009-11-02 14:55:21.32 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.
2009-11-02 14:55:21.57 Server Database Mirroring Transport is disabled in the endpoint configuration.
2009-11-02 14:55:21.61 spid7s Warning ******************
2009-11-02 14:55:21.61 spid7s SQL Server started in single-user mode. This an informational message only. No user action is required.
2009-11-02 14:55:21.79 spid7s Starting up database 'master'.
2009-11-02 14:55:22.14 spid7s 3 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2009-11-02 14:55:22.40 spid7s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2009-11-02 14:55:22.40 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2009-11-02 14:55:23.23 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2009-11-02 14:55:23.26 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2009-11-02 14:55:23.33 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2009-11-02 14:55:23.62 spid7s SQL Trace ID 1 was started by login "sa".
2009-11-02 14:55:23.67 spid7s Starting up database 'mssqlsystemresource'.
2009-11-02 14:55:23.69 spid7s The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
2009-11-02 14:55:24.01 spid7s Error: 15209, Severity: 16, State: 1.
2009-11-02 14:55:24.01 spid7s An error occurred during encryption.
2009-11-02 14:55:24.08 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Answer 1

To work around this problem, grant the Network Service account the Full Control permission on the Protect folder. To do this, follow these steps:



1. Open My Computer.

2. Type C:\Documents and Settings\NetworkService\Application Data\Microsoft in the address bar, and then press ENTER.

3. Right-click the Protect folder, and then click Properties.

4. In the folder Properties dialog box, click the Security tab.

5. Under Group or user names, determine whether NETWORK SERVICE is listed. If NETWORK SERVICE is not listed, follow these steps to add this account:

1. Click Add to show the Select Users or Groups dialog box.

2. Click Locations, select your computer name in the Locations dialog box, and then click OK to return to the Select Users or Groups dialog box.

3. Type Network Service in the Enter the object names to select box, and then click Check Names.

4. Click OK to close the Select Users or Groups dialog box.

6. Click NETWORK SERVICE under Group or user names, and then click to select the Allow check box for Full Control under Permissions for NETWORK SERVICE.

7. Click OK to close the folder Properties dialog box.

8. Click Retry in the error message dialog box to continue to install SQL Server Express Edition or SQL Server Express Edition with Advanced Services.

Answer 2

For Complete Learning about SQL Server 2005 You can visit and Find lots of Video Tutorials For SQL Server.

Goto : http://www.letmedownload.com

Goto Study Zone and Than to SQL Server 2005 section .

Answer 3

This Site Might Help You.



RE:

How to fix this SQL server error during installation ?

TITLE: Microsoft SQL Server 2005 Setup

------------------------------



The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually



error log file...

Answer 4

Hi! Someone in my Facebook group shared this link so I came to take a look. I'm definitely loving the information. I'm bookmarking and will be tweeting this to my followers!

Answer 5

better u just search any visual studio exist in control panel..and uninstall it.and try again

Answer 6

where is protect folder i cant view can any help