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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database connections » Authentication mechanisms

Windows integrated login

The Windows integrated login feature allows you to maintain a single user ID and password for operating system and network logins, and database connections.

To create an integrated login:

  • Enable the integrated login feature.

  • Create a database user to map the integrated login to (if one does not already exist).

  • Create an integrated login mapping between a Windows user or group profile and an existing database user. The Login Mappings folder in SQL Central lists all users with integrated login privileges.

  • Connect from a client application and test the integrated login facility.

Supported operating systems

Integrated login capabilities are available for Windows-based database servers. Windows clients can use integrated logins to connect to a network server running on Windows.

Integrated login benefits

An integrated login is a mapping from one or more Windows users or Windows user group profiles to an existing database user. 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 do 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 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. The advantages of an integrated login include:

  • Users do not need to type a user ID or password.

  • Users are authenticated by the operating system. A single system is used for database security and computer or network security.

  • Multiple user or group profiles can be mapped to a single database user ID.

  • The name and password used to log in to the Windows computer do not have to match the database user ID and password.

Caution Integrated logins offer the convenience of a single security system, but there are important security concerns that database administrators should be familiar with, such as unrestricted database access and copies of database files. Ensure that you are aware of these concerns and how to address them.