I can't start SQL server  
Author Message
Amazing Andrei





PostPosted: Installing and Registering Visual Studio Express Editions, I can't start SQL server Top

I have the SQL server that came with Web Developer Express or C# Express, I don't remember exactly which one...

The thing is, the service won't start.

Has anyone experienced this problem here's the error log:(the files it tries to open are not read-only):

Thanks.


2006-02-10 19:56:39.32 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2006-02-10 19:56:39.32 Server (c) 2005 Microsoft Corporation.
2006-02-10 19:56:39.32 Server All rights reserved.
2006-02-10 19:56:39.32 Server Server process ID is 5924.
2006-02-10 19:56:39.32 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2006-02-10 19:56:39.32 Server This instance of SQL Server last reported using a process ID of 3704 at 2/10/2006 7:54:55 PM (local) 2/10/2006 5:54:55 PM (UTC). This is an informational message only; no user action is required.
2006-02-10 19:56:39.32 Server Registry startup parameters:
2006-02-10 19:56:39.34 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2006-02-10 19:56:39.34 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2006-02-10 19:56:39.34 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2006-02-10 19:56:39.34 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-02-10 19:56:39.34 Server Detected 1 CPUs. This is an informational message; no user action is required.
2006-02-10 19:56:39.40 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.
2006-02-10 19:56:39.45 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-02-10 19:56:39.46 spid5s Starting up database 'master'.
2006-02-10 19:56:39.46 spid5s Error: 17207, Severity: 16, State: 1.
2006-02-10 19:56:39.46 spid5s FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation.
2006-02-10 19:56:39.48 spid5s Error: 17204, Severity: 16, State: 1.
2006-02-10 19:56:39.48 spid5s FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf for file number 1. OS error: 5(Access is denied.).
2006-02-10 19:56:39.48 spid5s Error: 5120, Severity: 16, State: 101.
2006-02-10 19:56:39.48 spid5s Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf". Operating system error 5: "5(Access is denied.)".
2006-02-10 19:56:39.48 spid5s Error: 17207, Severity: 16, State: 1.
2006-02-10 19:56:39.48 spid5s FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2006-02-10 19:56:39.48 spid5s Error: 17204, Severity: 16, State: 1.
2006-02-10 19:56:39.48 spid5s FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf for file number 2. OS error: 5(Access is denied.).
2006-02-10 19:56:39.48 spid5s Error: 5120, Severity: 16, State: 101.
2006-02-10 19:56:39.48 spid5s Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf". Operating system error 5: "5(Access is denied.)".
perating system error 2: "2(The system cannot find the file specified.)".
is is an informational message only. No user action is required.
2006-01-24 16:26:09.77 spid11s The Service Broker protocol transport is disabled or not configured.
2006-01-24 16:26:09.77 spid11s The Database Mirroring protocol transport is disabled or not configured.
2006-01-24 16:26:10.30 spid11s Service Broker manager has started.
2006-01-25 16:59:31.04 spid1s Server resumed execution after being idle 88358 seconds. Reason: timer event.
2006-01-26 17:02:05.48 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.



Visual Studio Express Editions21  
 
 
vje





PostPosted: Installing and Registering Visual Studio Express Editions, I can't start SQL server Top

Yep, having the same problem. Something about SQL Server not allowing remote connections, even if it's actually local (something to do with logical connections). I configured mine per the stuff I've read, but still get the same errors.

Let me know if you've found anything if you happen to check back here.

Thanks in advance.



 
 
Weston Hutchins - MSFT





PostPosted: Installing and Registering Visual Studio Express Editions, I can't start SQL server Top

I found some similar problems/solutions here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=9878&SiteID=1

Let me know if that helps.