Enabling the Integrated Login Feature

The LOGIN_MODE database option determines whether the integrated login feature is enabled. As database options apply only to the database in which they are found, different databases can have a different integrated login setting even if they are loaded and running within the same server.

The LOGIN_MODE database option accepts one of following three values (which 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 the LOGIN_MODE database option 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 exception to this are users with MANAGE ANY USER system privilege.
Parent topic: Using Integrated Logins