Instalation

I'm facing a problem while installing SQL Server 2005 Express. When SQLServer Installer going to start service during instalation, installer don't start service and rollback the instalation. i found following message in SQL

LOG File

.2007-08-31 12:01:17.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-08-31 12:01:17.28 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-08-31 12:04:36.56 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.
2007-08-31 12:04:38.06 Server Database Mirroring Transport is disabled in the endpoint configuration.

2007-08-30 00:07:34.21 Server Service control: stop before startup

if u have any solution regarding above please help me.

Thankx in advance.

Hi Zaib,

Please check this KB article and follow up the workaround inside.

http://support.microsoft.com/kb/920114

Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: "The SQL Server service failed to start"

CAUSE

This problem occurs because the Network Service account does not have permissions on the following folder: C:\Documents and Settings\NetworkService\Application Data\Microsoft\Protect

WORKAROUND

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:

a. Click Add to show the Select Users or Groups dialog box. b. 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. c. Type Network Service in the Enter the object names to select box, and then click Check Names. d. 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.

Note that the NetworkService folder may be hidden, and If the Protect folder is not found, you need to create it manually.

Please take a try. I hope that can help you.

These threads are similar to your issue.

SQL Express installation error

SQL Express Cannot Start
SQL server 2005 express failed to install under win2k SP4

Best regards,

Martin Xie

|||

I move it from VB Express forum to SQL Server Express forum for better responses.

Thanks,

Martin