数据库无法启动
日志如下:0:00000:00000:2008/07/07 10:22:32.67 kernel*** WARNING ******************
00:00000:00000:2008/07/07 10:22:32.67 kernelOperating 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 kernelSQL Server NT process id is 0x4e0.
00:00000:00000:2008/07/07 10:22:32.68 kernelSQL Server was started from a console window.
00:00000:00000:2008/07/07 10:22:32.71 kernelSSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2008/07/07 10:22:32.71 kernelNetwork and device connection limit is 99992.
00:00000:00000:2008/07/07 10:22:32.78 serverNumber of blocks left for proc headers: 3232.
00:00000:00000:2008/07/07 10:22:32.78 serverProc header memory allocated 1616 pages for each per engine cache
00:00000:00000:2008/07/07 10:22:32.87 serverMemory allocated for the default data cache cachelet 1: 122880 Kb
00:00000:00000:2008/07/07 10:22:32.89 serverSize of the 2K memory pool: 122880 Kb
00:00000:00000:2008/07/07 10:22:32.89 serverMemory allocated for the cache1 cachelet 1: 8192 Kb
00:00000:00000:2008/07/07 10:22:32.89 serverSize of the 2K memory pool: 8192 Kb
00:00000:00000:2008/07/07 10:22:32.89 kernelInitializing virtual device 0, 'c:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2008/07/07 10:22:32.89 kernelVirtual device 0 started using asynchronous i/o.
00:00000:00000:2008/07/07 10:22:32.89 kernelWorker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2008/07/07 10:22:32.89 kernelEither 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 kernelengine 0, os pid 844online
00:00000:00000:2008/07/07 10:22:32.92 serverActive traceflags: 3607
00:00000:00001:2008/07/07 10:22:32.98 kernelComponent 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 kernelComponent 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 serverOpening Master Database ...
00:00000:00001:2008/07/07 10:22:33.12 serverLoading SQL Server's default sort order and character set
00:00000:00001:2008/07/07 10:22:33.12 serverLoaded default Unilib conversion handle.
00:00000:00001:2008/07/07 10:22:33.14 serverWARNING: ***************************
00:00000:00001:2008/07/07 10:22:33.14 serverBooting without recovery
00:00000:00001:2008/07/07 10:22:33.14 serverWARNING: ***************************
00:00000:00001:2008/07/07 10:22:33.14 serverWarning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2008/07/07 10:22:33.14 serverSQL Server's default unicode sort order is 'binary'.
00:00000:00001:2008/07/07 10:22:33.14 serverSQL 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 serveron 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 serverMaster device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00002:2008/07/07 10:22:33.75 kernelnetwork name 192.168.170.10, type ether, port 5000, filter NONE
00:00000:00009:2008/07/07 10:22:33.87 serverError: 7214, Severity: 11, State: 1
00:00000:00009:2008/07/07 10:22:33.87 serverNo site name received in server login packet.Server login rejected.
00:00000:00008:2008/07/07 10:22:33.87 serverError: 7221, Severity: 14, State: 1
00:00000:00008:2008/07/07 10:22:33.87 serverLogin to site 'YOUZHENG_XP' failed.
00:00000:00000:2008/07/07 10:23:14.26 kernelkisignal: SQL Server terminated by window closure.
00:00000:00000:2008/07/07 10:23:14.26 kernelueshutdown: exiting
00:00000:00000:2008/07/07 10:23:14.26 kernelshutdown waiting for engine pid 844 to exit...
00:00000:00000:2008/07/07 10:23:14.28 kernelengine pid 844 exit completed
00:00000:00000:2008/07/07 10:23:14.28 kernelAbnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
在启动文件内加T3607也还是不行!
从这个日志来看,好像是相关的设备或文件找不到,实际情况我全部做了检查,没有问题的,那位高手指点一下! 能具体说一下吗? “Login to site 'YOUZHENG_XP' failed.”
看看XP服务配置的是否正确。
回复 #1 WFCJZ 的帖子
看看你的 ini/sql.ini文件，对不对，估计问题出在这里 改过系统用户口令吧? 不够详细，这个启动算是正常的
页:
[1]