数据库无法启动

WFCJZ

日志如下:

0:00000:00000:2008/07/07 10:22:32.67 kernel  *** WARNING ******************
00:00000:00000:2008/07/07 10:22:32.67 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2008/07/07 10:22:32.68 kernel  SQL Server NT process id is 0x4e0.
00:00000:00000:2008/07/07 10:22:32.68 kernel  SQL Server was started from a console window.
00:00000:00000:2008/07/07 10:22:32.71 kernel  SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2008/07/07 10:22:32.71 kernel  Network and device connection limit is 99992.
00:00000:00000:2008/07/07 10:22:32.78 server  Number of blocks left for proc headers: 3232.
00:00000:00000:2008/07/07 10:22:32.78 server  Proc header memory allocated 1616 pages for each per engine cache
00:00000:00000:2008/07/07 10:22:32.87 server  Memory allocated for the default data cache cachelet 1: 122880 Kb
00:00000:00000:2008/07/07 10:22:32.89 server  Size of the 2K memory pool: 122880 Kb
00:00000:00000:2008/07/07 10:22:32.89 server  Memory allocated for the cache1 cachelet 1: 8192 Kb
00:00000:00000:2008/07/07 10:22:32.89 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2008/07/07 10:22:32.89 kernel  Initializing virtual device 0, 'c:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2008/07/07 10:22:32.89 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2008/07/07 10:22:32.89 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2008/07/07 10:22:32.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:2008/07/07 10:22:32.90 kernel  engine 0, os pid 844  online
00:00000:00000:2008/07/07 10:22:32.92 server  Active traceflags: 3607
00:00000:00001:2008/07/07 10:22:32.98 kernel  Component Integration Services loaded; version 'Component Integration Services/12.5.0.2/EBF 10730 IR ONE-OFF/P/NT (IX86)/OS 4.0/rel12502/1851/32-bit/OPT/Mon Nov 04 23:01:14 2002'.
00:00000:00001:2008/07/07 10:22:32.98 kernel  Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10419/PC Intel/BUILD125-015/OPT/Wed Jul 03 10:38:06 2002'
00:00000:00001:2008/07/07 10:22:32.98 server  Opening Master Database ...
00:00000:00001:2008/07/07 10:22:33.12 server  Loading SQL Server's default sort order and character set
00:00000:00001:2008/07/07 10:22:33.12 server  Loaded default Unilib conversion handle.
00:00000:00001:2008/07/07 10:22:33.14 server  WARNING: ***************************
00:00000:00001:2008/07/07 10:22:33.14 server  Booting without recovery
00:00000:00001:2008/07/07 10:22:33.14 server  WARNING: ***************************
00:00000:00001:2008/07/07 10:22:33.14 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2008/07/07 10:22:33.14 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2008/07/07 10:22:33.14 server  SQL Server's default sort order is:
00:00000:00001:2008/07/07 10:22:33.14 server          'bin_iso_1' (ID = 50)
00:00000:00001:2008/07/07 10:22:33.14 server  on top of default character set:
00:00000:00001:2008/07/07 10:22:33.14 server          'iso_1' (ID = 1).
00:00000:00001:2008/07/07 10:22:33.15 server  Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00002:2008/07/07 10:22:33.75 kernel  network name 192.168.170.10, type ether, port 5000, filter NONE
00:00000:00009:2008/07/07 10:22:33.87 server  Error: 7214, Severity: 11, State: 1
00:00000:00009:2008/07/07 10:22:33.87 server  No site name received in server login packet.  Server login rejected.
00:00000:00008:2008/07/07 10:22:33.87 server  Error: 7221, Severity: 14, State: 1
00:00000:00008:2008/07/07 10:22:33.87 server  Login to site 'YOUZHENG_XP' failed.
00:00000:00000:2008/07/07 10:23:14.26 kernel  kisignal: SQL Server terminated by window closure.
00:00000:00000:2008/07/07 10:23:14.26 kernel  ueshutdown: exiting
00:00000:00000:2008/07/07 10:23:14.26 kernel  shutdown waiting for engine pid 844 to exit...
00:00000:00000:2008/07/07 10:23:14.28 kernel  engine pid 844 exit completed
00:00000:00000:2008/07/07 10:23:14.28 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.

  在启动文件内加T3607也还是不行!
从这个日志来看,好像是相关的设备或文件找不到,实际情况我全部做了检查,没有问题的,那位高手指点一下!

WFCJZ

能具体说一下吗?

aliking

“Login to site 'YOUZHENG_XP' failed.”
看看XP服务配置的是否正确。

holy_sky

看看你的 ini/sql.ini  文件，对不对，估计问题出在这里

lqg64150

改过系统用户口令吧?

hobbylu

不够详细，这个启动算是正常的