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 – All logins to the database must be made using integrated logins.