Looking for help on Connect to Azure SQL server

Help Activities
, ,
1

Hi,

I am looking for options to build a workflow that will be doing connect to Azure cloud SQL dB. I am having the connection string with me but I really do not know what are the prerequisites and how to connect to cloud DB and execute a query. Would you mind helping me with this, please?

Connection string I am using : Server=tcp:testgeorgiaautomation.database.windows.net,1433;Initial Catalog=dbtest;Persist SecurityInfo=False;UserID={USERNAME};Password={MYPASSWORD};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

Will this work? I am getting a Null response out of it.

image
image1035×270 29.6 KB

Do I need to do any driver installation and Datasource creation prior to connecting it?

image
image751×294 14.2 KB

2

@Lahiru.Fernando @celfa @Vibhor.Shrivastava @nisargkadam23

3

@mustak.rased

Check below thread for your reference

Hope this may help you

Thanks

4

I was trying from an outside network. Allowing IP for client network resolved the issue

5

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