on-Premise SQL Server Connection with Windows Authentication from Azure functions

Gurram, Aditya 1 Reputation point
2022-11-08T19:49:01.83+00:00

Is there any workaround to use windows authentication to connect to on-premise sql server from Azure functions? In all my research, I found that Azure supports only SQL authentication. Existing On-Premise SQL Server doesn't have SQL account/allow us to create one due to security issues.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,399 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. David Broggy 6,101 Reputation points MVP
    2022-11-08T19:54:21.27+00:00

    Hi Gurram,
    This might be more complex, but you can use Azure automation along with functions within a logic app, which would allow you to use powershell as part of your solution.
    overview

    Lior Tamir created a logic app playbook with automation that's used to block Exchange IPs.
    The same example could apply to a logic app that logged into sql server.
    If you're saying you can't run powershell commands like Invoke-Sqlcmd then that's another problem..

    Block-ExchangeIP
    manage-authentication-in-database-engine-powershell

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.