Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Connecting to a Database

Testing embedded SQL connection performance Next Page

Using integrated logins

The integrated login feature allows you to maintain a single user ID and password for both database connections and operating system and/or network logins. This section describes the integrated login feature.

Supported operating systems

Integrated login capabilities are available for database servers running on Windows. It is possible for Windows clients to use integrated logins to connect to a network server running on Windows.

Benefits of integrated logins

An integrated login is a mapping from one or more Windows users or Windows user group profiles to an existing user in a database. A user who has successfully navigated the security for that user profile or group and logged in to a computer can connect to a database without providing an additional user ID or password.

To accomplish this, the database must be configured to use integrated logins and a mapping must have been granted between the user or group profile used to log in to the computer and/or network, and a database user.

Using an integrated login is more convenient for the user and permits a single security system for database and network security. Its advantages include:


Integrated logins offer the convenience of a single security system, but there are important security implications that database administrators should be familiar with. See Security concerns: Unrestricted database access, and Security concerns: Copied database files.

Creating integrated logins for Windows user groups
Setting up integrated logins
Network aspects of integrated logins
Creating a default integrated login user
Security concerns: Unrestricted database access