LOGIN_MODE Option

Controls the use of integrated logins for the database.

Allowed Values

Standard, Mixed, or Integrated

Default

Standard

Scope

Can be set only for the PUBLIC group. Takes effect immediately.

Description

This option specifies whether integrated logins are permitted. Values are case insensitive:

  • Standard – The default setting, which does not permit integrated logins. An error occurs if an integrated login connection is attempted.

  • Mixed – Both integrated logins and standard logins are allowed.

  • Integrated – With this setting, all logins to the database must be made using integrated logins.

Warning!  Setting LOGIN_MODE to Integrated restricts connections to only those users who have been granted an integrated login mapping. Attempting to connect using a user ID and password generates an error. The only exceptions to this are users with DBA authority (full administrative rights).