Hi, If anyone has tried connecting to Azure SQL se...
# ingestiona
agreeable-boots-73250
04/24/2020, 4:06 PMHi, If anyone has tried connecting to Azure SQL server please let me know, I am getting the following error
b
bumpy-keyboard-50565
04/24/2020, 4:08 PMSeems like a connection issue. Are you able to connect to the DB from where you ran the script? Here's a simple tutorial on how to test: https://kb.acronis.com/content/7503
a
acceptable-architect-70237
04/27/2020, 6:18 PM@agreeable-boots-73250 since you are trying to connect Azure SQL (cloud version of SQL server), MySQL connection won't work out of box. Or are you trying to connect Azure Managed MySQL?
a
agreeable-boots-73250
04/29/2020, 11:43 AM@acceptable-architect-70237 I am trying to connect MSSQL db
b
bumpy-keyboard-50565
04/29/2020, 3:07 PMAre you able to debug the connection issue?
a
agreeable-boots-73250
04/29/2020, 4:00 PM@bumpy-keyboard-50565 yes I was able to set it up for mysql server, but unfortunately we use MSSQL servers
agreeable-boots-73250
04/29/2020, 4:00 PMand I couldn't see any ingestion script for MSSQL
b
bumpy-keyboard-50565
04/29/2020, 7:00 PMYou'll most likely need to create a new script based of the MySQL one. Shouldn't be super difficult though.