ODBC Driver for SQL Server

Build 25.0.9434

IntegratedSecurity

Specifies whether to use Windows Integrated Security instead of SQL Server authentication.

Data Type

bool

Default Value

false

Remarks

When this property is set to true, the driver uses the current Windows user identity to authenticate with SQL Server. This is commonly referred to as Windows authentication and is typically used in domain environments or when SQL Server is configured for integrated logins.

When set to false, the driver uses SQL Server authentication, which requires explicit User and Password values in the connection.

This property is only applicable when AuthScheme is set to NTLM.

This property is useful in corporate or on-premises environments where SQL Server is configured for domain-based authentication and user credentials are managed through Active Directory.

Set this property to true to avoid passing explicit credentials and rely on the Windows account context of the running application.

Note: Ensure your SQL Server instance is configured to support Windows authentication when using this property.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434