Connect R-Studio Server installed on Ubuntu 20.04.6 LTS to Microsoft SQL Server 2014

70 Views Asked by At

I am trying to connect Free RStudio Server 2023.06.1 Build 524 which is installed on Ubuntu 20.04.6 LTS to SQL Server installed on windows server 2019 datacenter both are on the same network using: odbc() package via the following connection string:

library(odbc)
con <- dbConnect(odbc::odbc(), .connection_string = "DSN=MySqlServerDSN")

and the "DSN=MySqlServerDSN" located in /etc/odbc.ini as follows:

[MySqlServerDSN]
Description = My SQL Server Data Source
Driver      = ODBC Driver 17 for SQL Server
Server      = 192.168.200.100
Port        = 1433
Database    = salesdb
UID         = saun
PWD         = MyDBPassW0rd

I am trying to connect it and getting this error

Error: nanodbc/nanodbc.cpp:1135: 00000: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol] [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection.

The thing is I am able to connect from the terminal on R Studio Server using the command

isql -v MySqlServerDSN saun 'MyDBPassW0rd'

Is there any RStudio Server SSL Configuration I am not aware about?

Thanks

0

There are 0 best solutions below