SQL Server services problem (doesn´t start)

[Former Member]

Hello,

I´m facing an error when I try to start the SQL Server database services in Windows Server 2008, for this reason, we can´t start our SAP system.

I done a reboot to the server but even so two MS SQL Server services doesn´t start!

When I try to start both services manually, it show me the following errors:

Windows could not start the SQL Server Agent (MSSQLSERVER) service on Local Computer.

Error 1068: The dependency service or group failed to start.

Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 1814.

I checked the Event Viewer (System) and the only thing that I see is the following details...

- For the SQL Server (MSSQLSERVER) service:

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

For the SQL Server Agent (MSSQLSERVER) service:

The SQL Server Agent (MSSQLSERVER) service depends on the SQL Server (MSSQLSERVER) service which failed to start because of the following error:

The service has returned a service-specific error code.

Any tips?

Can you help me please?

Kind regards,

samid raif

[Former Member · Accepted solution]

Hello,

More details about this issue... I ran the command R3trans -x and this is the output:

4 ETW000 r3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 09.12.2013 - 13:15:04

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -x

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Mon Dec 09 13:15:04 2013                                                  85  0.000085

4 ETW000  [     dev trc,00000]  db_con_init called                                                        36  0.000121

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        46  0.000167

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  35  0.000202

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 20  0.000222

4 ETW000  [     dev trc,00000]  Loading DB library 'dbmssslib.dll' ...                                    35  0.000257

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007FEF1A70000

4 ETW000                                                                                                4868  0.005125

4 ETW000  [     dev trc,00000]      using "K:\usr\sap\SDV\DVEBMGS00\exe\dbmssslib.dll"                    15  0.005140

4 ETW000  [     dev trc,00000]  Library 'dbmssslib.dll' loaded                                            16  0.005156

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbmssslib.dll                    17  0.005173

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "720.00", patchlevel (0.512)               114  0.005287

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbmssslib.dll                   22  0.005309

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbmssslib.dll                  15  0.005324

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  25  0.005349

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  34  0.005383

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             16  0.005399

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  21  0.005420

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          14  0.005434

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  28  0.005462

4 ETW000  [     dev trc,00000]  Thread ID:2164                                                           864  0.006326

4 ETW000  [     dev trc,00000]  Thank You for using the SLODBC-interface                                  25  0.006351

4 ETW000  [     dev trc,00000]  Using dynamic link library 'K:\usr\sap\SDV\DVEBMGS00\exe\dbmssslib.dll'

4 ETW000                                                                                                  29  0.006380

4 ETW000  [     dev trc,00000]  dbmssslib.dll patch info                                                  45  0.006425

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       16  0.006441

4 ETW000  [     dev trc,00000]    SAP patchno  512                                                        54  0.006495

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                            18  0.006513

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchno         512                                     16  0.006529

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchcomment Workarea Insert/Update with locators: wrong data written (1901735)

4 ETW000                                                                                                  26  0.006555

4 ETW000  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native                 815  0.007370

4 ETW000  [     dev trc,00000]  lpc:(local) connection used on PICDV0401                                 107  0.007477

4 ETW000  [     dev trc,00000]  Mon Dec 09 13:15:19 2013                                             15015111  15.022588

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                 113  15.022701

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Could not open a connection to SQL Server [2].

4 ETW000                                                                                                  29  15.022730

4 ETW000  [     dev trc,00000]  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART                18  15.022748

4 ETW000  [     dev trc,00000]  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                           25  15.022773

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  25  15.022798

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

4 ETW000                                                                                                  22  15.022820

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  24  15.022844

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

4 ETW000                                                                                                  41  15.022885

4 ETW000  [     dev trc,00000]  Mon Dec 09 13:15:34 2013                                             15006860  30.029745

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  92  30.029837

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Could not open a connection to SQL Server [2].

4 ETW000                                                                                                  29  30.029866

4 ETW000  [     dev trc,00000]  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART                18  30.029884

4 ETW000  [     dev trc,00000]  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                           16  30.029900

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  25  30.029925

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

4 ETW000                                                                                                  27  30.029952

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  26  30.029978

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

4 ETW000                                                                                                  40  30.030018

4 ETW000  [     dev trc,00000]  Mon Dec 09 13:15:49 2013                                             15007173  45.037191

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                 115  45.037306

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: Could not open a connection to SQL Server [2].

4 ETW000                                                                                                  31  45.037337

4 ETW000  [     dev trc,00000]  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART                18  45.037355

4 ETW000  [     dev trc,00000]  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                           15  45.037370

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  26  45.037396

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

4 ETW000                                                                                                  23  45.037419

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  25  45.037444

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

4 ETW000                                                                                                  40  45.037484

4 ETW000  [     dev trc,00000]  Mon Dec 09 13:16:05 2013                                             15677537  60.715021

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                 107  60.715128

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].

4 ETW000                                                                                                  29  60.715157

4 ETW000  [     dev trc,00000]  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART                17  60.715174

4 ETW000  [     dev trc,00000]  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                           15  60.715189

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  24  60.715213

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

4 ETW000                                                                                                  26  60.715239

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  23  60.715262

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

4 ETW000                                                                                                  38  60.715300

4 ETW000  [     dev trc,00000]  Mon Dec 09 13:16:21 2013                                             15599710  76.315010

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                 112  76.315122

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].

4 ETW000                                                                                                  45  76.315167

4 ETW000  [     dev trc,00000]  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART                18  76.315185

4 ETW000  [     dev trc,00000]  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                           16  76.315201

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  25  76.315226

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

4 ETW000                                                                                                  22  76.315248

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  25  76.315273

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

4 ETW000                                                                                                  40  76.315313

4 ETW000  [     dev trc,00000]  Mon Dec 09 13:16:36 2013                                             15646533  91.961846

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  86  91.961932

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].

4 ETW000                                                                                                  29  91.961961

4 ETW000  [     dev trc,00000]  native_db_err 2 severity 0 errclass set to DBSL_EC_RESTART                16  91.961977

4 ETW000  [     dev trc,00000]  sl_glob.dbsl_ca.errclass set to DBSL_EC_RESTART                           15  91.961992

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  24  91.962016

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Server Native Client 10.0]Login timeout expired

4 ETW000                                                                                                 258  91.962274

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2460]

4 ETW000                                                                                                  36  91.962310

4 ETW000  [     dev trc,00000]  (2) [08001] [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

4 ETW000                                                                                                  39  91.962349

4 ETW000  [     dev trc,00000]  Connection 0 failed using Driver={SQL Server Native Client 10.0};Server=PICDV0401;AutoTranslate=no;Trusted_Connection=yes;WSID=PICDV0401;APP=R3 00 comm rd ODBC;Database=SDV;

4 ETW000                                                                                                  39  91.962388

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 2      performing CON                              464  91.962852

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>Named Pipes Provider: Could not open a connection to SQL Server [2].

4 ETW000                                                                                                  37  91.962889

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'PICDV0401' DBNAME = 'SDV'"

Any tips?

Regards,

samid raif

[joo_migueldimas · Accepted solution]

Hello,

Please check the following link:

sql server will not start - Database &amp;#39;model&amp;#39; cannot be opened. It is in the middle ...

Check the errors in the log files of SQL Server:

<drive>\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log

But it seems to me that is related with the database 'model' restoring... like it´s described in the above link.

Can you post here the log files of SQL Server services?

BR,

João Dimas

[Former Member · Accepted solution]

Hi,

I checked the log files and this is the output:

2013-12-09 20:56:08.73 Server

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)

    Sep 21 2011 22:45:45

    Copyright (c) 1988-2008 Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM)

2013-12-09 20:56:08.73 Server	(c) 2005 Microsoft Corporation.
2013-12-09 20:56:08.73 Server	All rights reserved.
2013-12-09 20:56:08.73 Server	Server process ID is 4740.
2013-12-09 20:56:08.73 Server	System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.
2013-12-09 20:56:08.73 Server	Authentication mode is WINDOWS-ONLY.
2013-12-09 20:56:08.73 Server	Logging SQL Server messages in file 'K:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2013-12-09 20:56:08.73 Server	This instance of SQL Server last reported using a process ID of 5396 at 12/9/2013 8:55:15 PM (local) 12/9/2013 7:55:15 PM (UTC). This is an informational message only; no user action is required.
2013-12-09 20:56:08.73 Server	Registry startup parameters:

     -d K:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf

     -e K:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG

     -l K:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

2013-12-09 20:56:08.75 Server	SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-12-09 20:56:08.75 Server	Detected 8 CPUs. This is an informational message; no user action is required.
2013-12-09 20:56:08.75 Server	Large Page Extensions enabled.
2013-12-09 20:56:08.75 Server	Large Page Granularity: 2097152
2013-12-09 20:56:08.75 Server	Large Page Allocated: 32MB
2013-12-09 20:56:08.79 Server	Using locked pages for buffer pool.
2013-12-09 20:56:08.81 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.
2013-12-09 20:56:17.08 Server	Node configuration: node 0: CPU mask: 0x00000000000000ff Active CPU mask: 0x00000000000000ff. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-12-09 20:56:17.12 spid7s	Starting up database 'master'.
2013-12-09 20:56:17.20 spid7s	Resource governor reconfiguration succeeded.
2013-12-09 20:56:17.20 spid7s	SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2013-12-09 20:56:17.20 spid7s	SQL Server Audit has started the audits. This is an informational message. No user action is required.
2013-12-09 20:56:17.20 spid7s	FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-12-09 20:56:17.21 spid7s	SQL Trace ID 1 was started by login "sa".
2013-12-09 20:56:17.21 spid7s	Starting up database 'mssqlsystemresource'.
2013-12-09 20:56:17.22 spid7s	The resource database build version is 10.00.5500. This is an informational message only. No user action is required.
2013-12-09 20:56:17.26 spid11s	Starting up database 'model'.
2013-12-09 20:56:17.26 spid7s	Server name is 'PICDV0401'. This is an informational message only. No user action is required.
2013-12-09 20:56:17.27 spid11s	The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.
2013-12-09 20:56:17.27 spid11s	Error: 927, Severity: 14, State: 2.
2013-12-09 20:56:17.27 spid11s	Database 'model' cannot be opened. It is in the middle of a restore.
2013-12-09 20:56:17.27 spid11s	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.
2013-12-09 20:56:17.27 spid11s	SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Any tips?

Kind regards,

samid raif

[joo_migueldimas · Accepted solution]

Hum... exactly! As I suspected, as I said in my previous message please check the following link:

sql server will not start - Database &amp;#39;model&amp;#39; cannot be opened. It is in the middle ...

Follow the solution refered in that microsoft forum.

BR,

João Dimas

[Former Member · Accepted solution]

Hello João Dimas,

That solve the problem

I read the link that you shared... I followed the instructions in that link!

This is what I did:

C:\Users\Administrator>net start MSSQLSERVER /T3608

The SQL Server (MSSQLSERVER) service is starting....

The SQL Server (MSSQLSERVER) service was started successfully.

C:\Users\Administrator>sqlcmd -e

1> restore database model

2> go

restore database model

RESTORE DATABASE successfully processed 0 pages in 0.402 seconds (0.000 MB/sec).

1>

Now, I can start the SQL Server services and now the database starts appropriately. I started the SAP system without problems!

Thank you very much for your help,

Kind regards,

samid raif