Unable to Connect to Azure SQL Database in shinyapps.io

Hello, I am trying to connect my shiny app to my Azure SQL server using RODBC, but I keep running into errors. For testing I have configured my SQL Server to not block any IP addresses.

My connection string is:

odbcDriverConnect("Driver=FreeTDS;TDS_Version=7.4;Server=tcp:xxx.windows.net,1433;Port=1433;Database=xxx;Uid=xxx;Pwd=xxx;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;")

I have been trying several different versions of FreeTDS. However, every time I deploy my app I receive the following errors:

ERROR: state 08001, code 0, message [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
ERROR: state 01000, code 20013, message [unixODBC][FreeTDS][SQL Server]Unknown host machine name.

I have not been able to find any resolution online, has anyone successfully deployed an app to shinyapps that connects to Azure SQL who could share their code? Much appreciated, thanks!

Figured out the issue. I had to remove the "tcp:" in front of my server name.

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