Hi @jwang-e, welcome to the community!! 
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?
Best,
Snehan