Discussion :

[mayce]

* Bonjour, *

Vous verrez l'erreur en pièces jointes
je viens de désinstaller sql server 2K5 pour 2K8 et je ne peux l'utiliser

* Merci *

[elsuket]

Bonjour,

Jetez un œil à ce billet

@++

[mayce]

Bonjour,

Jetez un œil à ce billet

@++

c'est pareil ma machine abrite le serveur c'est ce qui me fait bizarre pourquoi ma propre machine refuse de lancer les services

[dbaffaleuf]

Hello,

Peux-tu poster le contenu de l'ERRORLOG suite à la tentative de démarrage en échec ?

Merci,

David B.

[mayce]

Nom du journal*:Application
Source*: MSSQLSERVER
Date*: 11/02/2010 12:17:43
ID de l'événement*:19032
Catégorie de la tâche*2)
Niveau*: Information
Mots clés*: Classique
Utilisateur*: N/A
Ordinateur*: LP-DSI-48.mtn.ci
Description*:
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
XML de l’événement*:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="16384">19032</EventID>
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2010-02-11T12:17:43.000Z" />
<EventRecordID>75784</EventRecordID>
<Channel>Application</Channel>
<Computer>LP-DSI-48.mtn.ci</Computer>
<Security />
</System>
<EventData>
<Data>1</Data>
<Binary>584A00000A0000000A0000004C0050002D004400530049002D00340038000000070000006D00610073007400650072000000</Binary>
</EventData>
</Event>

[dbaffaleuf]

Hello,

Je parlais du fichier ERRORLOG qui se trouve sous l'arborescence de ton instance dans le répertoire ~\Log.

Merci,

[mayce]

Hello,

Je parlais du fichier ERRORLOG qui se trouve sous l'arborescence de ton instance dans le répertoire ~\Log.

Merci,

2010-02-11 12:16:44.74 Server Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)

2010-02-11 12:16:47.09 Server (c) 2005 Microsoft Corporation.
2010-02-11 12:16:47.09 Server All rights reserved.
2010-02-11 12:16:47.09 Server Server process ID is 6960.
2010-02-11 12:16:47.19 Server System Manufacturer: 'Hewlett-Packard', System Model: 'HP EliteBook 8530p'.
2010-02-11 12:16:47.30 Server Authentication mode is MIXED.
2010-02-11 12:16:47.48 Server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2010-02-11 12:16:47.88 Server This instance of SQL Server last reported using a process ID of 2948 at 11/02/2010 08:27:43 (local) 11/02/2010 08:27:43 (UTC). This is an informational message only; no user action is required.
2010-02-11 12:16:47.88 Server Registry startup parameters:
-d D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
-e D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2010-02-11 12:16:48.70 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-02-11 12:16:48.70 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-02-11 12:16:59.08 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.
2010-02-11 12:17:13.99 Server Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2010-02-11 12:17:20.90 spid6s Starting up database 'master'.
2010-02-11 12:17:26.20 spid6s Recovery completed for database master (database ID 1) in 1 second(s) (analysis 488 ms, redo 0 ms, undo 1028 ms.) This is an informational message only. No user action is required.
2010-02-11 12:17:30.59 spid6s Resource governor reconfiguration succeeded.
2010-02-11 12:17:30.59 spid6s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2010-02-11 12:17:31.11 spid6s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2010-02-11 12:17:31.28 spid6s FILESTREAM: effective level = 0, configured level = 2, file system access share name = 'MSSQLSERVER'.
2010-02-11 12:17:36.62 spid6s SQL Trace ID 1 was started by login "sa".
2010-02-11 12:17:37.04 spid6s Starting up database 'mssqlsystemresource'.
2010-02-11 12:17:37.66 spid6s The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
2010-02-11 12:17:41.40 spid6s Error: 15209, Severity: 16, State: 1.
2010-02-11 12:17:41.40 spid6s An error occurred during encryption.
2010-02-11 12:17:43.08 spid6s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

[dbaffaleuf]

Ca peut être celle-là, même si tu as l'air d'être en Enterprise Edition.

http://support.microsoft.com/kb/920114

Il faudrait vérifier que le compte de service de SQL Server n'est pas NETWORK SERVICE. Idéalement il faut que ton compte de service soit dans le groupe windows pour le service MSSQL créé par l'installer de 2008, dans ton cas il doit s'appeler qq chose comme:

SQLServerMSSQLUser$LP-DSI-48.mtn.ci$MSSQLSERVER