Fix for Login Failed for user ‘NT AUTHORITY\Anonymous Logon’ (Microsoft SQL Server,Error:18456).

Received the following error message when trying to login from SSMA to Azure SQL DB "Login failed for user 'live.com#@outlook.com'" Followed the steps mentioned here to add Azure Active Directory user as an SQL User in a Contained Database user using the following command: CREATE USER [<Userid>@outlook.com] from EXTERNAL PROVIDER. After some research on the …

Continue reading Fix for Login Failed for user ‘NT AUTHORITY\Anonymous Logon’ (Microsoft SQL Server,Error:18456).

Unable to delete Networking resources – VNET, Virtual Cluster after deleting SQL Server Managed Instance.

When you delete a Manged Instance, sometime you will be unable to delete the networking resources, According to this article, the virtual cluster and subnet associated with the virtual cluster can't be deleted for 12 hours and is available free of cost during that period to allow creation of Managed Instance in the same subnet during this …

Continue reading Unable to delete Networking resources – VNET, Virtual Cluster after deleting SQL Server Managed Instance.

Azure Data Lake Analytics support for Azure Data Lake Gen2

Though Azure Data Lake Gen2 which has best of both worlds - Azure Blob Storage and Azure Data Lake Store Gen1, it currently does not support Azure Data Lake Analytics. Please find below few platforms it supports: For more information please refer this article - https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction#supported-open-source-platforms

Deploy.ps1 cannot be loaded

Executing a powershell script will sometimes result in following error message: In order to fix this issue, following command should be executed in Windows Powershell ISE to change the execution policy for successful execution of the script: Set - ExecutionPolicy - Scope Process - ExecutionPolicy Bypass Other Parameters for Execution policy Settings include: Restricted. Does …

Continue reading Deploy.ps1 cannot be loaded

You do not have the minimum cores available to create the Cluster. Please select a different location or subscription.

Yesterday, a developer reached out to me with an issue which he was facing when he was trying to provision HDInsight Cluster in Azure. After some research found out that, there are quota limits set up by Microsoft not only Per Subscription but also for Region as well as for Resource Groups, Latest Resource quota …

Continue reading You do not have the minimum cores available to create the Cluster. Please select a different location or subscription.

The Azure Subscription doesn’t have permissions to register the resource provider(s).

At times when you are provided access to new azure subscription and you try to provision resources in Azure, you receive an error stating that service principal is not registered as outlined in the diagram below. It may seem that, some resources require access to the subscription level to be able to create these resources …

Continue reading The Azure Subscription doesn’t have permissions to register the resource provider(s).

Azure Virtual Machine Connect button disabled in Azure Portal

Sometimes after creating a virtual machine , the connect button is disabled to connect to Virtual Machine via Terminal Services. The reason it is disabled is due to the fact that that public ip is not assigned to the VM. Once the VM is assiged in Public Ip via power shell or in Azure Portal. Connect …

Continue reading Azure Virtual Machine Connect button disabled in Azure Portal