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