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