Discussion :

[ymegri]

Bonjour tout le meonde,
j ai installe sybase 11.5 dans mon poste avec win 7
le probleme c est que lorsque j essaie de demarrer le service sybase SQLSERVER_NomServer je recois le messqge erreur 1067 : le service s est arrete inopinement ....

Est ce que vous avez une idee pour resoudre ce probleme?

Merci

Nb/ j ai verifie les valeurs des cles dans la base de registre et dans le fichier sql.ini et j ai pas trouve d erreur

[ymegri]

j'ai lance cette commande (celle du process) dans l invite de commande (c:\Sybase\bin\sqlsrvr.exe -sFORMATION -C)

et voila ce que donne comme résultat

C:\c:\Sybase\bin\sqlsrvr.exe -sFORMATION -C

00:00000:00000:2010/10/03 14:16:48.67 kernel NT operating system error 1063 in
module 'e:/main/porttree/sql/nt386/source/demo/scm_nt.c' at line 290: Le process
us de service nÆa pas pu se connecter au contr¶leur de service.
.
00:00000:00000:2010/10/03 14:16:48.67 server Attempt to dispatch SQL Server by
Service Control Manager failed.

[kagemaru]

bonjour

est-ce que tu as essayé de lancer le SQL Server manuellement ?

Code :

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

1
2
3
cd %SYBASE%/%SYBASE_ASE%/install
 
startsrv.exe -f RUN_FORMATION.bat

merci

[ymegri]

Salut merci pour votre reponse.

oui j ai essaye de le lance manuellemet, mais je suis dans un environnemet Windows , il me donne l erreur ci-dessus

[kagemaru]

oui j'avais bien compris. En fait je te demande de lancer le processus en mode attaché à une fenêtre et pas en service.

La commande que tu utilises appelle le lanceur de service tout simplement.

Par ailleurs, quel est le contenu du fichier ERRORLOG ? Je pense que la réponse se trouve dedans.

L'erreur renvoyée par Windows est générique donc difficile de trouver qqch sans se référer au log du dataserver.

[ymegri]

oui mon ami

en fait je peux demarrer l ASE a travers la ligne de commande en utilisant sqlsrvr.exe -sFORMATION ou tout simplement le fichier RUN_FORMATION, et je peux me connecter par sql advantage et lancer des requetes, maais je peux pas avoir l AS demarre dans sybase central

et lorsque j ajoute le parametre -C j obtiens le meme probleme, en fait ce parametre est utilise par le process, j arrive pas a trouver l origine de ce probleme

[ymegri]

voici la log

00:00000:00000:2010/10/05 23:40:53.63 kernel Using config area from primary master device.
00:00000:00000:2010/10/05 23:40:53.63 kernel Configuration Error: Configuration file, 'c:\sybase\FORMATION.cfg', does not exist.
00:00000:00000:2010/10/05 23:40:53.63 kernel Warning: A configuration file was not specified and the default file 'c:\sybase\FORMATION.cfg' does not exist. SQL Server creates the default file with the default configuration.
00:00000:00000:2010/10/05 23:40:53.65 kernel Kernel memory at 0x20000000, 178176 bytes
00:00000:00000:2010/10/05 23:40:53.65 kernel Server part of first shared memory region at 0x2002b800, 17213671 bytes
00:00000:00000:2010/10/05 23:40:53.68 kernel Failed to log the current message in the Windows NT event log
00:00000:00000:2010/10/05 23:40:53.68 kernel Highest valid address is 0x2002b800
00:00000:00000:2010/10/05 23:40:53.68 kernel Using 12288 file descriptors.
00:00000:00000:2010/10/05 23:40:53.68 kernel Adaptive Server Enterprise/11.5.1/P/NT/OS 4.00/1/fbu/Fri Mar 6 22:18:47 PST 1998
00:00000:00000:2010/10/05 23:40:53.68 kernel (c) Copyright 1987, 1998.
00:00000:00000:2010/10/05 23:40:53.68 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2010/10/05 23:40:53.68 kernel
00:00000:00000:2010/10/05 23:40:53.68 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2010/10/05 23:40:53.68 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2010/10/05 23:40:53.68 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2010/10/05 23:40:53.68 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2010/10/05 23:40:53.68 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2010/10/05 23:40:53.68 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2010/10/05 23:40:53.68 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2010/10/05 23:40:53.68 kernel
00:00000:00000:2010/10/05 23:40:53.68 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
00:00000:00000:2010/10/05 23:40:53.68 kernel Using 'c:\sybase\FORMATION.cfg' for configuration information.
00:00000:00000:2010/10/05 23:40:53.68 kernel Logging SQL Server messages in file 'c:\sybase\install\errorlog'
.
00:00000:00000:2010/10/05 23:40:53.70 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/10/05 23:40:53.70 kernel SQL Server NT process id is 0xa6c.
00:00000:00000:2010/10/05 23:40:53.70 kernel SQL Server was started as a Service.
00:00000:00000:2010/10/05 23:40:53.70 kernel Network and device connection limit is 12280.
00:00000:00000:2010/10/05 23:40:53.71 server Number of proc buffers allocated: 1169.
00:00000:00000:2010/10/05 23:40:53.71 server Number of blocks left for proc headers: 1215.
00:00000:00000:2010/10/05 23:40:53.71 server Memory allocated for the default data cache cache: 8868 Kb
00:00000:00000:2010/10/05 23:40:53.71 server Size of the 2K memory pool: 8868 Kb
00:00000:00000:2010/10/05 23:40:53.71 kernel Initializing virtual device 0, 'c:\sybase\DATA\MASTER.DAT'
00:00000:00000:2010/10/05 23:40:53.71 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/10/05 23:40:53.71 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/10/05 23:40:53.71 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2010/10/05 23:40:54.04 kernel engine 0, os pid 324 online
00:00000:00000:2010/10/05 23:40:54.04 server No active traceflags
00:00000:00001:2010/10/05 23:40:54.04 server Opening Master Database ...
00:00000:00001:2010/10/05 23:40:54.09 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/10/05 23:40:54.10 server Recovering database 'master'
00:00000:00001:2010/10/05 23:40:54.12 server Recovery dbid 1 ckpt (1533,25)
00:00000:00001:2010/10/05 23:40:54.12 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/05 23:40:54.12 server 1 transactions rolled forward.
00:00000:00001:2010/10/05 23:40:54.13 server Database 'master' is now online.
00:00000:00001:2010/10/05 23:40:54.13 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:40:54.13 server 0 dump conditions detected at boot time
00:00000:00001:2010/10/05 23:40:54.15 server server is unnamed
00:00000:00001:2010/10/05 23:40:54.15 server Warning: The 'sysconfigures' table is not updated since the SQL Server is started with the default configuration.
00:00000:00001:2010/10/05 23:40:54.17 server Recovering database 'model'.
00:00000:00001:2010/10/05 23:40:54.17 server Recovery dbid 3 ckpt (438,22)
00:00000:00001:2010/10/05 23:40:54.17 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/05 23:40:54.20 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:40:54.20 server Database 'model' is now online.
00:00000:00001:2010/10/05 23:40:54.20 server Clearing temp db
00:00000:00001:2010/10/05 23:40:54.27 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:40:54.29 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:40:54.29 server Database 'tempdb' is now online.
00:00000:00001:2010/10/05 23:40:54.29 server Recovery complete.
00:00000:00001:2010/10/05 23:40:54.29 server SQL Server's default sort order is:
00:00000:00001:2010/10/05 23:40:54.29 server 'bin_cp850' (ID = 50)
00:00000:00001:2010/10/05 23:40:54.29 server on top of default character set:
00:00000:00001:2010/10/05 23:40:54.29 server 'cp850' (ID = 2).
00:00000:00001:2010/10/05 23:40:54.29 server Loaded default Unilib conversion handle.
00:00000:00001:2010/10/05 23:41:23.70 kernel Initializing virtual device 1, 'c:\sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2010/10/05 23:41:23.70 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00008:2010/10/05 23:41:25.58 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.001'.
00:00000:00008:2010/10/05 23:41:25.60 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00008:2010/10/05 23:41:43.73 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.002'.
00:00000:00008:2010/10/05 23:41:43.73 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00008:2010/10/05 23:41:43.87 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.003'.
00:00000:00008:2010/10/05 23:41:43.87 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00008:2010/10/05 23:41:43.91 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.004'.
00:00000:00008:2010/10/05 23:41:43.91 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2010/10/05 23:41:43.98 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.005'.
00:00000:00001:2010/10/05 23:41:43.98 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2010/10/05 23:41:44.02 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.006'.
00:00000:00001:2010/10/05 23:41:44.02 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00008:2010/10/05 23:41:44.12 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.007'.
00:00000:00008:2010/10/05 23:41:44.12 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00008:2010/10/05 23:41:44.16 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.008'.
00:00000:00008:2010/10/05 23:41:44.16 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00008:2010/10/05 23:41:44.91 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.009'.
00:00000:00008:2010/10/05 23:41:44.91 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00008:2010/10/05 23:41:44.96 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.010'.
00:00000:00008:2010/10/05 23:41:44.96 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00001:2010/10/05 23:41:45.01 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.011'.
00:00000:00001:2010/10/05 23:41:45.01 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2010/10/05 23:41:45.04 server Configuration file 'c:\sybase\FORMATION.cfg' has been written and the previous version has been renamed to 'c:\sybase/FORMATION.012'.
00:00000:00001:2010/10/05 23:41:45.04 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '0'.
00:00000:00008:2010/10/05 23:41:45.15 server SQL Server shutdown by request.
00:00000:00008:2010/10/05 23:41:45.15 kernel ueshutdown: exiting
00:00000:00008:2010/10/05 23:41:45.15 kernel XP Server is not running.
00:00000:00000:2010/10/05 23:51:09.67 kernel Using config area from primary master device.
00:00000:00000:2010/10/05 23:51:09.74 kernel Warning: Using default file 'c:\sybase\FORMATION.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/10/05 23:51:09.75 kernel Kernel memory at 0x20000000, 178176 bytes
00:00000:00000:2010/10/05 23:51:09.75 kernel Server part of first shared memory region at 0x2002b800, 17213671 bytes
00:00000:00000:2010/10/05 23:51:09.77 kernel Failed to log the current message in the Windows NT event log
00:00000:00000:2010/10/05 23:51:09.77 kernel Highest valid address is 0x2002b800
00:00000:00000:2010/10/05 23:51:09.78 kernel Using 12288 file descriptors.
00:00000:00000:2010/10/05 23:51:09.78 kernel Adaptive Server Enterprise/11.5.1/P/NT/OS 4.00/1/fbu/Fri Mar 6 22:18:47 PST 1998
00:00000:00000:2010/10/05 23:51:09.78 kernel (c) Copyright 1987, 1998.
00:00000:00000:2010/10/05 23:51:09.78 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2010/10/05 23:51:09.78 kernel
00:00000:00000:2010/10/05 23:51:09.78 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2010/10/05 23:51:09.80 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2010/10/05 23:51:09.80 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2010/10/05 23:51:09.80 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2010/10/05 23:51:09.80 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2010/10/05 23:51:09.80 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2010/10/05 23:51:09.80 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2010/10/05 23:51:09.81 kernel
00:00000:00000:2010/10/05 23:51:09.81 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
00:00000:00000:2010/10/05 23:51:09.81 kernel Using 'c:\sybase\FORMATION.cfg' for configuration information.
00:00000:00000:2010/10/05 23:51:09.81 kernel Logging SQL Server messages in file 'c:\sybase\install\errorlog'
.
00:00000:00000:2010/10/05 23:51:09.85 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/10/05 23:51:09.85 kernel SQL Server NT process id is 0xea8.
00:00000:00000:2010/10/05 23:51:09.85 kernel SQL Server was started from a console window.
00:00000:00000:2010/10/05 23:51:09.85 kernel Network and device connection limit is 12280.
00:00000:00000:2010/10/05 23:51:09.85 server Number of proc buffers allocated: 1169.
00:00000:00000:2010/10/05 23:51:09.88 server Number of blocks left for proc headers: 1215.
00:00000:00000:2010/10/05 23:51:09.88 server Memory allocated for the default data cache cache: 8868 Kb
00:00000:00000:2010/10/05 23:51:09.88 server Size of the 2K memory pool: 8868 Kb
00:00000:00000:2010/10/05 23:51:09.88 kernel Initializing virtual device 0, 'c:\sybase\DATA\MASTER.DAT'
00:00000:00000:2010/10/05 23:51:09.89 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/10/05 23:51:09.89 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/10/05 23:51:09.89 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2010/10/05 23:51:09.89 kernel SYSTEM\CurrentControlSet\Services\SYBSQL_FORMATION Service Key in NT Registry does not exist.
00:00000:00000:2010/10/05 23:51:09.89 kernel engine 0, os pid 156 online
00:00000:00000:2010/10/05 23:51:09.89 server No active traceflags
00:00000:00001:2010/10/05 23:51:09.91 server Opening Master Database ...
00:00000:00001:2010/10/05 23:51:09.99 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/10/05 23:51:10.05 server Recovering database 'master'
00:00000:00001:2010/10/05 23:51:10.13 server Recovery dbid 1 ckpt (2312,30)
00:00000:00001:2010/10/05 23:51:10.13 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/05 23:51:10.24 server Database 'master' is now online.
00:00000:00001:2010/10/05 23:51:10.24 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:51:10.24 server 0 dump conditions detected at boot time
00:00000:00001:2010/10/05 23:51:10.25 server server is unnamed
00:00000:00001:2010/10/05 23:51:10.25 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/10/05 23:51:10.25 kernel Initializing virtual device 1, 'c:\sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2010/10/05 23:51:10.25 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/10/05 23:51:10.33 server Recovering database 'model'.
00:00000:00001:2010/10/05 23:51:10.34 server Recovery dbid 3 ckpt (448,8)
00:00000:00001:2010/10/05 23:51:10.34 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/05 23:51:10.38 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:51:10.39 server Database 'model' is now online.
00:00000:00001:2010/10/05 23:51:10.39 server Clearing temp db
00:00000:00001:2010/10/05 23:51:10.47 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:51:10.48 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:51:10.48 server Database 'tempdb' is now online.
00:00000:00001:2010/10/05 23:51:10.52 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/10/05 23:51:10.53 server Recovery dbid 4 ckpt (13372,24)
00:00000:00001:2010/10/05 23:51:10.53 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/05 23:51:11.16 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/10/05 23:51:11.16 server Database 'sybsystemprocs' is now online.
00:00000:00001:2010/10/05 23:51:11.16 server Recovery complete.
00:00000:00001:2010/10/05 23:51:11.16 server SQL Server's default sort order is:
00:00000:00001:2010/10/05 23:51:11.16 server 'bin_cp850' (ID = 50)
00:00000:00001:2010/10/05 23:51:11.16 server on top of default character set:
00:00000:00001:2010/10/05 23:51:11.17 server 'cp850' (ID = 2).
00:00000:00001:2010/10/05 23:51:11.17 server Loaded default Unilib conversion handle.
00:00000:00000:2010/10/06 00:02:57.28 kernel basis_dlock: file 'c:\sybase\DATA\MASTER.DAT' already in use by a SQL Server
00:00000:00000:2010/10/06 00:02:57.28 kernel kdconfig: unable to read primary master device
00:00000:00000:2010/10/06 00:02:57.28 kernel kiconfig: read of config block failed
00:00000:00000:2010/10/06 00:03:24.34 kernel kisignal: SQL Server terminated by window closure.
00:00000:00000:2010/10/06 00:03:24.37 kernel ueshutdown: exiting
00:00000:00000:2010/10/06 00:03:24.37 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2010/10/06 00:03:28.15 kernel Using config area from primary master device.
00:00000:00000:2010/10/06 00:03:28.15 kernel Warning: Using default file 'c:\sybase\FORMATION.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/10/06 00:03:28.18 kernel Kernel memory at 0x20000000, 178176 bytes
00:00000:00000:2010/10/06 00:03:28.18 kernel Server part of first shared memory region at 0x2002b800, 17213689 bytes
00:00000:00000:2010/10/06 00:03:28.18 kernel Failed to log the current message in the Windows NT event log
00:00000:00000:2010/10/06 00:03:28.18 kernel Highest valid address is 0x2002b800
00:00000:00000:2010/10/06 00:03:28.20 kernel Using 12288 file descriptors.
00:00000:00000:2010/10/06 00:03:28.20 kernel Adaptive Server Enterprise/11.5.1/P/NT/OS 4.00/1/fbu/Fri Mar 6 22:18:47 PST 1998
00:00000:00000:2010/10/06 00:03:28.20 kernel (c) Copyright 1987, 1998.
00:00000:00000:2010/10/06 00:03:28.20 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2010/10/06 00:03:28.20 kernel
00:00000:00000:2010/10/06 00:03:28.20 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2010/10/06 00:03:28.20 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2010/10/06 00:03:28.20 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2010/10/06 00:03:28.20 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2010/10/06 00:03:28.21 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2010/10/06 00:03:28.21 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2010/10/06 00:03:28.21 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2010/10/06 00:03:28.21 kernel
00:00000:00000:2010/10/06 00:03:28.21 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
00:00000:00000:2010/10/06 00:03:28.21 kernel Using 'c:\sybase\FORMATION.cfg' for configuration information.
00:00000:00000:2010/10/06 00:03:28.21 kernel Logging SQL Server messages in file 'c:\sybase\install\errorlog'
.
00:00000:00000:2010/10/06 00:03:28.24 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/10/06 00:03:28.24 kernel SQL Server NT process id is 0xc0c.
00:00000:00000:2010/10/06 00:03:28.24 kernel SQL Server was started from a console window.
00:00000:00000:2010/10/06 00:03:28.24 kernel Network and device connection limit is 12280.
00:00000:00000:2010/10/06 00:03:28.24 server Number of proc buffers allocated: 1169.
00:00000:00000:2010/10/06 00:03:28.24 server Number of blocks left for proc headers: 1215.
00:00000:00000:2010/10/06 00:03:28.26 server Memory allocated for the default data cache cache: 8868 Kb
00:00000:00000:2010/10/06 00:03:28.26 server Size of the 2K memory pool: 8868 Kb
00:00000:00000:2010/10/06 00:03:28.26 kernel Initializing virtual device 0, 'c:\sybase\DATA\MASTER.DAT'
00:00000:00000:2010/10/06 00:03:28.26 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/10/06 00:03:28.26 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/10/06 00:03:28.26 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2010/10/06 00:03:28.27 kernel SYSTEM\CurrentControlSet\Services\SYBSQL_FORMATION Service Key in NT Registry does not exist.
00:00000:00000:2010/10/06 00:03:28.27 kernel engine 0, os pid 176 online
00:00000:00000:2010/10/06 00:03:28.27 server No active traceflags
00:00000:00001:2010/10/06 00:03:28.27 server Opening Master Database ...
00:00000:00001:2010/10/06 00:03:28.31 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/10/06 00:03:28.32 server Recovering database 'master'
00:00000:00001:2010/10/06 00:03:28.34 server Recovery dbid 1 ckpt (2312,30)
00:00000:00001:2010/10/06 00:03:28.34 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:03:28.35 server 1 transactions rolled forward.
00:00000:00001:2010/10/06 00:03:28.38 server Database 'master' is now online.
00:00000:00001:2010/10/06 00:03:28.38 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:03:28.40 server 0 dump conditions detected at boot time
00:00000:00001:2010/10/06 00:03:28.40 server server is unnamed
00:00000:00001:2010/10/06 00:03:28.40 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/10/06 00:03:28.40 kernel Initializing virtual device 1, 'c:\sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2010/10/06 00:03:28.40 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/10/06 00:03:28.43 server Recovering database 'model'.
00:00000:00001:2010/10/06 00:03:28.45 server Recovery dbid 3 ckpt (448,8)
00:00000:00001:2010/10/06 00:03:28.45 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:03:28.48 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:03:28.48 server Database 'model' is now online.
00:00000:00001:2010/10/06 00:03:28.48 server Clearing temp db
00:00000:00001:2010/10/06 00:03:28.55 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:03:28.57 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:03:28.57 server Database 'tempdb' is now online.
00:00000:00001:2010/10/06 00:03:28.60 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/10/06 00:03:28.62 server Recovery dbid 4 ckpt (13372,24)
00:00000:00001:2010/10/06 00:03:28.62 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:03:29.24 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:03:29.24 server Database 'sybsystemprocs' is now online.
00:00000:00001:2010/10/06 00:03:29.24 server Recovery complete.
00:00000:00001:2010/10/06 00:03:29.24 server SQL Server's default sort order is:
00:00000:00001:2010/10/06 00:03:29.24 server 'bin_cp850' (ID = 50)
00:00000:00001:2010/10/06 00:03:29.26 server on top of default character set:
00:00000:00001:2010/10/06 00:03:29.26 server 'cp850' (ID = 2).
00:00000:00001:2010/10/06 00:03:29.26 server Loaded default Unilib conversion handle.
00:00000:00000:2010/10/06 00:04:31.00 kernel kisignal: SQL Server terminated by window closure.
00:00000:00000:2010/10/06 00:04:31.00 kernel ueshutdown: exiting
00:00000:00000:2010/10/06 00:04:31.02 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2010/10/06 00:06:49.77 kernel Using config area from primary master device.
00:00000:00000:2010/10/06 00:06:49.77 kernel Warning: Using default file 'c:\sybase\FORMATION.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/10/06 00:06:49.80 kernel Kernel memory at 0x20000000, 178176 bytes
00:00000:00000:2010/10/06 00:06:49.80 kernel Server part of first shared memory region at 0x2002b800, 17213689 bytes
00:00000:00000:2010/10/06 00:06:49.80 kernel Failed to log the current message in the Windows NT event log
00:00000:00000:2010/10/06 00:06:49.80 kernel Highest valid address is 0x2002b800
00:00000:00000:2010/10/06 00:06:49.80 kernel Using 12288 file descriptors.
00:00000:00000:2010/10/06 00:06:49.80 kernel Adaptive Server Enterprise/11.5.1/P/NT/OS 4.00/1/fbu/Fri Mar 6 22:18:47 PST 1998
00:00000:00000:2010/10/06 00:06:49.80 kernel (c) Copyright 1987, 1998.
00:00000:00000:2010/10/06 00:06:49.80 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2010/10/06 00:06:49.82 kernel
00:00000:00000:2010/10/06 00:06:49.82 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2010/10/06 00:06:49.82 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2010/10/06 00:06:49.82 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2010/10/06 00:06:49.82 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2010/10/06 00:06:49.82 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2010/10/06 00:06:49.82 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2010/10/06 00:06:49.82 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2010/10/06 00:06:49.82 kernel
00:00000:00000:2010/10/06 00:06:49.82 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
00:00000:00000:2010/10/06 00:06:49.83 kernel Using 'c:\sybase\FORMATION.cfg' for configuration information.
00:00000:00000:2010/10/06 00:06:49.83 kernel Logging SQL Server messages in file 'c:\sybase\install\errorlog'
.
00:00000:00000:2010/10/06 00:06:49.85 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/10/06 00:06:49.85 kernel SQL Server NT process id is 0x9e8.
00:00000:00000:2010/10/06 00:06:49.85 kernel SQL Server was started from a console window.
00:00000:00000:2010/10/06 00:06:49.85 kernel Network and device connection limit is 12280.
00:00000:00000:2010/10/06 00:06:49.86 server Number of proc buffers allocated: 1169.
00:00000:00000:2010/10/06 00:06:49.86 server Number of blocks left for proc headers: 1215.
00:00000:00000:2010/10/06 00:06:49.86 server Memory allocated for the default data cache cache: 8868 Kb
00:00000:00000:2010/10/06 00:06:49.86 server Size of the 2K memory pool: 8868 Kb
00:00000:00000:2010/10/06 00:06:49.86 kernel Initializing virtual device 0, 'c:\sybase\DATA\MASTER.DAT'
00:00000:00000:2010/10/06 00:06:49.86 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/10/06 00:06:49.88 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/10/06 00:06:49.88 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2010/10/06 00:06:49.88 kernel SYSTEM\CurrentControlSet\Services\SYBSQL_FORMATION Service Key in NT Registry does not exist.
00:00000:00000:2010/10/06 00:06:49.88 kernel engine 0, os pid 176 online
00:00000:00000:2010/10/06 00:06:49.88 server No active traceflags
00:00000:00001:2010/10/06 00:06:49.88 server Opening Master Database ...
00:00000:00001:2010/10/06 00:06:49.90 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/10/06 00:06:49.91 server Recovering database 'master'
00:00000:00001:2010/10/06 00:06:49.93 server Recovery dbid 1 ckpt (2314,13)
00:00000:00001:2010/10/06 00:06:49.93 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:06:49.93 server 1 transactions rolled forward.
00:00000:00001:2010/10/06 00:06:49.99 server Database 'master' is now online.
00:00000:00001:2010/10/06 00:06:49.99 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:06:49.99 server 0 dump conditions detected at boot time
00:00000:00001:2010/10/06 00:06:49.99 server server is unnamed
00:00000:00001:2010/10/06 00:06:49.99 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/10/06 00:06:49.99 kernel Initializing virtual device 1, 'c:\sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2010/10/06 00:06:49.99 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/10/06 00:06:50.02 server Recovering database 'model'.
00:00000:00001:2010/10/06 00:06:50.04 server Recovery dbid 3 ckpt (448,8)
00:00000:00001:2010/10/06 00:06:50.04 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:06:50.07 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:06:50.07 server Database 'model' is now online.
00:00000:00001:2010/10/06 00:06:50.07 server Clearing temp db
00:00000:00001:2010/10/06 00:06:50.16 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:06:50.16 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:06:50.16 server Database 'tempdb' is now online.
00:00000:00001:2010/10/06 00:06:50.19 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/10/06 00:06:50.21 server Recovery dbid 4 ckpt (13372,24)
00:00000:00001:2010/10/06 00:06:50.21 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:06:50.83 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:06:50.83 server Database 'sybsystemprocs' is now online.
00:00000:00001:2010/10/06 00:06:50.83 server Recovery complete.
00:00000:00001:2010/10/06 00:06:50.83 server SQL Server's default sort order is:
00:00000:00001:2010/10/06 00:06:50.83 server 'bin_cp850' (ID = 50)
00:00000:00001:2010/10/06 00:06:50.83 server on top of default character set:
00:00000:00001:2010/10/06 00:06:50.83 server 'cp850' (ID = 2).
00:00000:00001:2010/10/06 00:06:50.85 server Loaded default Unilib conversion handle.
00:00000:00000:2010/10/06 00:07:01.64 kernel kisignal: SQL Server terminated by window closure.
00:00000:00000:2010/10/06 00:07:01.64 kernel ueshutdown: exiting
00:00000:00000:2010/10/06 00:07:01.64 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2010/10/06 00:08:28.99 kernel Using config area from primary master device.
00:00000:00000:2010/10/06 00:08:28.99 kernel Warning: Using default file 'c:\sybase\FORMATION.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/10/06 00:08:29.00 kernel Kernel memory at 0x20000000, 178176 bytes
00:00000:00000:2010/10/06 00:08:29.00 kernel Server part of first shared memory region at 0x2002b800, 17213671 bytes
00:00000:00000:2010/10/06 00:08:29.00 kernel Failed to log the current message in the Windows NT event log
00:00000:00000:2010/10/06 00:08:29.00 kernel Highest valid address is 0x2002b800
00:00000:00000:2010/10/06 00:08:29.00 kernel Using 12288 file descriptors.
00:00000:00000:2010/10/06 00:08:29.00 kernel Adaptive Server Enterprise/11.5.1/P/NT/OS 4.00/1/fbu/Fri Mar 6 22:18:47 PST 1998
00:00000:00000:2010/10/06 00:08:29.00 kernel (c) Copyright 1987, 1998.
00:00000:00000:2010/10/06 00:08:29.00 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2010/10/06 00:08:29.00 kernel
00:00000:00000:2010/10/06 00:08:29.00 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2010/10/06 00:08:29.00 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2010/10/06 00:08:29.00 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2010/10/06 00:08:29.00 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2010/10/06 00:08:29.00 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2010/10/06 00:08:29.00 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2010/10/06 00:08:29.00 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2010/10/06 00:08:29.00 kernel
00:00000:00000:2010/10/06 00:08:29.00 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
00:00000:00000:2010/10/06 00:08:29.02 kernel Using 'c:\sybase\FORMATION.cfg' for configuration information.
00:00000:00000:2010/10/06 00:08:29.02 kernel Logging SQL Server messages in file 'c:\sybase\install\errorlog'
.
00:00000:00000:2010/10/06 00:08:29.03 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/10/06 00:08:29.03 kernel SQL Server NT process id is 0x530.
00:00000:00000:2010/10/06 00:08:29.05 kernel SQL Server was started from a console window.
00:00000:00000:2010/10/06 00:08:29.05 kernel Network and device connection limit is 12280.
00:00000:00000:2010/10/06 00:08:29.05 server Number of proc buffers allocated: 1169.
00:00000:00000:2010/10/06 00:08:29.05 server Number of blocks left for proc headers: 1215.
00:00000:00000:2010/10/06 00:08:29.05 server Memory allocated for the default data cache cache: 8868 Kb
00:00000:00000:2010/10/06 00:08:29.05 server Size of the 2K memory pool: 8868 Kb
00:00000:00000:2010/10/06 00:08:29.07 kernel Initializing virtual device 0, 'c:\sybase\DATA\MASTER.DAT'
00:00000:00000:2010/10/06 00:08:29.07 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/10/06 00:08:29.07 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/10/06 00:08:29.07 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2010/10/06 00:08:29.07 kernel engine 0, os pid 360 online
00:00000:00000:2010/10/06 00:08:29.07 server No active traceflags
00:00000:00001:2010/10/06 00:08:29.07 server Opening Master Database ...
00:00000:00001:2010/10/06 00:08:29.08 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/10/06 00:08:29.10 server Recovering database 'master'
00:00000:00001:2010/10/06 00:08:29.11 server Recovery dbid 1 ckpt (2314,24)
00:00000:00001:2010/10/06 00:08:29.11 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:08:29.11 server 1 transactions rolled forward.
00:00000:00001:2010/10/06 00:08:29.16 server Database 'master' is now online.
00:00000:00001:2010/10/06 00:08:29.16 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:08:29.16 server 0 dump conditions detected at boot time
00:00000:00001:2010/10/06 00:08:29.16 server server is unnamed
00:00000:00001:2010/10/06 00:08:29.16 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/10/06 00:08:29.16 kernel Initializing virtual device 1, 'c:\sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2010/10/06 00:08:29.17 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/10/06 00:08:29.21 server Recovering database 'model'.
00:00000:00001:2010/10/06 00:08:29.21 server Recovery dbid 3 ckpt (448,8)
00:00000:00001:2010/10/06 00:08:29.21 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:08:29.24 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:08:29.25 server Database 'model' is now online.
00:00000:00001:2010/10/06 00:08:29.25 server Clearing temp db
00:00000:00001:2010/10/06 00:08:29.52 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:08:29.52 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:08:29.53 server Database 'tempdb' is now online.
00:00000:00001:2010/10/06 00:08:29.55 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/10/06 00:08:29.56 server Recovery dbid 4 ckpt (13372,24)
00:00000:00001:2010/10/06 00:08:29.56 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:08:30.19 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:08:30.19 server Database 'sybsystemprocs' is now online.
00:00000:00001:2010/10/06 00:08:30.19 server Recovery complete.
00:00000:00001:2010/10/06 00:08:30.19 server SQL Server's default sort order is:
00:00000:00001:2010/10/06 00:08:30.19 server 'bin_cp850' (ID = 50)
00:00000:00001:2010/10/06 00:08:30.20 server on top of default character set:
00:00000:00001:2010/10/06 00:08:30.20 server 'cp850' (ID = 2).
00:00000:00001:2010/10/06 00:08:30.20 server Loaded default Unilib conversion handle.
00:00000:00000:2010/10/06 00:08:33.40 kernel kisignal: SQL Server terminated by window closure.
00:00000:00000:2010/10/06 00:08:33.40 kernel ueshutdown: exiting
00:00000:00000:2010/10/06 00:08:33.40 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2010/10/06 00:14:20.80 kernel Using config area from primary master device.
00:00000:00000:2010/10/06 00:14:20.80 kernel Warning: Using default file 'c:\sybase\FORMATION.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/10/06 00:14:20.83 kernel Kernel memory at 0x20000000, 178176 bytes
00:00000:00000:2010/10/06 00:14:20.83 kernel Server part of first shared memory region at 0x2002b800, 17213671 bytes
00:00000:00000:2010/10/06 00:14:20.83 kernel Failed to log the current message in the Windows NT event log
00:00000:00000:2010/10/06 00:14:20.83 kernel Highest valid address is 0x2002b800
00:00000:00000:2010/10/06 00:14:20.83 kernel Using 12288 file descriptors.
00:00000:00000:2010/10/06 00:14:20.83 kernel Adaptive Server Enterprise/11.5.1/P/NT/OS 4.00/1/fbu/Fri Mar 6 22:18:47 PST 1998
00:00000:00000:2010/10/06 00:14:20.83 kernel (c) Copyright 1987, 1998.
00:00000:00000:2010/10/06 00:14:20.83 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2010/10/06 00:14:20.84 kernel
00:00000:00000:2010/10/06 00:14:20.84 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2010/10/06 00:14:20.84 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2010/10/06 00:14:20.84 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2010/10/06 00:14:20.84 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2010/10/06 00:14:20.84 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2010/10/06 00:14:20.84 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2010/10/06 00:14:20.84 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2010/10/06 00:14:20.84 kernel
00:00000:00000:2010/10/06 00:14:20.84 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
00:00000:00000:2010/10/06 00:14:20.84 kernel Using 'c:\sybase\FORMATION.cfg' for configuration information.
00:00000:00000:2010/10/06 00:14:20.84 kernel Logging SQL Server messages in file 'c:\sybase\install\errorlog'
.
00:00000:00000:2010/10/06 00:14:20.84 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/10/06 00:14:20.86 kernel SQL Server NT process id is 0x1c0.
00:00000:00000:2010/10/06 00:14:20.86 kernel SQL Server was started from a console window.
00:00000:00000:2010/10/06 00:14:20.86 kernel Network and device connection limit is 12280.
00:00000:00000:2010/10/06 00:14:20.86 server Number of proc buffers allocated: 1169.
00:00000:00000:2010/10/06 00:14:20.86 server Number of blocks left for proc headers: 1215.
00:00000:00000:2010/10/06 00:14:20.86 server Memory allocated for the default data cache cache: 8868 Kb
00:00000:00000:2010/10/06 00:14:20.86 server Size of the 2K memory pool: 8868 Kb
00:00000:00000:2010/10/06 00:14:20.86 kernel Initializing virtual device 0, 'c:\sybase\DATA\MASTER.DAT'
00:00000:00000:2010/10/06 00:14:20.86 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/10/06 00:14:20.86 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/10/06 00:14:20.86 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2010/10/06 00:14:20.86 kernel engine 0, os pid 168 online
00:00000:00000:2010/10/06 00:14:20.86 server No active traceflags
00:00000:00001:2010/10/06 00:14:20.86 server Opening Master Database ...
00:00000:00001:2010/10/06 00:14:20.87 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/10/06 00:14:20.89 server Recovering database 'master'
00:00000:00001:2010/10/06 00:14:20.91 server Recovery dbid 1 ckpt (2315,5)
00:00000:00001:2010/10/06 00:14:20.91 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:14:20.91 server 1 transactions rolled forward.
00:00000:00001:2010/10/06 00:14:20.97 server Database 'master' is now online.
00:00000:00001:2010/10/06 00:14:20.97 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:14:20.97 server 0 dump conditions detected at boot time
00:00000:00001:2010/10/06 00:14:20.97 server server is unnamed
00:00000:00001:2010/10/06 00:14:20.97 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/10/06 00:14:20.97 kernel Initializing virtual device 1, 'c:\sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2010/10/06 00:14:20.97 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/10/06 00:14:21.00 server Recovering database 'model'.
00:00000:00001:2010/10/06 00:14:21.00 server Recovery dbid 3 ckpt (448,8)
00:00000:00001:2010/10/06 00:14:21.00 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:14:21.03 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:14:21.03 server Database 'model' is now online.
00:00000:00001:2010/10/06 00:14:21.03 server Clearing temp db
00:00000:00001:2010/10/06 00:14:21.12 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:14:21.12 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:14:21.12 server Database 'tempdb' is now online.
00:00000:00001:2010/10/06 00:14:21.16 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/10/06 00:14:21.16 server Recovery dbid 4 ckpt (13372,24)
00:00000:00001:2010/10/06 00:14:21.16 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:14:21.78 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:14:21.78 server Database 'sybsystemprocs' is now online.
00:00000:00001:2010/10/06 00:14:21.78 server Recovery complete.
00:00000:00001:2010/10/06 00:14:21.78 server SQL Server's default sort order is:
00:00000:00001:2010/10/06 00:14:21.78 server 'bin_cp850' (ID = 50)
00:00000:00001:2010/10/06 00:14:21.78 server on top of default character set:
00:00000:00001:2010/10/06 00:14:21.78 server 'cp850' (ID = 2).
00:00000:00001:2010/10/06 00:14:21.78 server Loaded default Unilib conversion handle.
00:00000:00000:2010/10/06 00:15:10.91 kernel basis_dlock: file 'c:\sybase\DATA\MASTER.DAT' already in use by a SQL Server
00:00000:00000:2010/10/06 00:15:10.91 kernel kdconfig: unable to read primary master device
00:00000:00000:2010/10/06 00:15:10.91 kernel kiconfig: read of config block failed
00:00000:00000:2010/10/06 00:16:20.36 kernel basis_dlock: file 'c:\sybase\DATA\MASTER.DAT' already in use by a SQL Server
00:00000:00000:2010/10/06 00:16:20.36 kernel kdconfig: unable to read primary master device
00:00000:00000:2010/10/06 00:16:20.36 kernel kiconfig: read of config block failed
00:00000:00000:2010/10/06 00:19:34.27 kernel kisignal: SQL Server terminated by system shutdown.
00:00000:00000:2010/10/06 00:19:34.27 kernel ueshutdown: exiting
00:00000:00000:2010/10/06 00:19:34.27 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2010/10/06 00:21:46.71 kernel Using config area from primary master device.
00:00000:00000:2010/10/06 00:21:46.75 kernel Warning: Using default file 'c:\sybase\FORMATION.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/10/06 00:21:46.78 kernel Kernel memory at 0x20000000, 178176 bytes
00:00000:00000:2010/10/06 00:21:46.79 kernel Server part of first shared memory region at 0x2002b800, 17213671 bytes
00:00000:00000:2010/10/06 00:21:46.80 kernel Failed to log the current message in the Windows NT event log
00:00000:00000:2010/10/06 00:21:46.80 kernel Highest valid address is 0x2002b800
00:00000:00000:2010/10/06 00:21:46.80 kernel Using 12288 file descriptors.
00:00000:00000:2010/10/06 00:21:46.81 kernel Adaptive Server Enterprise/11.5.1/P/NT/OS 4.00/1/fbu/Fri Mar 6 22:18:47 PST 1998
00:00000:00000:2010/10/06 00:21:46.81 kernel (c) Copyright 1987, 1998.
00:00000:00000:2010/10/06 00:21:46.81 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2010/10/06 00:21:46.81 kernel
00:00000:00000:2010/10/06 00:21:46.81 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2010/10/06 00:21:46.81 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2010/10/06 00:21:46.81 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2010/10/06 00:21:46.81 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2010/10/06 00:21:46.81 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2010/10/06 00:21:46.81 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2010/10/06 00:21:46.81 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2010/10/06 00:21:46.81 kernel
00:00000:00000:2010/10/06 00:21:46.81 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
00:00000:00000:2010/10/06 00:21:46.81 kernel Using 'c:\sybase\FORMATION.cfg' for configuration information.
00:00000:00000:2010/10/06 00:21:46.81 kernel Logging SQL Server messages in file 'c:\sybase\install\errorlog'
.
00:00000:00000:2010/10/06 00:21:46.84 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2010/10/06 00:21:46.85 kernel SQL Server NT process id is 0x5f4.
00:00000:00000:2010/10/06 00:21:46.85 kernel SQL Server was started from a console window.
00:00000:00000:2010/10/06 00:21:46.85 kernel Network and device connection limit is 12280.
00:00000:00000:2010/10/06 00:21:46.85 server Number of proc buffers allocated: 1169.
00:00000:00000:2010/10/06 00:21:46.90 server Number of blocks left for proc headers: 1215.
00:00000:00000:2010/10/06 00:21:46.90 server Memory allocated for the default data cache cache: 8868 Kb
00:00000:00000:2010/10/06 00:21:46.90 server Size of the 2K memory pool: 8868 Kb
00:00000:00000:2010/10/06 00:21:46.96 kernel Initializing virtual device 0, 'c:\sybase\DATA\MASTER.DAT'
00:00000:00000:2010/10/06 00:21:46.96 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2010/10/06 00:21:46.96 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2010/10/06 00:21:46.96 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2010/10/06 00:21:47.01 kernel engine 0, os pid 168 online
00:00000:00000:2010/10/06 00:21:47.01 server No active traceflags
00:00000:00001:2010/10/06 00:21:47.16 server Opening Master Database ...
00:00000:00001:2010/10/06 00:21:47.41 server Loading SQL Server's default sort order and character set
00:00000:00001:2010/10/06 00:21:47.56 server Recovering database 'master'
00:00000:00001:2010/10/06 00:21:47.65 server Recovery dbid 1 ckpt (2315,16)
00:00000:00001:2010/10/06 00:21:47.65 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:21:47.68 server 1 transactions rolled forward.
00:00000:00001:2010/10/06 00:21:47.75 server Database 'master' is now online.
00:00000:00001:2010/10/06 00:21:47.76 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:21:47.76 server 0 dump conditions detected at boot time
00:00000:00001:2010/10/06 00:21:47.77 server server is unnamed
00:00000:00001:2010/10/06 00:21:47.77 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/10/06 00:21:47.77 kernel Initializing virtual device 1, 'c:\sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2010/10/06 00:21:47.78 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/10/06 00:21:47.84 server Recovering database 'model'.
00:00000:00001:2010/10/06 00:21:47.85 server Recovery dbid 3 ckpt (448,8)
00:00000:00001:2010/10/06 00:21:47.85 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:21:47.88 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:21:47.89 server Database 'model' is now online.
00:00000:00001:2010/10/06 00:21:47.89 server Clearing temp db
00:00000:00001:2010/10/06 00:21:47.97 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:21:47.98 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:21:47.98 server Database 'tempdb' is now online.
00:00000:00001:2010/10/06 00:21:48.01 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/10/06 00:21:48.02 server Recovery dbid 4 ckpt (13372,24)
00:00000:00001:2010/10/06 00:21:48.02 server Recovery no active transactions before ckpt.
00:00000:00001:2010/10/06 00:21:48.69 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2010/10/06 00:21:48.69 server Database 'sybsystemprocs' is now online.
00:00000:00001:2010/10/06 00:21:48.69 server Recovery complete.
00:00000:00001:2010/10/06 00:21:48.69 server SQL Server's default sort order is:
00:00000:00001:2010/10/06 00:21:48.69 server 'bin_cp850' (ID = 50)
00:00000:00001:2010/10/06 00:21:48.69 server on top of default character set:
00:00000:00001:2010/10/06 00:21:48.69 server 'cp850' (ID = 2).
00:00000:00001:2010/10/06 00:21:48.69 server Loaded default Unilib conversion handle.
00:00000:00000:2010/10/06 00:23:39.18 kernel basis_dlock: file 'c:\sybase\DATA\MASTER.DAT' already in use by a SQL Server
00:00000:00000:2010/10/06 00:23:39.18 kernel kdconfig: unable to read primary master device
00:00000:00000:2010/10/06 00:23:39.18 kernel kiconfig: read of config block failed

[kagemaru]

salut

Ok, je voulais m'assurer que l'instance roulait avec ce mode de lancement.

Est-ce que tu peux poster les détails du registre (hklm\system\currentcontrolset\services\<ton dataserver> et hklm\software\sybase\server\<ton dataserver>) ?

Avec quel compte le service démarre-t-il ?

merci

[ymegri]

salut kagemaru
desole pour ce retard
en fait j ai verifie tous les valeurs des clefs dans le registre , et il n ya pas qqe chose qui cloche
j ai installe la version 12.5 et tout marche a merveille, je meme definit les services sybase pour qu ils demarre automatiquement

ce qui me pousse reflichir , est ce que c est un probleme d incompatibilite de sybase 11 avec windows 7???!!!!!!!!!

en revanche dans la version 12.5 sybase central fonctionne et les dataservers demarrent mais j ai un probleme avec sql advantage qui ne se connecte pas meme si le serveur est demarre!!!

merci beaucoup pour votre interet

[mpeppler]

11.5 n'est évidemment pas certifié (ni testé, ni quoi que ce soit...) avec Windows 7 - donc que cela ne demarre pas n'est peut-être pas tellement étonnant :-)

Pour le reste - si on peut pas ce connecter c'est en général qu'il y a une difference entre le host/port utilisé par ASE, et celui utilisé par SQLAdvantage, isql, etc. Faudrait utiliser netstat (ou son équivalent windows) pour voir quel port/host est réellement utilisé par ASE, et s'assurer que le sql.ini correspond bien...

Michael

[kagemaru]

En fait l'instance démarre, mais je pense qu'il s'agit plus de l'interaction avec le service Windows qui pose soucis. Difficile de dire pourquoi sans plus d'info (extrait de l'observateur d'évènements et le contenu des clés de registre)