on 12-09-2013 12:07 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Please check the following link:
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
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
Hum... exactly! As I suspected, as I said in my previous message please check the following link:
Follow the solution refered in that microsoft forum.
BR,
João Dimas
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
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.