I am developing a Shiny application for a client and need to connect to a database which uses Windows Authentication to connect. While I am able to connect to the database from a Windows machine, I can't do it from the Linux machine running the Shiny Server (open source version). However I am able to connect to another SQL database from the Shiny Server, which does not use Windows Authentication, instead uses SQL Server Authentication. This is how I am trying to connect:
con2 <- dbConnect(drv=odbc::odbc(), server="MCCSVVSQL01\\POOLPOINT", dsn="POOL_PORTAL_TEST", uid = "my windows id", pwd = "my windows password")
This gives me an error:
Error: nanodbc/nanodbc.cpp:950: IM002: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
The same connection works from a Windows machine. I did request for SQL authentication, but that is against their policies. Is there any way that I can connect to the database using Windows Authentication?