Configuring Adaptive Server Enterprise for Digital Alpha NT

Home

Configuring Sybase(R) Adaptive Server(TM) Enterprise for Digital Alpha Windows NT

Chapter 1: Overview of Adaptive Server Enterprise

Configuring Adaptive Server Enterprise for Digital Alpha NT

About This Book

This manual, Configuring Adaptive Server for Digital Alpha Windows NT, covers the following topics:

Configuring Sybase(R) Adaptive Server(TM) Enterprise, Backup Server(TM), Adaptive Server Enterprise Monitor(TM) Server, and XP Server(TM)
Creating network connections
Configuring optional functionality, such as Sybmail
Performing operating system administration tasks
Working with system administration issues that are relevant to Adaptive Server running on Windows NT. This manual supplements the System Administration Guide and the Performance and Tuning Guide.

Audience

This manual is for System Administrators or other qualified installers who are familiar with their system's environment, networks, disk resources, and media devices.

How to Use This Book

This manual contains the following chapters:

Table 1: Windows NT configuration chapters and descriptions
See
To
Chapter 1, "Overview of Adaptive Server Enterprise"
Become familiar with Adaptive Server and its functionality.
Chapter 2, "Beginning Adaptive Server Configuration"
Change the default server names and their basic features after installing Adaptive Server Enterprise version 11.5.1
Chapter 3, "Setting Up Communications Across the Network"
Configure Adaptive Server to communicate with clients and other servers over the network.
Chapter 4, "Tuning Your Operating System to Adaptive Server"
Set up your operating system to work with Adaptive Server.
Chapter 6, "Logging Error Messages and Events"
Configure the logging of error messages and event messages sent from Adaptive Server.
Chapter 7, "Managing Login Security on an NT Computer"
Integrate Adaptive Server and NT Login Security for added data protection on Adaptive Server.
Chapter 8, "Using Security Services with NT LAN Manager"
Take advantage of NT LAN Manager for added security on Adaptive Server.
Chapter 9, "Using E-mail with Adaptive Server"
Configure Sybmail to direct Adaptive Server to distribute messages automatically.
Chapter 10, "Managing Adaptive Server Databases"
Learn the basics of database administration with Adaptive Server on Digital Alpha Windows NT.
Chapter 11, "Troubleshooting Network Connections"
Learn the basics for troubleshooting network connections with Adaptive Serveron Digital Alpha Windows NT.
Appendix A, "Adaptive Server Registry Keys"
Learn about the NT Registry keys and values that Adaptive Server uses.

**Table 1: Windows NT configuration chapters and descriptions**
See	To
Chapter 1, "Overview of Adaptive Server Enterprise"	Become familiar with Adaptive Server and its functionality.
Chapter 2, "Beginning Adaptive Server Configuration"	Change the default server names and their basic features after installing Adaptive Server Enterprise version 11.5.1
Chapter 3, "Setting Up Communications Across the Network"	Configure Adaptive Server to communicate with clients and other servers over the network.
Chapter 4, "Tuning Your Operating System to Adaptive Server"	Set up your operating system to work with Adaptive Server.
Chapter 6, "Logging Error Messages and Events"	Configure the logging of error messages and event messages sent from Adaptive Server.
Chapter 7, "Managing Login Security on an NT Computer"	Integrate Adaptive Server and NT Login Security for added data protection on Adaptive Server.
Chapter 8, "Using Security Services with NT LAN Manager"	Take advantage of NT LAN Manager for added security on Adaptive Server.
Chapter 9, "Using E-mail with Adaptive Server"	Configure Sybmail to direct Adaptive Server to distribute messages automatically.
Chapter 10, "Managing Adaptive Server Databases"	Learn the basics of database administration with Adaptive Server on Digital Alpha Windows NT.
Chapter 11, "Troubleshooting Network Connections"	Learn the basics for troubleshooting network connections with Adaptive Serveron Digital Alpha Windows NT.
Appendix A, "Adaptive Server Registry Keys"	Learn about the NT Registry keys and values that Adaptive Server uses.

Related Documents

Table 2 lists the documents you need for installing and using Adaptive Server Enterprise.

Table 2: Adaptive Server Enterprise documents
See
To
Release Bulletin
Find last-minute product or document information.
Installing Adaptive Server for Digital Alpha Windows NT
Release Bulletin
Configuring Adaptive Server for Digital Alpha Windows NT
Install or upgrade Adaptive Server and Sybase-related products.
- or -
Customize setup and functionality, including, changing program settings, creating network connections, enabling program options, and managing operating system tasks
What's New in Adaptive Server?
Review the new features in release 11.5, the system changes to support them, and the changes that may affect your existing applications.
Navigating the Documentation for Adaptive Server
Access online links to the concepts and syntax in the Adaptive Server documentation that are relevant to the current task.
Transact-SQL User's Guide
Learn how to use Transact-SQL, Sybase's enhanced version of the relational database language; this manual serves as a textbook for beginning users of the database management system.
System Administration Guide
Learn about system administration issues for Adaptive Server, such as managing physical resources and user and system databases.
Adaptive Server Reference Manual
Learn about commands, functions, procedures, and datatypes. Review Transact-SQL(R) reserved words and definitions of system tables.
Performance and Tuning Guide
Learn how to tune Adaptive Server to maximum effect, including optimizing queries, managing very large databases, handling disk and cache issues, and improving performance.
Utility Programs for Windows and Windows NT
Learn how to use the utilities provided with Adaptive Server, such as isql and bcp.
Security Administration Guide
Learn how to administer a secure operating environment for Adaptive Server to control user access to data. This manual includes information about adding users to Adaptive Server, administering system- and user-defined roles, granting database access to users, and managing remote servers.
Security Features User's Guide
Learn how to use the security features of Adaptive Server, as a non-administrative user.
Quick Reference Guide
Quickly find Adaptive Server syntax and commands.
Troubleshooting and Error Messages Guide
Find solutions to system problems frequently encountered by users and learn how to resolve frequently occurring error messages.
Component Integration Services User's Guide
Learn how to use the Component Integration Services feature to connect remote Sybase and non-Sybase databases.
Adaptive Server Glossary
Learn the definitions of technical terms used in the Adaptive Server documentation.
Master Index for Adaptive Server Enterprise
Search the combined indexes of the Adaptive Server Reference Manual, Component Integration Services User's Guide, Performance and Tuning Guide, Security Administration Guide, Security Features User's Guide, System Administration Guide, and Transact-SQL User's Guide.

**Table 2: Adaptive Server Enterprise documents**
See	To
Release Bulletin	Find last-minute product or document information.
Installing Adaptive Server for Digital Alpha Windows NT Release Bulletin Configuring Adaptive Server for Digital Alpha Windows NT	Install or upgrade Adaptive Server and Sybase-related products. - or - Customize setup and functionality, including, changing program settings, creating network connections, enabling program options, and managing operating system tasks
What's New in Adaptive Server?	Review the new features in release 11.5, the system changes to support them, and the changes that may affect your existing applications.
Navigating the Documentation for Adaptive Server	Access online links to the concepts and syntax in the Adaptive Server documentation that are relevant to the current task.
Transact-SQL User's Guide	Learn how to use Transact-SQL, Sybase's enhanced version of the relational database language; this manual serves as a textbook for beginning users of the database management system.
System Administration Guide	Learn about system administration issues for Adaptive Server, such as managing physical resources and user and system databases.
Adaptive Server Reference Manual	Learn about commands, functions, procedures, and datatypes. Review Transact-SQL(R) reserved words and definitions of system tables.
Performance and Tuning Guide	Learn how to tune Adaptive Server to maximum effect, including optimizing queries, managing very large databases, handling disk and cache issues, and improving performance.
Utility Programs for Windows and Windows NT	Learn how to use the utilities provided with Adaptive Server, such as isql and bcp.
Security Administration Guide	Learn how to administer a secure operating environment for Adaptive Server to control user access to data. This manual includes information about adding users to Adaptive Server, administering system- and user-defined roles, granting database access to users, and managing remote servers.
Security Features User's Guide	Learn how to use the security features of Adaptive Server, as a non-administrative user.
Quick Reference Guide	Quickly find Adaptive Server syntax and commands.
Troubleshooting and Error Messages Guide	Find solutions to system problems frequently encountered by users and learn how to resolve frequently occurring error messages.
Component Integration Services User's Guide	Learn how to use the Component Integration Services feature to connect remote Sybase and non-Sybase databases.
Adaptive Server Glossary	Learn the definitions of technical terms used in the Adaptive Server documentation.
Master Index for Adaptive Server Enterprise	Search the combined indexes of the Adaptive Server Reference Manual, Component Integration Services User's Guide, Performance and Tuning Guide, Security Administration Guide, Security Features User's Guide, System Administration Guide, and Transact-SQL User's Guide.

Other Sources of Information

Use the SyBooks(TM) and SyBooks-on-the-Web online resources to learn more about your product:

SyBooks documentation is on the CD-ROM that comes with your software. The DynaText browser, also included on the CD, allows you to access technical information about your product in an easy-to-use format.
Refer to the Sybooks Installation Guide in your documentation package for instructions on installing and starting SyBooks.
SyBooks-on-the-Web is an HTML version of SyBooks that you can access using a standard Web browser.
To use SyBooks-on-the-Web, go to http://www.sybase.com, and choose Documentation.

Conventions

This manual uses the following style conventions:

Commands you should enter exactly as shown are given in bold Courier font:
```
isql -Usa -Pshobeen -Sgoby
```
Words you should replace within a command line with the appropriate value for your installation are shown in the following bold, italicized font:
```
isql -Usa -Ppassword -Sserver_name
```
Within text, commands you should enter are in regular text and enclosed in quotation marks:
Exit isql by entering "exit" at the prompt.
Prompts are shown in a regular Courier font:
```
d:\sybase\bin
```
Within text, the names of files and directories appear in italic:
Use the \data\master.dat file to . . .
The names of utilities, procedures, commands, and scripts appear in the following font:
sp_revokelogin

Table 3 lists the conventions for syntax statements in this manual:

Table 3: SQL syntax conventions
Key
Definition
command
Command names, command option names, utility names, utility flags, and other keywords are in bold.
variable
Variables, or words that stand for values that you fill in, are in italics.
{ }
Curly braces indicate that you choose at least one of the enclosed options. Do not include braces in your option.
[ ]
Brackets mean choosing one or more of the enclosed options is optional. Do not include brackets in your option.
( )
Parentheses are to be typed as part of the command.
|
The vertical bar means you can select only one of the options shown.
,
The comma means you can choose as many of the options shown as you like, separating your choices with commas to be typed as part of the command.

**Table 3: SQL syntax conventions**
Key	Definition
command	Command names, command option names, utility names, utility flags, and other keywords are in bold.
variable	Variables, or words that stand for values that you fill in, are in italics.
{ }	Curly braces indicate that you choose at least one of the enclosed options. Do not include braces in your option.
[ ]	Brackets mean choosing one or more of the enclosed options is optional. Do not include brackets in your option.
( )	Parentheses are to be typed as part of the command.
\|	The vertical bar means you can select only one of the options shown.
,	The comma means you can choose as many of the options shown as you like, separating your choices with commas to be typed as part of the command.

Terms

The following terms appear repeatedly throughout this book. For more detailed information about these and other terms, see the Adaptive Server Glossary.

System Administrator - refers to the person responsible for Adaptive Server administration. This person may be different from the person responsible for Digital Alpha NT administration.
d:\sybase - is given as an example of the Sybase installation directory.
Text editor - refers to an ASCII text editor or any editor that can save files to text format.

If You Need Help

Each Sybase installation site that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support.

If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.


	Expand Search