This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(96, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Can we connect PowerShell to Azure SQL PaaS using Azure AD Integrated authentication ?
From my SQL Mgmt Studio, i can connect using Azure AD Integrated Authentication. So can i connect using PowerShell ? Do i need Azure CLI . Any article or link would be helpful.
Hello @MS Techie Thank you for posting your question in Microsoft Q&A. We are looking into this and will provide an answer to your question shortly. Thanks for your patience
Hello @MS Techie Thanks for being patient while checking on this. Another way of doing it using PowerShell is shared in this document.
Example 11 in the above document is suitable for interactive login
Example 12 is for SPN usage
Example 13 is for Managed Identity usage
Please do let us know if you have further query. Thanks
Hello @MS Techie Please let us know if the answer helped. If yes, Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members. Thanks
![](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(86.4, 98%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
-AccessToken is not part of Invoke-Sqlcmd powershell command, Could you please help me on this.
Yes, you can connect to Azure SQL PaaS using Azure AD Integrated authentication in PowerShell.
Here is a link to the official Microsoft documentation that explains how to connect to Azure SQL PaaS using Azure AD Integrated authentication in PowerShell:
Configure and manage Microsoft Entra authentication with Azure SQL
Regards,
Oury