- 论坛徽章:
- 0
|
1、默认安装SYBASE12.0 服务器端
2、使用\sybase_s\ASE-12_0\bin\syconfig.exe配置名称为IT的adaptive server
3、配置过程中network addresses 为 tcp winsock tcp/ip net-libray driver 192.168.11.11,5000
configure default XP server network addresses 为 tcp winsock tcp/ip net-libray driver 192.168.11.11,5000
然后其他的为默认
4、默认安装SYBASE12.0 客户端
5、配置dsedit 使其的配置和服务端相符
6、在win2000中的服务中设置sybase sql server为自动启动
7、重新启动计算机
sql.ini如下
[IT_BS]
$BASE$00=NLMSNMP,\pipe\sybase\backup
$BASE$01=NLWNSCK,it,5001
MASTER=$BASE$00;$BASE$01;
$BASE$02=NLMSNMP,\pipe\sybase\backup
$BASE$03=NLWNSCK,it,5001
QUERY=$BASE$02;$BASE$03;
[IT_MS]
$BASE$00=NLMSNMP,\pipe\sybase\monitor
$BASE$01=NLWNSCK,it,5002
MASTER=$BASE$00;$BASE$01;
$BASE$02=NLMSNMP,\pipe\sybase\monitor
$BASE$03=NLWNSCK,it,5002
QUERY=$BASE$02;$BASE$03;
[IT]
MASTER=NLWNSCK,it,5000
QUERY=NLWNSCK,it,5000
[IT_XP]
MASTER=NLWNSCK,it,5003
QUERY=NLWNSCK,it,5003
errorlog如下
00:00000:00000:2005/11/03 16:07:43.21 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2005/11/03 16:07:43.35 kernel Using config area from primary master device.
00:00000:00000:2005/11/03 16:07:43.39 kernel Warning: Using default file 'c:\sybase_s\IT.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2005/11/03 16:07:43.65 kernel Kernel memory at 0x20000000, 313344 bytes
00:00000:00000:2005/11/03 16:07:43.65 kernel Server part of first shared memory region at 0x2004C800, 101038080 bytes.
00:00000:00000:2005/11/03 16:07:43.67 kernel Highest valid address is 0x2004C800
00:00000:00000:2005/11/03 16:07:43.67 kernel Using 100000 file descriptors.
00:00000:00000:2005/11/03 16:07:43.67 kernel Failed to load unicode conversion DLL libntlog.dll
00:00000:00000:2005/11/03 16:07:43.67 kernel Adaptive Server Enterprise/12.0/P/NT (IX86)/OS 4.0/1576/32bit/OPT/Wed Nov 03 22:35:30 1999
00:00000:00000:2005/11/03 16:07:43.67 kernel Confidential property of Sybase, Inc.
00:00000:00000:2005/11/03 16:07:43.67 kernel Copyright 1987, 1999
00:00000:00000:2005/11/03 16:07:43.67 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2005/11/03 16:07:43.67 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/11/03 16:07:43.67 kernel
00:00000:00000:2005/11/03 16:07:43.67 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/11/03 16:07:43.67 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2005/11/03 16:07:43.67 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2005/11/03 16:07:43.67 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2005/11/03 16:07:43.68 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2005/11/03 16:07:43.71 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/11/03 16:07:43.73 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2005/11/03 16:07:43.76 kernel Using 'c:\sybase_s\IT.cfg' for configuration information.
00:00000:00000:2005/11/03 16:07:43.78 kernel Logging ASE messages in file 'c:\sybase_s\ASE-12_0\install\errorlog'.
00:00000:00000:2005/11/03 16:07:43.84 kernel Initializing MSDTC Connection
00:00000:00000:2005/11/03 16:08:01.85 kernel MSDTC Initialization succeeded
00:00000:00000:2005/11/03 16:08:06.73 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2005/11/03 16:08:06.75 kernel SQL Server NT process id is 0x62c.
00:00000:00000:2005/11/03 16:08:06.75 kernel SQL Server was started from a console window.
00:00000:00000:2005/11/03 16:08:06.75 kernel Network and device connection limit is 99992.
00:00000:00000:2005/11/03 16:08:06.79 server Number of proc buffers allocated: 8735.
00:00000:00000:2005/11/03 16:08:06.96 server Number of blocks left for proc headers: 8696.
00:00000:00000:2005/11/03 16:08:07.00 server Proc header memory allocated 4348 pages for each per engine cache
00:00000:00000:2005/11/03 16:08:07.00 server Memory allocated for the default data cache cachelet 1: 65534 Kb
00:00000:00000:2005/11/03 16:08:07.03 server Size of the 2K memory pool: 65534 Kb
00:00000:00000:2005/11/03 16:08:07.04 kernel Initializing virtual device 0, 'c:\sybase_s\data\master.dat' with dsync 'on'.
00:00000:00000:2005/11/03 16:08:07.07 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2005/11/03 16:08:07.09 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2005/11/03 16:08:07.10 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:2005/11/03 16:08:07.15 kernel engine 0, os pid 464 online
00:00000:00000:2005/11/03 16:08:07.17 server No active traceflags
00:00000:00001:2005/11/03 16:08:07.29 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/NT (IX86)/OS 4.0/1576/32bit/OPT/Wed Nov 03 21:14:59 1999'.
00:00000:00001:2005/11/03 16:08:07.32 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/PC Intel/1/OPT/Mon Oct 04 15:42:12 1999'
00:00000:00001:2005/11/03 16:08:07.34 server Opening Master Database ...
00:00000:00001:2005/11/03 16:08:07.54 server Loading SQL Server's default sort order and character set
00:00000:00001:2005/11/03 16:08:07.56 server Loaded default Unilib conversion handle.
00:00000:00002:2005/11/03 16:08:07.57 kernel network name it, type ether, port 5000
00:00000:00001:2005/11/03 16:08:07.62 server Recovering database 'master'
00:00000:00001:2005/11/03 16:08:07.82 server Checking external objects.
00:00000:00001:2005/11/03 16:08:07.92 server Database 'master' is now online.
00:00000:00001:2005/11/03 16:08:07.93 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:07.95 server 0 dump conditions detected at boot time
00:00000:00001:2005/11/03 16:08:08.01 server server is unnamed
00:00000:00001:2005/11/03 16:08:08.03 server Activating disk 'sysprocsdev'.
00:00000:00001:2005/11/03 16:08:08.03 kernel Initializing virtual device 1, 'c:\sybase_s\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2005/11/03 16:08:08.06 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2005/11/03 16:08:08.18 server Recovering database 'sybsystemdb'.
00:00000:00001:2005/11/03 16:08:08.23 server Boot Count: 5
00:00000:00001:2005/11/03 16:08:08.26 server Checking external objects.
00:00000:00001:2005/11/03 16:08:08.28 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:08.29 server Database 'sybsystemdb' is now online.
00:00000:00001:2005/11/03 16:08:08.34 server Recovering database 'model'.
00:00000:00001:2005/11/03 16:08:08.37 server Checking external objects.
00:00000:00001:2005/11/03 16:08:08.39 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:08.40 server Database 'model' is now online.
00:00000:00001:2005/11/03 16:08:08.40 server Resident Node id: c6c647ba5de2
00:00000:00001:2005/11/03 16:08:08.42 server Transaction coordinator initialized.
00:00000:00001:2005/11/03 16:08:08.43 server Clearing temp db
00:00000:00001:2005/11/03 16:08:09.78 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:09.87 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:09.90 server Database 'tempdb' is now online.
00:00000:00001:2005/11/03 16:08:09.90 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:09.98 server Recovering database 'sybsystemprocs'.
00:00000:00001:2005/11/03 16:08:10.04 server Checking external objects.
00:00000:00001:2005/11/03 16:08:10.07 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/11/03 16:08:10.12 server Database 'sybsystemprocs' is now online.
00:00000:00001:2005/11/03 16:08:10.15 server Recovery complete.
00:00000:00001:2005/11/03 16:08:10.15 server SQL Server's default sort order is:
00:00000:00001:2005/11/03 16:08:10.17 server 'bin_cp850' (ID = 50)
00:00000:00001:2005/11/03 16:08:10.18 server on top of default character set:
00:00000:00001:2005/11/03 16:08:10.18 server 'cp850' (ID = 2).
00:00000:00000:2005/11/03 16:12:27.10 kernel kisignal: SQL Server terminated by window closure.
00:00000:00000:2005/11/03 16:12:27.12 kernel ueshutdown: exiting
00:00000:00000:2005/11/03 16:12:27.12 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
另外使用 startserver -f run_xxx 启动后,从cmd下使用 isql -Usa -SIT -P 能够登录,请再帮我看看,谢谢!!!
我用同样的方法在另外的机子上安装是正常的,这台机子上我装过12。5也没有问题。
谢谢!!!
[ 本帖最后由 pandu 于 2005-11-3 18:04 编辑 ] |
|