Unable to Start MSSQL SERVER
-
Hi All, I am using SQL Server 2005. My problem is that I am unable to start MSSQL Server. When I go to services.msc, i found that the state of MSSQLServer is stopped. When I click on start, it gives me this error: The SQL Server (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts Service. I try all possible things, google it and atlast re-install SQL Server but nothing happen. So please help me?? Thanks
-
Hi All, I am using SQL Server 2005. My problem is that I am unable to start MSSQL Server. When I go to services.msc, i found that the state of MSSQLServer is stopped. When I click on start, it gives me this error: The SQL Server (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts Service. I try all possible things, google it and atlast re-install SQL Server but nothing happen. So please help me?? Thanks
Have you checked the event log to see if there are any messages relating to this in there?
me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven
-
Have you checked the event log to see if there are any messages relating to this in there?
me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven
Ya, I checked it but didn't understand. I am providing you the log.
2010-03-25 18:55:55.53 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)2010-03-25 18:55:55.53 Server (c) 2005 Microsoft Corporation.
2010-03-25 18:55:55.53 Server All rights reserved.
2010-03-25 18:55:55.53 Server Server process ID is 2772.
2010-03-25 18:55:55.53 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2010-03-25 18:55:55.53 Server This instance of SQL Server last reported using a process ID of 212 at 3/25/2010 6:40:35 PM (local) 3/25/2010 1:10:35 PM (UTC). This is an informational message only; no user action is required.
2010-03-25 18:55:55.53 Server Registry startup parameters:
2010-03-25 18:55:55.53 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
2010-03-25 18:55:55.53 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2010-03-25 18:55:55.53 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2010-03-25 18:55:55.54 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-25 18:55:55.54 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-03-25 18:55:55.85 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.
2010-03-25 18:55:55.87 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-03-25 18:55:56.90 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-03-25 18:55:56.90 Server Database Mirroring Transport is disabled in the endpoint configuration.
2010-03-25 18:55:56.90 spid4s Starting up database 'master'.
2010-03-25 18:55:56.90 spid4s Error: 17207, Severity: 16, State: 1.
2010-03-25 18:55:56.90 spid4s FCB::RemoveAlternateStreams: Operating system error 6(The handle is invalid.) occurred while creating or opening file 'C:\Progr -
Ya, I checked it but didn't understand. I am providing you the log.
2010-03-25 18:55:55.53 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)2010-03-25 18:55:55.53 Server (c) 2005 Microsoft Corporation.
2010-03-25 18:55:55.53 Server All rights reserved.
2010-03-25 18:55:55.53 Server Server process ID is 2772.
2010-03-25 18:55:55.53 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2010-03-25 18:55:55.53 Server This instance of SQL Server last reported using a process ID of 212 at 3/25/2010 6:40:35 PM (local) 3/25/2010 1:10:35 PM (UTC). This is an informational message only; no user action is required.
2010-03-25 18:55:55.53 Server Registry startup parameters:
2010-03-25 18:55:55.53 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
2010-03-25 18:55:55.53 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2010-03-25 18:55:55.53 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2010-03-25 18:55:55.54 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-03-25 18:55:55.54 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-03-25 18:55:55.85 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.
2010-03-25 18:55:55.87 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-03-25 18:55:56.90 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-03-25 18:55:56.90 Server Database Mirroring Transport is disabled in the endpoint configuration.
2010-03-25 18:55:56.90 spid4s Starting up database 'master'.
2010-03-25 18:55:56.90 spid4s Error: 17207, Severity: 16, State: 1.
2010-03-25 18:55:56.90 spid4s FCB::RemoveAlternateStreams: Operating system error 6(The handle is invalid.) occurred while creating or opening file 'C:\ProgrYikes - wish I hadn't asked. Okay, well, I'd be looking for the first reported error and concentrate on that:
Starting up database 'master'. Error: 17207, Severity: 16, State: 1.Start with that and see how far you get. (If anyone else has a better suggestion now would be the time...)me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven