I am currently trying to create a connection to SQL Server 2014 via ODBC with the following code:
library(dplyr)
library(dbplyr)
library(odbc)
library(DBI)
odbc::odbcListDrivers()
DBI_Connection <- dbConnect(odbc(),
Encrypt = "no",
# TrustServerCertificate = "yes",
# Trusted_Connection = "yes",
# ForceEncryption = "no",
Driver = "ODBC Driver 18 for SQL Server",
server = "192.168.0.240",
database = "database",
uid = "user",
pwd = "pass",
Port = 1433)
test <- tbl(DBI_Connection, "I07_PARD")
glimpse(test)
However I receive this error:
Error: nanodbc/nanodbc.cpp:1118: 00000: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol] [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection [Microsoft][ODBC Driver 18 for SQL Server]Invalid connection string attribute
I do not need SSL authentication, but I am not sure how to disable it. I know that ODBC Driver 18 requires encryption on server side by default. How can I disable that?
I am able to configure both client and server.