Specifies the version of the NTLM protocol to use for Windows authentication.

Possible Values

Data Type

string

Default Value

"1"

Remarks

This property determines which version of the NTLM (NT LAN Manager) protocol is used when AuthScheme is set to NTLM. NTLM is a Microsoft authentication protocol commonly used for domain-based and Windows Integrated Security scenarios.

Accepted values:

• 1: Uses NTLMv1, which is an older version and less secure.
• 2: Uses NTLMv2 which is more secure and recommended when supported.

NTLMv2 offers stronger encryption and improved security features. However, some legacy systems may only support NTLMv1.

This property is useful when connecting to environments with specific security requirements or compatibility constraints.

Set NTLMVersion=2 to enable more secure authentication, unless you're working with a system that explicitly requires NTLMv1.

This property is only applicable when AuthScheme is set to NTLM. Ensure the SQL Server and network infrastructure support the selected version of NTLM.