Unable to connect to SQL server on Azure Logic Apps

Question

Unable to connect to SQL server on Azure Logic Apps

Admin 0

Hi,

I am new to Azure logic apps. I am trying to connect to a SQL server using port 1521. I put the port number after the server address as specified in the image. For example, I put testserver.database.windows.net[:1521] as the SQL server name. It gives me the error as follows:

Please check your account info and/or permissions and try again. Details: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) clientRequestId: 5e41a983-0efb-42ae-a6c8-a99c40f5d2f6 More diagnostic information: x-ms-client-request-id is 'E99786E3-E238-497D-9F8A-211EA3B4F010'.

I've added the connector outgoing IP addresses to the server and entered the credentials correctly. What am I doing wrong here?

The database I am trying to connect to is a polardb in Alibaba cloud hosted in Asia.

User's image

Adam Zachary 2,936 Reputation points

2023-11-22T02:17:11.4066667+00:00

Sorry, I didn't see that you're trying to connect to PolarDB.

That is true as @MayankBargali-MSFT mentioned, there's no built-in connector for PolarDB.

But for similar situations where there's no "out of the box" connector, you still can create a custome connector for your PoladDB using Azure Logic Apps' custom connector feature that can communicate with PolarDB's.

You can utilize JDBC for PolarDB as a custom connector in Azure Logic Apps, but it requires creating an Azure Function to act as an intermediary because Azure Logic Apps doesn't support JDBC natively.

I helped couple of customers creating JDBC custom connectors, if interested I can explain how to develop this.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-23T02:14:20.72+00:00

Hi @Admin

Following up to see if my answer helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-24T02:08:59.9733333+00:00

Hi @Admin

I hope the answer helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.

1 answer

Your answer

Adam Zachary 2,936 Reputation points

2023-11-22T02:17:11.4066667+00:00

Sorry, I didn't see that you're trying to connect to PolarDB.

That is true as @MayankBargali-MSFT mentioned, there's no built-in connector for PolarDB.

But for similar situations where there's no "out of the box" connector, you still can create a custome connector for your PoladDB using Azure Logic Apps' custom connector feature that can communicate with PolarDB's.

You can utilize JDBC for PolarDB as a custom connector in Azure Logic Apps, but it requires creating an Azure Function to act as an intermediary because Azure Logic Apps doesn't support JDBC natively.

I helped couple of customers creating JDBC custom connectors, if interested I can explain how to develop this.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-23T02:14:20.72+00:00

Hi @Admin

Following up to see if my answer helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-11-24T02:08:59.9733333+00:00

Hi @Admin

I hope the answer helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.

Answer 1

@Admin Thanks for reaching out.

SQL connector only supports as documented here.

Looking into polar DB document I can see MySQL and PostgreSQL which would not be supported by the connector.

You can try leveraging the MYSQL connector and validate the Prerequisites if it fulfills for your polar DB or not.

Let me know if you have any queries or concerns.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.

Share via

Unable to connect to SQL server on Azure Logic Apps

1 answer

Your answer