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!

1 Like

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

1 Like

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