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

General
,
1

Hi, am trying to connect Free RStudio Server 2023.06.1 Build 524 which is installed on Ubuntu 20.04.6 LTS to MS 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

am trying to connect it and getting this 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 am able! to connect from the terminal on R Studio Server using the

 isql -v MySqlServerDSN saun 'MyDBPassW0rd'

is there any RStudio Server SSL Configuration am not aware about?

Thanks

2

Well, upgrading MS-SQL-SERVER-2014 to SP1 then SP2 solved the problem.

Thanks

3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.