Link to home
Start Free TrialLog in
Avatar of evollic
evollic

asked on

The SQL Server (MSSQLSERVER) service terminated with service-specific error 1814 (0x716)

We are having an issue with our MSSQL server after a reboot that the these services won't autostart:
SQL Server (MSSQLSERVER)
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Services

Server info:
Windows Server 2003  R2 SP2
MSSQL Server 2005 9.0.3077
C: total size 35gb - 9gb free
D: total size 409gb - 98gb free

SQL Logs from startup:
Date,Source,Severity,Message
08/22/2009 12:06:38,spid9s,Unknown,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
08/22/2009 12:06:38,spid9s,Unknown,Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
08/22/2009 12:06:38,spid9s,Unknown,Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.
08/22/2009 12:06:38,spid9s,Unknown,Error: 945<c/> Severity: 14<c/> State: 2.
08/22/2009 12:06:38,spid9s,Unknown,File activation failure. The physical file name "D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\modellog.ldf" may be incorrect.
08/22/2009 12:06:38,spid9s,Unknown,Unable to open the physical file "D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\modellog.ldf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
08/22/2009 12:06:38,spid9s,Unknown,Error: 5120<c/> Severity: 16<c/> State: 101.
08/22/2009 12:06:38,spid9s,Unknown,FCB::Open failed: Could not open file D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\modellog.ldf for file number 2.  OS error: 32(The process cannot access the file because it is being used by another process.).
08/22/2009 12:06:38,spid9s,Unknown,Error: 17204<c/> Severity: 16<c/> State: 1.
08/22/2009 12:06:38,spid9s,Unknown,FCB::Open: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\modellog.ldf'. Diagnose and correct the operating system error<c/> and retry the operation.
08/22/2009 12:06:38,spid9s,Unknown,Error: 17207<c/> Severity: 16<c/> State: 1.
08/22/2009 12:06:37,spid9s,Unknown,Unable to open the physical file "D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\model.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
08/22/2009 12:06:37,spid9s,Unknown,Error: 5120<c/> Severity: 16<c/> State: 101.
08/22/2009 12:06:37,spid9s,Unknown,FCB::Open failed: Could not open file D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\model.mdf for file number 1.  OS error: 32(The process cannot access the file because it is being used by another process.).
08/22/2009 12:06:37,spid9s,Unknown,Error: 17204<c/> Severity: 16<c/> State: 1.
08/22/2009 12:06:37,spid9s,Unknown,FCB::Open: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\model.mdf'. Diagnose and correct the operating system error<c/> and retry the operation.
08/22/2009 12:06:37,spid9s,Unknown,Error: 17207<c/> Severity: 16<c/> State: 1.
08/22/2009 12:06:37,spid5s,Unknown,Server name is 'ERIE'. This is an informational message only. No user action is required.
08/22/2009 12:06:37,spid9s,Unknown,Starting up database 'model'.
08/22/2009 12:06:36,spid5s,Unknown,The resource database build version is 9.00.3077. This is an informational message only. No user action is required.
08/22/2009 12:06:36,spid5s,Unknown,Starting up database 'mssqlsystemresource'.
08/22/2009 12:06:36,spid5s,Unknown,SQL Trace ID 1 was started by login "sa".
08/22/2009 12:06:35,spid5s,Unknown,CHECKDB for database 'master' finished without errors on 2009-08-21 09:41:02.033 (local time). This is an informational message only; no user action is required.
08/22/2009 12:06:35,spid5s,Unknown,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
08/22/2009 12:06:34,spid5s,Unknown,Starting up database 'master'.
08/22/2009 12:06:34,Server,Unknown,Database mirroring has been enabled on this instance of SQL Server.
08/22/2009 12:06:33,Server,Unknown,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.
08/22/2009 12:06:31,Server,Unknown,Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
08/22/2009 12:06:24,Server,Unknown,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.
08/22/2009 12:06:22,Server,Unknown,Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
08/22/2009 12:06:22,Server,Unknown,Detected 8 CPUs. This is an informational message; no user action is required.
08/22/2009 12:06:22,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
08/22/2009 12:06:22,Server,Unknown,-l D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\mastlog.ldf
08/22/2009 12:06:22,Server,Unknown,-e D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\LOG\ERRORLOG
08/22/2009 12:06:22,Server,Unknown,-d D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\master.mdf
08/22/2009 12:06:22,Server,Unknown,Registry startup parameters:
08/22/2009 12:06:22,Server,Unknown,This instance of SQL Server last reported using a process ID of 2252 at 8/22/2009 12:02:49 PM (local) 8/22/2009 4:02:49 PM (UTC). This is an informational message only; no user action is required.
08/22/2009 12:06:22,Server,Unknown,Logging SQL Server messages in file 'D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\LOG\ERRORLOG'.
08/22/2009 12:06:22,Server,Unknown,Authentication mode is MIXED.
08/22/2009 12:06:22,Server,Unknown,Server process ID is 2228.
08/22/2009 12:06:22,Server,Unknown,All rights reserved.
08/22/2009 12:06:22,Server,Unknown,(c) 2005 Microsoft Corporation.
08/22/2009 12:06:22,Server,Unknown,Microsoft SQL Server 2005 - 9.00.3077.00 (Intel X86) <nl/>      Dec 17 2008 15:19:45 <nl/>      Copyright (c) 1988-2005 Microsoft Corporation<nl/>      Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I can see that if the first service doesn't start as to why the other won't since they are dependent on the first service. The real problem becomes that Citrix can't start/communicate and our Time Clocks fail due to SQL not being started. Any help would be appreciated.
Avatar of hi2sunil
hi2sunil
Flag of United States of America image

hi,

  check your service startup usercredentials, if it is changed then there is a possibility for not getting started.

Thanks
Sunil K
Avatar of evollic
evollic

ASKER

I checked and all three services use "local system". I can also start the services once the server is fully up and I don't have any user credential issues then, it's only on a reboot that they don't start.
hi,

   I believe thats kind of dependency issue, Server is looking for some service/application need to be running, if not it is failing.

Thanks
Sunil K
Avatar of evollic

ASKER

I kinda got the dependency part of it, the problem is the first service "SQL Server (MSSQLSERVER)" fails to start which makes the others fail. I need to figure out why on a reboot the "SQL Server (MSSQLSERVER)" service fails to autostart.
ASKER CERTIFIED SOLUTION
Avatar of Jackie Liu
Jackie Liu
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial