TMSAuthentication Enumeration

Specifies the authentication service used by database server to identify a user.

Unit

MSClasses

Syntax

TMSAuthentication = (auWindows, auServer, auADPassword, auADIntegrated, auADInteractive, auActiveDirectoryMSI, auSqlPassword);

Values

Value	Meaning
auActiveDirectoryMSI	Managed Identity (MSI) authentication. For a user-assigned identity, the user ID should be set to the object ID of the user identity.
auADIntegrated	Integrated authentication with an Azure Active Directory identity.
auADInteractive	Interactive authentication with an Azure Active Directory identity. This method supports Azure Active Directory Multi-Factor Authentication (MFA).
auADPassword	User ID and password authentication with an Azure Active Directory identity.
auServer	An alternative way of identifying users by database server. To establish a connection valid TCustomDAConnection.Username and TCustomDAConnection.Password either hardcoded into application or provided in the server login prompt fields are required. The default value.
auSqlPassword	Authentication using user ID and password.
auWindows	Uses Windows NT/2000/XP integrated security, or "SSPI" (Security Support Provider Interface). The Username, Password, and LoginPrompt properties are ignored.

Remarks

The auADPassword, auADIntegrated, auADInteractive, auActiveDirectoryMS, and auSqlPassword authentication methods are supported only for the prMSOLEDB provider (Microsoft OLE DB Driver for SQL Server).