I suggest you ...

Azure Automation | update workers to at least .NET Framework 4.6 (for Azure AD connection support to SQL)

Currently, Azure Automation Account doesn't support connecting to SQL using Azure AD
For example:
connectionString = "Server=$server;Database=$database;User ID=$adminName;Password=$adminPassword;authentication=Active Directory Password;"

This will return an error when executed via Azure Automation "Keyword not supported: 'authentication'.""

The reason seems to be that the Automation workers still use .NET Framework 4.5, and we need at least 4,6 to have Azure AD support to SQL.

There are more people running into this issue, please also see: https://stackoverflow.com/questions/45091135/active-directory-password-connection-azure-sql-failure-from-azure-automation/45093784

Thank you and kind regards

3 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    HuijgenHuijgen shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base