connectMsSqlDomainLogin: Connects an R session to a running instance of Microsoft SQL...

In nathan-palmer/MsSqlTools: Convenience wrapper functions to establish ODBC connections to SQL Server

Connects an R session to a running instance of Microsoft SQL Server using Active Directory domain login credentials over ODBC. When using Kerberos or Windows Integrated Authentication (SSPI) credentials, select the "ODBC Driver 17 for SQL Server" ODBC driver. When it is necessarry to send the user name and password as function arguments, select the "FreeTDS" driver. The former method is more secure and should be preferred when possible. The two drivers are mutually exclusive in their ability to authenticate domain accounts in these two fashions.

Description

Connects an R session to a running instance of Microsoft SQL Server using Active Directory domain login credentials over ODBC. When using Kerberos or Windows Integrated Authentication (SSPI) credentials, select the "ODBC Driver 17 for SQL Server" ODBC driver. When it is necessarry to send the user name and password as function arguments, select the "FreeTDS" driver. The former method is more secure and should be preferred when possible. The two drivers are mutually exclusive in their ability to authenticate domain accounts in these two fashions.

Usage

connectMsSqlDomainLogin(server, user = NA, domain = NA,
  password = NA, database, port = 1433,
  driver = c("ODBC Driver 17 for SQL Server", "FreeTDS"),
  tdsVersion = "8.0")

Arguments

server	The network address of the Windows instance that is running SQL Server.
user	The SQL Server user name.
domain	The Active Directory domain for the login.
password	The password for the SQl Server user.
database	The name of the database on the server that you want to connect to.
port	The TCP port that SQL Server is listening on.
driver	The name of an installed ODBC driver to use for the connection. Current supported options are "FreeTDS" and "ODBC Driver 17 for SQL Server"
tdsVersion	The TDS protocol version to use for the connection.

nathan-palmer/MsSqlTools documentation built on July 2, 2022, 7:17 p.m.