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).
This is the default setting, which does not permit integrated logins. An error occurs if an integrated login connection is attempted.
With this setting, both integrated logins and standard logins are allowed.
With this setting, all logins to the database must be made using integrated logins.