Azure-docs: Issues connecting to on-prem DB using ISE

[karpikpl]

The guide describes connecting to on-prem using data gateway, but I believe there's another way using ISE, VNets and express route.

I was able to connect using ISE, but I'm having issues connecting using Windows Credentials.
Could you provide some more information?
Is it possible to use windows credentials via ISE?
How to troubleshoot connectivity issues? (particularly - bad password error which I'm getting right now)

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 5e190390-dc83-246e-3e69-189f33d67ed7
• Version Independent ID: 66132130-9d94-fc33-7bc4-a54ee270efbc
• Content: Connect to SQL Server or Azure SQL Database - Azure Logic Apps
• Content Source: articles/connectors/connectors-create-api-sqlazure.md
• Service: logic-apps
• GitHub Login: @ecfan
• Microsoft Alias: estfan

[mike-urnun-msft]

@karpikpl Thank you for your feedback! We will review and update as appropriate.

[mike-urnun-msft]

Hi @karpikpl - Unfortunately, Windows auth is not currently supported for the SQL ISE connector. Please consider submitting a new feature request on Azure UserVoice or upvoting an existing one (not directly touches on ISE) for the Logic Apps team to review for the product roadmap. In the meantime, one approach you may consider would be running an app on a VM (that is domain joined) that exposes REST endpoint that has its own security (e.g: certificate-based auth) and interfacing it with a custom connector from your Logic App.

We will now proceed to close this thread. If there are further questions regarding this matter, please reopen it and we will gladly continue the discussion.

[ecfan]

Hi @karpikpl & @mike-urnun-msft,

In the meantime, the team also suggested that to use Windows authentication with the SQL Server connector in an ISE, you can use the connector's non-ISE version instead with the on-premises data gateway. I've updated the docs to include this suggestion in the Prerequisites section:

https://docs.microsoft.com/azure/connectors/connectors-create-api-sqlazure#prerequisites

[lokijota]

Hi all. I also can't get the ISE SQL Adapter to work with SQL Authentication . Non-ISE works fine but customer can't go live with non-ISE.

[ecfan]

Hi @lokijota, thanks for your post, and I'm sorry to hear about your experience. Could you please post this issue on the Logic Apps forum? The GitHub issues channel is for driving improvements to the documentation.