SQL Server ne démarre pas Résolu

Question

Bonjour, 

J'ai récemment fait l'acquisition de SQL Server 2008 R2.
Après l'avoir installé et configuré mes bases de données
correctement, le service SQL Agent et SQL Server (SQLEXPRESS)
ne veulent plus démarrer.
Même en ayant coché "Système local" dans les droits d'ouverture
de session, le service SQL Server ne démarre pas.
J'ai fait quelques recherches qui n'ont pas porté ses fruits.
C'est donc ici que je fais appel à vous, en espérant avoir une réponse
qui m'aidera à démarrer ces services.

Configuration: Windows 7 / Firefox 5.0

HostOfSeraphim · Accepted Answer

Il semblerait que ta configuration fasse appel à un protocole VIA non supporté par ton matériel, désactive-le dans la conf réseau de SQL Server (SQL Server Network Configuration ou quelque chose du genre).

HostOfSeraphim · Answer

Que dit le journal d'évènement ?

Oxyde13 · Answer

Dernier log enregistré:

2011-07-19 12:43:34.05 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) 
	Apr  2 2010 15:48:46 
	Copyright (c) Microsoft Corporation
	Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

2011-07-19 12:43:34.05 Server      (c) Microsoft Corporation.
2011-07-19 12:43:34.05 Server      All rights reserved.
2011-07-19 12:43:34.05 Server      Server process ID is 2024.
2011-07-19 12:43:34.05 Server      System Manufacturer: 'Gigabyte Technology Co., Ltd.', System Model: 'GA-870A-UD3'.
2011-07-19 12:43:34.05 Server      Authentication mode is MIXED.
2011-07-19 12:43:34.05 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2011-07-19 12:43:34.05 Server      This instance of SQL Server last reported using a process ID of 4332 at 19/07/2011 12:41:05 (local) 19/07/2011 10:41:05 (UTC). This is an informational message only; no user action is required.
2011-07-19 12:43:34.05 Server      Registry startup parameters: 
	 -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\master.mdf
	 -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG
	 -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2011-07-19 12:43:34.08 Serveur     SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-07-19 12:43:34.08 Serveur     Detected 4 CPUs. This is an informational message; no user action is required.
2011-07-19 12:43:34.08 Serveur     Using locked pages for buffer pool.
2011-07-19 12:43:34.10 Serveur     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.
2011-07-19 12:43:34.12 Serveur     Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-07-19 12:43:34.13 spid7s      Starting up database 'master'.
2011-07-19 12:43:34.23 spid7s      Resource governor reconfiguration succeeded.
2011-07-19 12:43:34.23 spid7s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2011-07-19 12:43:34.23 spid7s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
2011-07-19 12:43:34.23 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
2011-07-19 12:43:34.24 spid7s      SQL Trace ID 1 was started by login "sa".
2011-07-19 12:43:34.24 spid7s      Starting up database 'mssqlsystemresource'.
2011-07-19 12:43:34.28 spid7s      The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2011-07-19 12:43:34.38 spid10s     Starting up database 'model'.
2011-07-19 12:43:34.38 spid7s      Server name is 'SPARKK-PC\SQLEXPRESS'. This is an informational message only. No user action is required.
2011-07-19 12:43:34.39 Serveur     Warning: Support for the VIA protocol is deprecated and will be removed in a future version of Microsoft SQL Server. If possible, use a different network protocol and disable VIA.
2011-07-19 12:43:34.39 spid7s      Information : aucune langue prise en charge en texte intégral n'a été trouvée.
2011-07-19 12:43:34.39 spid13s     Starting up database 'msdb'.
2011-07-19 12:43:34.39 spid16s     Starting up database 'auth'.
2011-07-19 12:43:34.39 spid14s     Starting up database 'Telecaster'.
2011-07-19 12:43:34.39 spid15s     Starting up database 'Arcadia'.
2011-07-19 12:43:34.50 Serveur     A self-generated certificate was successfully loaded for encryption.
2011-07-19 12:43:34.50 Serveur     Erreur : 26055, Gravité : 16, État : 1.
2011-07-19 12:43:34.50 Serveur     The SQL Server failed to initialize VIA support library [QLVipl.dll]. This normally indicates the VIA support library does not exist or is corrupted. Please repair or disable the VIA network protocol. Error: 0x7e.
2011-07-19 12:43:34.50 Serveur     Erreur : 17182, Gravité : 16, État : 1.
2011-07-19 12:43:34.50 Serveur     TDSSNIClient initialization failed with error 0x7e, status code 0x60. Reason: Impossible d'initialiser l'écouteur VIA. Le module spécifié est introuvable.

2011-07-19 12:43:34.50 Serveur     Erreur : 17182, Gravité : 16, État : 1.
2011-07-19 12:43:34.50 Serveur     TDSSNIClient initialization failed with error 0x7e, status code 0x1. Reason: Échec de l'initialisation en raison d'une erreur d'infrastructure. Recherchez les erreurs antérieures. Le module spécifié est introuvable.

2011-07-19 12:43:34.50 Serveur     Erreur : 17826, Gravité : 18, État : 3.
2011-07-19 12:43:34.50 Serveur     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2011-07-19 12:43:34.50 Serveur     Erreur : 17120, Gravité : 16, État : 1.
2011-07-19 12:43:34.50 Serveur     SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Oxyde13 · Answer

Ça marche, merci énormément !
Moi qui galérais à trouver le problème, merci mille fois !

SQL Server ne démarre pas

4 réponses

Discussions similaires

Newsletters