How to create a native PowerShell app registration to connect to Azure SQL DB

How to create a native app registration This guide assumes that you already own an Azure Subscription, an Azure Active Directory properly setup and your PowerShell environment properly set for running scripts.  You might want to refer to this article first: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/10/26/azure-sql-database-token-base-authentication-with-powershell/ Problem summary:  There might be a time when we you will want to…


Azure SQL Database Token-based authentication with PowerShell

How to connect to Azure SQL Database using token-based authentication in PowerShell native apps This guide assumes you already have a deployment of an Azure SQL Database, your PowerShell environment configured and you have an app registration for a native app in Azure Active Directory. How to configure a native app registration: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/10/30/how-to-create-a-native-powershell-app-registration-to-connect-to-azure-sql-db/ Problem summary: There…


Lesson Learned #40: Could it be possible to use Intellisense with an Azure Active Directory user in SQL Server Management Studio?

The answer is Yes! but we need to do some additional steps in our environment.   If you are the SQL Login administrator or Azure Active Directory administrator user you will have the list of the objects using Intellisense, but, what happens if I’m connecting with non-adminstrator Azure Active Directory user. Let me show you…


Timeout and ADALGetAccessToken Error with AAD connections

Scenario: You have created an Azure SQL Database through the Azure Portal. After opening the outgoing port 1433 on your proxy server and firewall, you are able to connect to the database, using the database administrator account that you have specified while creating the database. To give your domain accounts access to the database, you…