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
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