IdentifiantMot de passe
Loading...
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

MS SQL Server Discussion :

Dump Sql server Express 2005 sp4


Sujet :

MS SQL Server

Vue hybride

Message précédent Message précédent   Message suivant Message suivant
  1. #1
    Membre du Club
    Homme Profil pro
    Développeur .NET
    Inscrit en
    Juin 2011
    Messages
    7
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France

    Informations professionnelles :
    Activité : Développeur .NET
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Juin 2011
    Messages : 7
    Par défaut Dump Sql server Express 2005 sp4
    Bonjour,
    Je n'arrive pas pas installer le package.
    Option: local service, ajout de l utilisateur courant dans le compte admin de SqlServer. Il dumpe lors du lancement du service MsSqlserver.
    System Xp embedded sp2 ( je signale que le XPE supporte Sql 2005 express si on lui ajoute la macro sqlserver 2005 adéquate et l installer wds 5.1)
    Ci joint le dumpe.

    2012-12-26 11:39:14.94 Server Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
    Dec 10 2010 10:56:29
    Copyright (c) 1988-2005 Microsoft Corporation
    Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    2012-12-26 11:39:14.95 Server (c) 2005 Microsoft Corporation.
    2012-12-26 11:39:14.95 Server All rights reserved.
    2012-12-26 11:39:14.95 Server Server process ID is 868.
    2012-12-26 11:39:14.95 Server Authentication mode is MIXED.
    2012-12-26 11:39:14.96 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
    2012-12-26 11:39:14.96 Server Registry startup parameters:
    2012-12-26 11:39:14.98 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
    2012-12-26 11:39:14.98 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
    2012-12-26 11:39:14.98 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
    2012-12-26 11:39:14.98 Server Command Line Startup Parameters:
    2012-12-26 11:39:14.98 Server -m SqlSetup
    2012-12-26 11:39:14.98 Server SqlSetup
    2012-12-26 11:39:14.98 Server -Q
    2012-12-26 11:39:14.98 Server -q SQL_Latin1_General_CP1_CS_AS
    2012-12-26 11:39:14.98 Server -T 4022
    2012-12-26 11:39:14.98 Server -T 3659
    2012-12-26 11:39:14.98 Server -T 3610
    2012-12-26 11:39:14.98 Server -T 4010
    2012-12-26 11:39:15.02 Server Error: 17311, Severity: 16, State: 1.
    2012-12-26 11:39:15.02 Server SQL Server is terminating because of fatal exception c000001d. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
    2012-12-26 11:39:15.05 Server Using 'dbghelp.dll' version '4.0.5'
    2012-12-26 11:39:15.08 Server **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000
    2012-12-26 11:39:15.08 Server ***Stack Dump being sent to c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt
    2012-12-26 11:39:15.08 Server * *******************************************************************************
    2012-12-26 11:39:15.08 Server *
    2012-12-26 11:39:15.08 Server * BEGIN STACK DUMP:
    2012-12-26 11:39:15.08 Server * 12/26/12 11:39:15 spid 0
    2012-12-26 11:39:15.08 Server *
    2012-12-26 11:39:15.08 Server * ex_handle_except encountered exception C000001D - Server terminating
    2012-12-26 11:39:15.08 Server *
    2012-12-26 11:39:15.08 Server *
    2012-12-26 11:39:15.08 Server * MODULE BASE END SIZE
    2012-12-26 11:39:15.08 Server * sqlservr 01000000 02C26FFF 01c27000
    2012-12-26 11:39:15.08 Server * ntdll 7C900000 7C9AFFFF 000b0000
    2012-12-26 11:39:15.08 Server * kernel32 7C800000 7C8F4FFF 000f5000
    2012-12-26 11:39:15.08 Server * MSVCR80 78130000 781CAFFF 0009b000
    2012-12-26 11:39:15.08 Server * msvcrt 77C10000 77C67FFF 00058000
    2012-12-26 11:39:15.08 Server * MSVCP80 7C420000 7C4A6FFF 00087000
    2012-12-26 11:39:15.08 Server * ADVAPI32 77DD0000 77E6AFFF 0009b000
    2012-12-26 11:39:15.08 Server * RPCRT4 77E70000 77F00FFF 00091000
    2012-12-26 11:39:15.08 Server * sqlos 344D0000 344D4FFF 00005000
    2012-12-26 11:39:15.08 Server * Secur32 77FE0000 77FF0FFF 00011000
    2012-12-26 11:39:15.08 Server * USERENV 769C0000 76A72FFF 000b3000
    2012-12-26 11:39:15.08 Server * USER32 7E410000 7E4A0FFF 00091000
    2012-12-26 11:39:15.08 Server * GDI32 77F10000 77F56FFF 00047000
    2012-12-26 11:39:15.09 Server * WINMM 76B40000 76B6CFFF 0002d000
    2012-12-26 11:39:15.09 Server * opends60 333E0000 333E6FFF 00007000
    2012-12-26 11:39:15.09 Server * NETAPI32 5B860000 5B8B4FFF 00055000
    2012-12-26 11:39:15.09 Server * IMM32 76390000 763ACFFF 0001d000
    2012-12-26 11:39:15.09 Server * psapi 76BF0000 76BFAFFF 0000b000
    2012-12-26 11:39:15.09 Server * instapi 48060000 48069FFF 0000a000
    2012-12-26 11:39:15.09 Server * sqlevn70 4F610000 4F7B8FFF 001a9000
    2012-12-26 11:39:15.09 Server * dbghelp 03000000 03114FFF 00115000
    2012-12-26 11:39:15.09 Server *
    2012-12-26 11:39:15.09 Server * Edi: 007BC0FC: 000DC6A8 000D1378 000D0000 000D20A0 007BC0FC 000D3420
    2012-12-26 11:39:15.09 Server * Esi: 00000000:
    2012-12-26 11:39:15.09 Server * Eax: 007BBFE0: 000042AC 00000000 00000000 7C812A5B 00000000 00000002
    2012-12-26 11:39:15.09 Server * Ebx: 0000003F:
    2012-12-26 11:39:15.09 Server * Ecx: 007BC650: 00000000 0001001F 00000000 00000000 00000000 00000000
    2012-12-26 11:39:15.09 Server * Edx: 0000003D:
    2012-12-26 11:39:15.09 Server * Eip: 7C812A5B: 10C2C95E 0FFF8500 FF93368E FC558BFF 0F0C5589 7D8B16B7
    2012-12-26 11:39:15.09 Server * Ebp: 007BC030: 007BC074 021B35AC 000042AC 00000000 00000000 00000000
    2012-12-26 11:39:15.09 Server * SegCs: 0000001B:
    2012-12-26 11:39:15.09 Server * EFlags: 00000246:
    2012-12-26 11:39:15.09 Server * Esp: 007BBFDC: 00000000 000042AC 00000000 00000000 7C812A5B 00000000
    2012-12-26 11:39:15.09 Server * SegSs: 00000023:
    2012-12-26 11:39:15.09 Server * *******************************************************************************
    2012-12-26 11:39:15.09 Server * -------------------------------------------------------------------------------
    2012-12-26 11:39:15.09 Server * Short Stack Dump
    2012-12-26 11:39:15.15 Server 7C812A5B Module(kernel32+00012A5B)
    2012-12-26 11:39:15.15 Server 021B35AC Module(sqlservr+011B35AC)
    2012-12-26 11:39:15.16 Server 021B74C0 Module(sqlservr+011B74C0)
    2012-12-26 11:39:15.16 Server 021B706D Module(sqlservr+011B706D)
    2012-12-26 11:39:15.16 Server 02428329 Module(sqlservr+01428329)
    2012-12-26 11:39:15.16 Server 7C8631CE Module(kernel32+000631CE)
    2012-12-26 11:39:15.23 Server 7C83AA78 Module(kernel32+0003AA78)
    2012-12-26 11:39:15.24 Server Stack Signature for the dump is 0xDEC52977

    ou un autre log

    <Func Name='LaunchFunction'>
    Function=Do_sqlFileRename
    <Func Name='GetCAContext'>
    <EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
    Doing Action: Do_sqlFileRename
    PerfTime Start: Do_sqlFileRename : Wed Dec 26 11:39:12 2012
    <Func Name='Do_sqlFileRename'>
    <EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
    PerfTime Stop: Do_sqlFileRename : Wed Dec 26 11:39:12 2012
    MSI (s) (4C:0C) [11:39:12:676]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])
    <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
    MSI (s) (4C:0C) [11:39:12:686]: Executing op: CustomActionSchedule(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server95298000lpc:.\SQLEXPRESS)
    MSI (s) (4C:0C) [11:39:12:696]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])
    MSI (s) (4C:0C) [11:39:12:706]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********)
    MSI (s) (4C:F4) [11:39:12:746]: Invoking remote custom action. DLL: C:\windows\Installer\MSI11E.tmp, Entrypoint: Do_sqlScript
    <Func Name='LaunchFunction'>
    Function=Do_sqlScript
    <Func Name='GetCAContext'>
    <EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
    Doing Action: Do_sqlScript
    PerfTime Start: Do_sqlScript : Wed Dec 26 11:39:13 2012
    Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CS_AS -T4022 -T3659 -T3610 -T4010' is being started at Wed Dec 26 11:39:13 2012
    Service failed unexpectedly (1067)
    Error Code: 0x8007042b (1067)
    Windows Error Text: The process terminated unexpectedly.
    Source File Name: sqlsetuplib\service.cpp
    Compiler Timestamp: Sat Sep 18 20:51:30 2010
    Function Name: sqls::Service::Start
    Source Line Number: 301



    ---- Context -----------------------------------------------


    Setting status of unmanaged components and removing unmanaged resources
    Do_sqlScript
    SqlScriptHlpr
    Start service MSSQL$SQLEXPRESS



    Error Code: 1067
    MSI (s) (4C!2C) [11:39:59:523]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
    The error is (1067) The process terminated unexpectedly.
    .

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
    The error is (1067) The process terminated unexpectedly.
    .
    <Func Name='GetCAContext'>
    <EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
    Doing Action: Do_sqlScript
    PerfTime Start: Do_sqlScript : Wed Dec 26 11:39:59 2012
    Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CS_AS -T4022 -T3659 -T3610 -T4010' is being started at Wed Dec 26 11:39:59 2012
    Service failed unexpectedly (1067)
    Error Code: 0x8007042b (1067)
    Windows Error Text: The process terminated unexpectedly.
    Source File Name: sqlsetuplib\service.cpp
    Compiler Timestamp: Sat Sep 18 20:51:30 2010
    Function Name: sqls::Service::Start
    Source Line Number: 301



    ---- Context -----------------------------------------------


    Setting status of unmanaged components and removing unmanaged resources
    Do_sqlScript
    SqlScriptHlpr
    Start service MSSQL$SQLEXPRESS
    Do_sqlScript
    SqlScriptHlpr
    Start service MSSQL$SQLEXPRESS



    Error Code: 1067
    MSI (s) (4C!2C) [11:40:13:013]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
    The error is (1067) The process terminated unexpectedly.
    .

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
    The error is (1067) The process terminated unexpectedly.
    .
    <Failure Type='Fatal' Error='1067'>
    <EndFunc Name='LaunchFunction' Return='1067' GetLastError='203'>
    MSI (s) (4C:0C) [11:40:13:153]: User policy value 'DisableRollback' is 0
    MSI (s) (4C:0C) [11:40:13:153]: Machine policy value 'DisableRollback' is 0
    Action ended 11:40:13: InstallFinalize. Return value 3.
    MSI (s) (4C:0C) [11:40:13:584]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=1100635276,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
    MSI (s) (4C:0C) [11:40:13:584]: Executing op: DialogInfo(Type=0,Argument=1033)
    MSI (s) (4C:0C) [11:40:13:594]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005 Express Edition)
    MSI (s) (4C:0C) [11:40:13:594]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
    MSI (s) (4C:0C) [11:40:13:604]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])
    MSI (s) (4C:0C) [11:40:13:604]: Executing op: ProductInfo(ProductKey={2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F},ProductName=Microsoft SQL Server 2005 Express Edition,PackageName=sqlrun_sql.msi,Language=1033,Version=151262088,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={49616E1E-6C6B-4938-B811-352C355EFDCE},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0)
    MSI (s) (4C:0C) [11:40:13:614]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])
    MSI (s) (4C:0C) [11:40:13:624]: Executing op: CustomActionRollback(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server95298000lpc:.\SQLEXPRESS)
    MSI (s) (4C:A0) [11:40:13:644]: Invoking remote custom action. DLL: C:\windows\Installer\MSI11F.tmp, Entrypoint: Rollback_sqlScript
    <Func Name='LaunchFunction'>

    Cordialement

  2. #2
    Membre du Club
    Homme Profil pro
    Développeur .NET
    Inscrit en
    Juin 2011
    Messages
    7
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France

    Informations professionnelles :
    Activité : Développeur .NET
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Juin 2011
    Messages : 7
    Par défaut pb Smart device
    Je réponds à moi même:

    Error message when you try to install SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services: "Server SQL Server is terminating because of fatal exception c000001d"
    Article ID: 919392 - View products that this article applies to.
    Expand all | Collapse all
    SYMPTOMS
    When you try to install Microsoft SQL Server 2005 Express Edition (SQL Server Express) or Microsoft SQL Server 2005 Express Edition with Advanced Services, the installation fails. Additionally, you receive the following error message:
    Server SQL Server is terminating because of fatal exception c000001d.
    If you examine the SQL Server error log when this problem occurs, you see an error message that resembles one of the following:
    Error message 1
    SqlDumpExceptionHandler: Process 4 generated fatal exception c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
    Error message 2
    2006-03-02 22:40:24.79 Server Error: 17311, Severity: 16, State: 1.
    2006-03-02 22:40:24.79 Server SQL Server is terminating because of fatal exception c000001d. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling.
    For more information about how to examine the SQL Server error log, visit the following Microsoft Developer Network (MSDN) Web site:
    http://msdn2.microsoft.com/en-us/library/ms187885.aspx
    Back to the top | Give Feedback
    CAUSE
    This problem occurs because of one of the following reasons:
    The computer on which you try to install SQL Server Express or SQL Server Express with Advanced Services is equipped with a CPU that does not support cache prefetching.

    The affected CPUs include VIA Eden CPUs and Transmeta CPUs. Typically, these CPUs are used in devices when low power consumption, low heat, or low noise is important.
    The media from which you try to install SQL Server Express or SQL Server Express with Advanced Services is corrupted.
    Back to the top | Give Feedback
    STATUS
    Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
    Back to the top | Give Feedback
    MORE INFORMATION
    Microsoft has no plans to provide support for CPUs that do not support cache prefetching. If you experience this problem because of the CPU, you must install SQL Server Express or SQL Server Express with Advanced Services on a different computer that is equipped with a CPU that supports cache prefetching.

    The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
    Back to the top | Give Feedback
    Properties
    Article ID: 919392 - Last Review: June 2, 2006 - Revision: 1.1
    APPLIES TO
    Microsoft SQL Server 2005 Express Edition
    Microsoft SQL Server 2005 Express Edition with Advanced Services

    Est ce qu'on pourrait contourner ce fichue pb ?

  3. #3
    Membre du Club
    Homme Profil pro
    Développeur .NET
    Inscrit en
    Juin 2011
    Messages
    7
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France

    Informations professionnelles :
    Activité : Développeur .NET
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Juin 2011
    Messages : 7
    Par défaut Fanless device
    Je précise :

    Système Panel Pc cpu Vortex DX86 1 Ghz, 500 meg ram ddr2
    Compact flash 2 giga.

    J'ai juste un warning au pré requis hardware puis ts les composants s'installent bien sauf au dernier (service MsSqlServe).

    Voilà pas d'autres idées ?

  4. #4
    Membre du Club
    Homme Profil pro
    Développeur .NET
    Inscrit en
    Juin 2011
    Messages
    7
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France

    Informations professionnelles :
    Activité : Développeur .NET
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Juin 2011
    Messages : 7
    Par défaut
    Pb hardware pas de solution.

  5. #5
    Rédacteur

    Avatar de SQLpro
    Homme Profil pro
    Expert bases de données / SQL / MS SQL Server / Postgresql
    Inscrit en
    Mai 2002
    Messages
    22 008
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France, Var (Provence Alpes Côte d'Azur)

    Informations professionnelles :
    Activité : Expert bases de données / SQL / MS SQL Server / Postgresql
    Secteur : Conseil

    Informations forums :
    Inscription : Mai 2002
    Messages : 22 008
    Billets dans le blog
    6
    Par défaut
    Avec vos caractéristiques techniques vous êtes en dessous des minima hardware nécessaire. Utilisez plutôt SQL Server CE !

    A +
    Frédéric Brouard - SQLpro - ARCHITECTE DE DONNÉES - expert SGBDR et langage SQL
    Le site sur les SGBD relationnels et le langage SQL: http://sqlpro.developpez.com/
    Blog SQL, SQL Server, SGBDR : http://blog.developpez.com/sqlpro
    Expert Microsoft SQL Server - M.V.P. (Most valuable Professional) MS Corp.
    Entreprise SQL SPOT : modélisation, conseils, audit, optimisation, formation...
    * * * * * Expertise SQL Server : http://mssqlserver.fr/ * * * * *

+ Répondre à la discussion
Cette discussion est résolue.

Discussions similaires

  1. sql server express 2005
    Par rahaouin dans le forum MS SQL Server
    Réponses: 3
    Dernier message: 24/03/2006, 12h42
  2. Sql Server Express 2005
    Par rahaouin dans le forum MS SQL Server
    Réponses: 3
    Dernier message: 22/03/2006, 14h43
  3. sql server express 2005 en français
    Par gock dans le forum MS SQL Server
    Réponses: 1
    Dernier message: 24/01/2006, 16h03
  4. license sql server express 2005
    Par roninou dans le forum MS SQL Server
    Réponses: 1
    Dernier message: 24/11/2005, 16h21
  5. compatibilité Sql server express 2005 & Mondrian
    Par xikilla dans le forum MS SQL Server
    Réponses: 1
    Dernier message: 17/10/2005, 14h12

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo