The Windows NT operating system stores configuration information in a tree-structured file called the Registry.
When you install Adaptive Server for Windows NT, the installation program and Server Config utility write configuration information to several branches, called keys, in the NT 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\Control\Session Manager\Environment – Table A-4
\SYSTEM\CurrentControlSet\Services\SYBSQL_server_name – Table A-5
In some cases, you can use the information in this appendix to configure features of Adaptive Server. However, you can seriously impair your NT system if you make incorrect changes to the Registry.
WARNING! Do not modify key values in the Registry unless you are an experienced NT administrator, and you are familiar with the regedt32 utility. See your system NT 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 NT 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\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\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 |
HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\SQLServer |
|||
|---|---|---|---|
Key name |
Type |
Default |
Description |
CurrentVersion |
REG_SZ |
NT 11.5.1 |
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 NT 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 |
11.5.1 |
The version number of the Adaptive Server |
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment |
|||
|---|---|---|---|
Key name |
Type |
Default |
Description |
DSLISTEN |
REG_EXPAND_SZ |
server_name |
The name Adaptive Server uses to listen for client connections when no name is given during Adaptive Server start-up |
DSQUERY |
REG_EXPAND_SZ |
server_name |
The Adaptive Server name that client programs try to connect to when no Adaptive Server name is specified in a command-line option |
Path |
REG_EXPAND_SZ |
current_path;d:\sybase\dll;D:\sybase\bin |
The NT path to which installation adds two paths to search for the Sybase dll and bin subdirectories |
SYBASE |
REG_EXPAND_SZ |
d:\sybase |
The Sybase installation directory for Adaptive Server and the Open Client/Server products |
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\bin\sqlsrvr.exe -sserver_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 |
