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,Messa ge
08/22/2009 12:06:38,spid9s,Unknown,SQ L 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,Co uld 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,Da tabase '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,Er ror: 945<c/> Severity: 14<c/> State: 2.
08/22/2009 12:06:38,spid9s,Unknown,Fi le activation failure. The physical file name "D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\ modellog.l df" may be incorrect.
08/22/2009 12:06:38,spid9s,Unknown,Un able to open the physical file "D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\ modellog.l df". 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,Er ror: 5120<c/> Severity: 16<c/> State: 101.
08/22/2009 12:06:38,spid9s,Unknown,FC B::Open failed: Could not open file D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\ modellog.l df 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,Er ror: 17204<c/> Severity: 16<c/> State: 1.
08/22/2009 12:06:38,spid9s,Unknown,FC B::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.l df'. Diagnose and correct the operating system error<c/> and retry the operation.
08/22/2009 12:06:38,spid9s,Unknown,Er ror: 17207<c/> Severity: 16<c/> State: 1.
08/22/2009 12:06:37,spid9s,Unknown,Un able 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,Er ror: 5120<c/> Severity: 16<c/> State: 101.
08/22/2009 12:06:37,spid9s,Unknown,FC B::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,Er ror: 17204<c/> Severity: 16<c/> State: 1.
08/22/2009 12:06:37,spid9s,Unknown,FC B::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,Er ror: 17207<c/> Severity: 16<c/> State: 1.
08/22/2009 12:06:37,spid5s,Unknown,Se rver name is 'ERIE'. This is an informational message only. No user action is required.
08/22/2009 12:06:37,spid9s,Unknown,St arting up database 'model'.
08/22/2009 12:06:36,spid5s,Unknown,Th e 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,St arting up database 'mssqlsystemresource'.
08/22/2009 12:06:36,spid5s,Unknown,SQ L Trace ID 1 was started by login "sa".
08/22/2009 12:06:35,spid5s,Unknown,CH ECKDB 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,Re covery 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,St arting up database 'master'.
08/22/2009 12:06:34,Server,Unknown,Da tabase mirroring has been enabled on this instance of SQL Server.
08/22/2009 12:06:33,Server,Unknown,At tempting 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,At tempting 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,Us ing 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,Se t AWE Enabled to 1 in the configuration parameters to allow use of more memory.
08/22/2009 12:06:22,Server,Unknown,De tected 8 CPUs. This is an informational message; no user action is required.
08/22/2009 12:06:22,Server,Unknown,SQ L 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.ld f
08/22/2009 12:06:22,Server,Unknown,-e D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\LOG\E RRORLOG
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,Re gistry startup parameters:
08/22/2009 12:06:22,Server,Unknown,Th is 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,Lo gging SQL Server messages in file 'D:\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\LOG\E RRORLOG'.
08/22/2009 12:06:22,Server,Unknown,Au thenticati on mode is MIXED.
08/22/2009 12:06:22,Server,Unknown,Se rver process ID is 2228.
08/22/2009 12:06:22,Server,Unknown,Al l rights reserved.
08/22/2009 12:06:22,Server,Unknown,(c ) 2005 Microsoft Corporation.
08/22/2009 12:06:22,Server,Unknown,Mi crosoft 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.
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,Messa
08/22/2009 12:06:38,spid9s,Unknown,SQ
08/22/2009 12:06:38,spid9s,Unknown,Co
08/22/2009 12:06:38,spid9s,Unknown,Da
08/22/2009 12:06:38,spid9s,Unknown,Er
08/22/2009 12:06:38,spid9s,Unknown,Fi
08/22/2009 12:06:38,spid9s,Unknown,Un
08/22/2009 12:06:38,spid9s,Unknown,Er
08/22/2009 12:06:38,spid9s,Unknown,FC
08/22/2009 12:06:38,spid9s,Unknown,Er
08/22/2009 12:06:38,spid9s,Unknown,FC
08/22/2009 12:06:38,spid9s,Unknown,Er
08/22/2009 12:06:37,spid9s,Unknown,Un
08/22/2009 12:06:37,spid9s,Unknown,Er
08/22/2009 12:06:37,spid9s,Unknown,FC
08/22/2009 12:06:37,spid9s,Unknown,Er
08/22/2009 12:06:37,spid9s,Unknown,FC
08/22/2009 12:06:37,spid9s,Unknown,Er
08/22/2009 12:06:37,spid5s,Unknown,Se
08/22/2009 12:06:37,spid9s,Unknown,St
08/22/2009 12:06:36,spid5s,Unknown,Th
08/22/2009 12:06:36,spid5s,Unknown,St
08/22/2009 12:06:36,spid5s,Unknown,SQ
08/22/2009 12:06:35,spid5s,Unknown,CH
08/22/2009 12:06:35,spid5s,Unknown,Re
08/22/2009 12:06:34,spid5s,Unknown,St
08/22/2009 12:06:34,Server,Unknown,Da
08/22/2009 12:06:33,Server,Unknown,At
08/22/2009 12:06:31,Server,Unknown,At
08/22/2009 12:06:24,Server,Unknown,Us
08/22/2009 12:06:22,Server,Unknown,Se
08/22/2009 12:06:22,Server,Unknown,De
08/22/2009 12:06:22,Server,Unknown,SQ
08/22/2009 12:06:22,Server,Unknown,-l
08/22/2009 12:06:22,Server,Unknown,-e
08/22/2009 12:06:22,Server,Unknown,-d
08/22/2009 12:06:22,Server,Unknown,Re
08/22/2009 12:06:22,Server,Unknown,Th
08/22/2009 12:06:22,Server,Unknown,Lo
08/22/2009 12:06:22,Server,Unknown,Au
08/22/2009 12:06:22,Server,Unknown,Se
08/22/2009 12:06:22,Server,Unknown,Al
08/22/2009 12:06:22,Server,Unknown,(c
08/22/2009 12:06:22,Server,Unknown,Mi
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.
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
check your service startup usercredentials, if it is changed then there is a possibility for not getting started.
Thanks
Sunil K