hi -
I followed the instructions from this page [Connect Streamlit to Microsoft SQL Server] from streamlit documentation to get my remote Microsoft SQL Server connected, however I am stuck at this error:
Would you mind sharing the connection string used? Additionally, were you able to connect to the instance outside of Python?
The problem could be DNS related, as described in this pyodbc issue. Do you pass the hostname to the SERVER argument in the conn string? If so, does using the IP address instead of hostname resolve the issue?
and st.secrets has been uploaded to github along with changing the setting in app page
I also tried using the IP address as my hostname, but the error seems to remain the same.
At this time, Streamlit Cloud does not support these additional connection parameters. We support SQL Server Authentication - legacy syntax, where the server certificate isn’t validated, and encryption is used only if the server enforces it. The username/password is passed in the connection string. server=Server;database=Database;UID=UserName;PWD=Password;.