skip to main content
DataDirect Connect Drivers : Microsoft SQL Server Driver : Authentication
  
Authentication
Authentication protects the identity of the user so that user credentials cannot be intercepted by malicious hackers when transmitted over the network. See Authentication for an overview.
The SQL Server driver supports the following methods of authentication:
*SQL Server authentication, or user ID/password authentication, authenticates the user to the database using a database user name and password provided by the application.
*Kerberos authentication uses Kerberos, a trusted third-party authentication service, to verify user identities. Kerberos authentication can take advantage of the user name and password maintained by the operating system to authenticate users to the database or use another set of user credentials specified by the application.
This method requires knowledge of how to configure your Kerberos environment and supports Windows Active Directory Kerberos only.
*NTLM authentication is a single sign-on OS authentication method. This method requires minimal configuration.
Note: NTLM authentication requires Microsoft SQL Server 2000, Service Pack 3 or higher.
The AuthenticationMethod connection property controls which authentication mechanism the driver uses when establishing connections. See Using the AuthenticationMethod Property for information about setting the value for this property.
* Using the AuthenticationMethod Property
* Configuring SQL Server Authentication
* Configuring Kerberos Authentication
* Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
* Obtaining a Kerberos Ticket Granting Ticket
* Configuring NTLM Authentication