Using Integrated Authentication with ARCHIBUS

The integrated authentication feature allows you to maintain a single user ID and password for both database connections and operating system and/or network logins. This section briefly describes the integrated authentication feature. For more detailed information on configuring your server to use integrated logins, refer to the server manufacturer’s documentation.

Benefits of Integrated Authentication

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

To accomplish this, you must enable the database to support integrated authentication and map the machine or network username to a valid database username.

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

When connecting to a database using an integrated login, the user does not need to enter a user ID or password.
With an integrated login, the user authentication is done by the operating system, not the database: a single system is used for database security and machine or network security.
Multiple user profiles can be mapped to a single database user ID.
The name and password used to log in to the machine do not have to match the database user ID and password.

For information on how to configure integrated logins with particular database servers, see:

Configuring ARCHIBUS to Use Integrated Login with Microsoft SQL Server