NTLM Support for SQL Server professional driver

Avatar
Nathan Stephens
Follow

NTLM support requires SQL Server driver version 1.4.13 or greater. For more information, see the Documentation for RStudio Professional Drivers.

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")

Comments