Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,366 questions
Issue connecting to Azure SQL DB via Azure Automation (Runbook)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 85%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Detty T Zachariah
1
Reputation point
I am trying to connect via Azure Automation (Runbook) to an Azure SQL Server using Azure Active Directory Admin account using authentication type as Active Directory Password. The runbook runs fine when using SQL Authentication
Error message when using Azure AD authentication is pasted below.
Exception calling "Open" with "0" argument(s): "Unable to load adalsql.dll (Authentication=ActiveDirectoryPassword).
And
New-Object : Exception calling ".ctor" with "1" argument(s): "Invalid value for key 'authentication'."
I got few articles (3 years old) which says Azure AD authentication is not supported by Automation because Azure Automation uses .NET4.5 whereas Azure AD need .NET4.6. Is this true ? Can we use Azure AD authentication within Runbooks now?
Azure Automation
{count} votes
-
tbgangav-MSFT 10,426 Reputation points Moderator2021-02-02T04:05:29.937+00:00 Hi @Detty T Zachariah , Welcome to Microsoft Q&A platform and thank you for your query.
Please give some more time for Community SME's on the topic or our team review your scenario and get back to you at the earliest.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SwathiDhanwada-MSFT 18,996 Reputation points Moderator2021-02-08T12:09:14.56+00:00 @Detty T Zachariah Officially , Azure AD Authentication isn't supported within Runbooks as of now. One workaround is that you can use this sample PowerShell script mentioned in the thread and try executing the runbook on Hybrid Worker by importing required dll's in hybrid worker.
Currently, Azure sandboxes support .NET Framework 4.7.2.
Sign in to comment
Sign in to answer