Attribute

LogonID (UID)

Purpose

Specifies one of the following identifiers used for authentication:

  • The default user ID that is used to connect to your database.
  • The object (principal) ID of the Azure SQL logical server. This value is used when authenticating the service principal user with Entra ID (AuthenticationMethod=36).
  • The client ID for the user-assigned managed identity used for authentication. This is an optional value used when authenticating with Managed Identity authentication (AuthenticationMethod=37). Note that this value is required only if you have multiple user-assigned identities. If you have only one user-assigned identity, the driver will connect without specifying a value for this option.

Your ODBC application may override this value or you may override it in the logon dialog box or connection string.

Valid Values

user_id | principal_id | client_id |

where:

user_id
is a valid user ID with permissions to access the database.
principal_id
is the object (principal) ID used for service principal user authentication with Entra ID.
client_id
is the client ID for the user-assigned managed identity used for authentication.

Default

None

GUI Tab

Security tab