When I try to connect with the server database I am getting the below error:
pymssql._pymssql.InterfaceError: Connection to the database failed for an unknown reason.
Code snippet:
import pymssql
conn = pymssql.connect(server='test.myserver.abc.com', user='xxxxxx', password='xxxxxxxxxx', database='my_db')
cursor = conn.cursor()
How can I fix this issue? Or is there any way to encrypt the database connection?