The Windows operating system stores configuration information in a tree-structured file called the Registry.
When you install Adaptive Server for Windows, the installation program and Server Config utility write configuration information to several branches, called keys, in the Windows Registry.
This appendix presents the Registry values in a series of tables, one table for each key that appears under HKEY_LOCAL_MACHINE in the Registry:
\SOFTWARE\SYBASE\Server\server_name – Table A-1
\SOFTWARE\SYBASE\SQLServer\server_name\parameter – Table A-2
\SOFTWARE\SYBASE\SQLServer – Table A-3
\SYSTEM\CurrentControlSet\Services\SYBSQL_server_name – Table A-4
In some cases, you can use the information in this appendix to configure features of Adaptive Server. However, you can seriously impair your Windows system if you make incorrect changes to the Registry.
WARNING! Do not modify key values in the Registry unless you are an experienced Windows administrator, and you are familiar with the regedt32 utility. See your system Windows documentation for information about using regedt32.
HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\Server\server_name |
|||
---|---|---|---|
Key name |
Type |
Default |
Description |
DefaultDomain |
REG_SZ |
None |
The default domain for mapping Windows user names to Adaptive Server logins |
DefaultLogin |
REG_SZ |
None |
The login ID to use for access to Adaptive Server when an authorized user does not have an Adaptive Server login defined in syslogins |
LoginMode |
REG_DWORD |
0 |
The login security mode:
|
Map# |
REG_SZ |
Dash (-) |
The special character mapped to the valid Adaptive Server pound sign (#) character |
Map$ |
REG_SZ |
Space ( ) |
The special character mapped to the valid Adaptive Server dollar sign ($) character |
Map@ |
REG_SZ |
Space ( ) |
The special character mapped to the valid Adaptive Server at sign (@) character |
Map_ |
REG_SZ |
Domain Separator (\) |
The special character mapped to the valid Adaptive Server underscore (_) character |
ServerType |
REG_SZ |
SQLServer |
The type of server |
SetHostName |
REG_DWORD |
0 |
Replacement status of the host name from the client login by the network user name under integrated security;
|
HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\SQLServer\server_name\parameters |
|||
---|---|---|---|
Key name |
Type |
Default |
Description |
Arg0 |
REG_SZ |
-dD:\sybase\ASE-15_0\ data\master.dat |
The location of the master device file |
Arg1 |
REG_SZ |
-sserver_name |
The name of the Adaptive Server |
Arg2 |
REG_SZ |
-ed:\sybase\ASE-15_0\install\ errorlog |
The location and name of the error log file |
Arg3 |
REG_SZ |
-id:\sybase\ini |
The location of the sql.ini file |
Arg4 |
REG_SZ |
-Md:\sybase |
The directory that stores shared memory files |
Arg5 |
REG-SZ |
-Nd:\sybase\ASE-15_0\sysam\ <srv_name>.properties |
Location and name of license cache file. |
HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\SQLServer |
|||
---|---|---|---|
Key name |
Type |
Default |
Description |
CurrentVersion |
REG_SZ |
Windows 15.0 |
The version number for the Adaptive Server software installed on the computer |
DefaultBackupServer |
REG_SZ |
server_name_BS |
The name of the default Backup Server |
DefaultMonitorServer |
REG_SZ |
server_name_MS |
The name of the default Monitor Server |
DSEVNTLOG |
REG_SZ |
LocalSystem |
The destination machine for logging messages to the Windows event log |
DSLISTEN |
REG_SZ |
server_name |
The name Adaptive Server uses to listen for client connections when no name is given during Adaptive Server start-up |
RootDir |
REG_SZ |
D:\sybase |
The location of the Sybase installation directory for client applications to look for. Lists the SYBASE environment variable. |
Version |
REG_SZ |
15.0 |
The version number of the Adaptive Server |
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SYBSQL_server_name |
|||
---|---|---|---|
Key Name |
Type |
Default |
Description |
DisplayName |
REG_SZ |
Sybase SQL Server_server_name |
The Adaptive Server name used in the Services list under Control Panel |
ErrorControl |
REG_DWORD |
0x1 |
For system use only |
ImagePath |
REG_EXPAND_SZ |
D:\Sybase\ASE-15_0\bin\ sqlsrvr.exe -s<server_name> -C |
The path for the Adaptive Server executable file |
ObjectName |
REG_SZ |
LocalSystem |
For system use only |
Start |
REG_DWORD |
0x2 |
For system use only |
Type |
REG_DWORD |
0x10 |
For system use only |