Подключение к sql server odbc/rodbc

Question

Пробую подключиться к sql server

con <- DBI::dbConnect(odbc::odbc(), 
    Driver = "ODBC Driver 18 for SQL Server", 
    Server = "192.168.122.83\\MSSQLSERVER", 
    Database = "TEST", 
    UID = "sa",
    PWD = "Test123",
    Port = 1433)

Ошибка: nanodbc/nanodbc.cpp:1021: 00000: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate] [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection [Microsoft][ODBC Driver 18 for SQL Server]Invalid connection string attribute

Имя драйвера брал с rstudio -> connection -> new connection

RODBC

dbconnection <- odbcDriverConnect("Driver=ODBC Driver 18 for SQL Server;Server=192.168.122.83//MSSQLSERVER;Database=TEST;Uid=sa; Pwd=Test123")

Предупреждения: 1: В odbcDriverConnect("Driver=ODBC Driver 18 for SQL Server;Server=192.168.122.83;Database=TEST;Uid=sa; Pwd=Test123") : [RODBC] ERROR: state 08001, code -1, message [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate] 2: В odbcDriverConnect("Driver=ODBC Driver 18 for SQL Server;Server=192.168.122.83;Database=TEST;Uid=sa; Pwd=Test123") : [RODBC] ERROR: state 08001, code -1, message [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection 3: В odbcDriverConnect("Driver=ODBC Driver 18 for SQL Server;Server=192.168.122.83;Database=TEST;Uid=sa; Pwd=Test123") : ODBC connection failed

select @@servicename
» MSSQLSERVER

Через DBVisualizer - подключился

БЛОГ НА HUSL

Подключение к sql server odbc/rodbc

Ответы (0 шт):