connectMsSqlStandaloneLogin: 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 a Windows login on a standalone (non-domain) server. This only works with the FreeTDS driver.

Description

Connects an R session to a running instance of Microsoft SQL Server using a Windows login on a standalone (non-domain) server. This only works with the FreeTDS driver.

Usage

connectMsSqlStandaloneLogin(server, user, domain, password, database,
  port = 1433, driver = "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.