NTLM Support for SQL Server professional driver

1. Install the SQL Server driver

Visit Installing RStudio Professional Drivers for instructions on installing and upgrading.

2. Configure authentication using NTLM

1. Set the Trusted_Connection property to NTLM.
2. Set the Integrated Security property to true.
3. Set the UID property to an appropriate user name for accessing the server.
4. Set the PWD property to the password corresponding to the user name that you provided above.

An example DSN:

[SQL Server]
Driver=sqlserver
Server=192.168.222.160
Port=1500
Database=TestDB
Integrated Security=true
Trusted_Connection=NTLM
UID=domain\\simba
PWD=simba

3. Validate with isql

> isql "SQL Server" -v

4. Connect in R

library(DBI)
con <- dbConnect(odbc::odbc(), "SQL Server")