In general, I've loved the connections tab that was implemented within RStudio. However, I'm now trying to connect to my employer's Microsoft SQL Database and is normally accessed through Windows Authentication. I've Googled and looked around but I'm still having trouble understanding exactly how …

Thanks Edgar @edgararuiz ! I was (and still am) confused by this phrase on the RStudio Professional Drivers page: If you are using RStudio Server Pro, RStudio Connect, or Shiny Server Pro, then you can download and use RStudio Professional Drivers at no additional charge. It doesn't list RStudio…

Right, you're referring to the RStudio Commercial Desktop license ( https://www.rstudio.com/products/ ). That is one of the valid products that gives you access to the drivers, I verified that yesterday. We probably need to update the page.

Since Tableau Desktop install already provides us with Simba SQL Server Driver, I was able to leverage it to connect to MS SQL Server from a Mac. The key thing was to set this parameter: Integrated Security=NTLM (I think same could have been done for Trusted Connection)

That's great to know. Is there anything we should note in this page? I feel like there may be a documentation gap on that: http://db.rstudio.com/databases/microsoft-sql-server/

I think the main thing was my note above about the NTML option (which isn't widely documented anywhere)

[image] jdlong: but I have not figured out how to get the combination of ODBC windows auth working right in Mac at all. @jdlong Dude, check out the solution above. It works for me. You'll need Simba driver for SQL server (I downloaded mine here: https://downloads.tableau.com/drivers/mac/Table…

I'm glad you got it going! I'm not having such luck, however: Error: nanodbc/nanodbc.cpp:950: 01000: [unixODBC][Driver Manager]Can't open lib 'Simba SQL Server ODBC Driver' : file not found ODBC on Mac is such an infuriating mess, IMO. At this point I seriously have no idea which incarnation of …

[image] jdlong: Error: nanodbc/nanodbc.cpp:950: 01000: [unixODBC][Driver Manager]Can't open lib 'Simba SQL Server ODBC Driver' : file not found First off, you might want to first try seeing if the odbc package can even see that driver on your machine by using the command from this page, as …

[image] jdlong: ODBC on Mac is such an infuriating mess, IMO. Amen to that, brother! I remember I needed to mess with odbc.ini (or whatchamacallit? actually it's the other one with the driver list: odbcinst.ini i think) files to make RStudio "see" my freshly installed ODBC drivers from Micro…

Posit Community

RStudio Database Connections using Windows Authentication

Posit Professional & Hosted Products