Discussion :

[mims1664]

Bonjour,

Sur SQL-Server 2005, j'ai deux instances : une nommée et une par défaut.
L'instance par défaut ne veut plus démarrer suite à l'arrêt et au redémarrage du serveur.

Voici les erreurs dans les logs :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
2010-11-02 11:49:35.45 Server      Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) 
	Oct 14 2005 00:33:37 
	Copyright (c) 1988-2005 Microsoft Corporation
	Standard Edition on Windows NT 6.1 (Build 7600: )
 
2010-11-02 11:49:35.45 Server      (c) 2005 Microsoft Corporation.
2010-11-02 11:49:35.45 Server      All rights reserved.
2010-11-02 11:49:35.45 Server      Server process ID is 4764.
2010-11-02 11:49:35.45 Server      Logging SQL Server messages in file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.4\MSSQL\LOG\ERRORLOG'.
2010-11-02 11:49:35.45 Server      This instance of SQL Server last reported using a process ID of 964 at 02/11/2010 11:47:30 (local) 02/11/2010 10:47:30 (UTC). This is an informational message only; no user action is required.
2010-11-02 11:49:35.45 Server      Registry startup parameters:
2010-11-02 11:49:35.45 Server      	 -d C:\Program Files (x86)\Microsoft SQL Server\MSSQL.4\MSSQL\DATA\master.mdf
2010-11-02 11:49:35.45 Server      	 -e C:\Program Files (x86)\Microsoft SQL Server\MSSQL.4\MSSQL\LOG\ERRORLOG
2010-11-02 11:49:35.45 Server      	 -l C:\Program Files (x86)\Microsoft SQL Server\MSSQL.4\MSSQL\DATA\mastlog.ldf
2010-11-02 11:49:35.45 Serveur     SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-11-02 11:49:35.45 Serveur     Detected 2 CPUs. This is an informational message; no user action is required.
2010-11-02 11:49:35.77 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.
2010-11-02 11:49:35.77 Serveur     Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-11-02 11:49:36.79 Serveur     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.
2010-11-02 11:49:36.81 Serveur     Database Mirroring Transport is disabled in the endpoint configuration.
2010-11-02 11:49:36.81 spid5s      Starting up database 'master'.
2010-11-02 11:49:36.87 spid5s      SQL Trace ID 1 was started by login "sa".
2010-11-02 11:49:36.89 spid5s      Starting up database 'mssqlsystemresource'.
2010-11-02 11:49:37.10 spid8s      Starting up database 'model'.
2010-11-02 11:49:37.10 spid5s      Server name is 'SQLVIRT01'. This is an informational message only. No user action is required.
2010-11-02 11:49:37.18 spid8s      Clearing tempdb database.
2010-11-02 11:49:37.39 Serveur     A self-generated certificate was successfully loaded for encryption.
2010-11-02 11:49:37.39 Serveur     Erreur*: 26023, Gravité*: 16, État*: 1.
2010-11-02 11:49:37.39 Serveur     Server TCP provider failed to listen on [ 'any' <ipv6> 1433]. Tcp port is already in use.
2010-11-02 11:49:37.40 Serveur     Erreur*: 17182, Gravité*: 16, État*: 1.
2010-11-02 11:49:37.40 Serveur     TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2010-11-02 11:49:37.40 Serveur     Erreur*: 17182, Gravité*: 16, État*: 1.
2010-11-02 11:49:37.40 Serveur     TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2010-11-02 11:49:37.40 Serveur     Erreur*: 17826, Gravité*: 18, État*: 3.
2010-11-02 11:49:37.40 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.
2010-11-02 11:49:37.40 Serveur     Erreur*: 17120, Gravité*: 16, État*: 1.
2010-11-02 11:49:37.40 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.

Je suis un peu paumé, je ne suis pas en IPV6 pourtant il me parle de ce protocole.

C'est un serveur sous HYPERV, le serveur SQL tourne sous Windows 2008R2.

Dans "SQL server configuration manager", dans les protocoles réseau SQL-Server 2005 j'ai cinq cartes réseau dont deux qui ressemblent à de l'ipv6. Elles ne sont pas activées, cf. pièce jointe.

Auriez-vous une idée ?