Need to connect R studio to SQL server management and use Microsofts authentication (LDAP provider)

RStudio IDE
1

Hello need your help to connect to ODBC and get my data.

When i connect directly to sql server, i use my own password and username. but in R studio the password is declined, also the port part =1433.

con <- dbConnect(odbc(),
Driver = "SQLServer",
Server = ***",
Database = "***",
Provider = "ldap",
UID = "*",
PWD = rstudioapi::askForPassword(""),
Port = 1433)

Thanks for your help!

2

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