Unable to connect to SQL server post hosting shiny applications

General
1

Hi Team,

I know the reason why i am getting the error below. However, I need your input to make it work.

I have used below code to connect to my sql server

conn_pr <- odbcDriverConnect(connection = paste0("Driver={SQL Server};server=AAAAA;database=master;UID=AAAAA_AAAAA;PWD=AAAAA_BBBB!;trusted_connection = yes;"))

The above connection works while hosting my application locally. But when I host on shinyapps.io, the connection fails.

Is there a way to connect to sql server post hosting on shinyapps.io?

2

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

If you have a query related to it or one of the replies, start a new topic and refer back with a link.