Administering Security Services Using LAN Manager

Administer the Adaptive Server unified login capability with LAN Manager.

Prerequisites
Adaptive Server must be installed before completing these step.
Task
Administering Network-Based Security

Step

Description

See

1. Set up the configuration files:

  • libtcl.cfg

  • sql.ini

Use a text editor to modify the libtcl.cfg file. Use dsedit to specify security mechanisms in the sql.ini file or a directory service.

Modify Configuration Files Required for a Unified Login

2. Make sure the security administrator for LAN Manager has created logins for each user and for the Adaptive Server and Backup Server.

Identify Users and Servers to LAN Manager

3. Use sp_configure to enable security for the installation.

Configure Adaptive Server for LAN Manager Security

4. Restart Adaptive Server.

Activates the use security services parameter.

Start and Stop Servers

5. Add logins to Adaptive Server to support enterprise-wide login.

Use sp_addlogin to add users. Optionally, specify a default secure login with sp_configure.

Add Logins to Support Unified Login

6. Connect to the server.

Use isql with the -V option or use Open Client Client-Library to connect to Adaptive Server and specify the security services to use.

Note: If you use the isql utility, you do not have to supply a user name or password.
Define the Connection to a Server for Security Services

Open Client/Server Configuration Guide for Desktop Platforms

Security Features in the Open Client Client-Library Reference Manual