Controls the use of integrated logins for the database.
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.
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).