Connecting Azure SQL Managed Instance with public endpoint(Internet), no need of VPN

We can connect to the Azure SQL Managed instance from our local machine(home machine) if you are practicing or working with Azure Portal, this can be possible without creating VPN. While creating AZure "Sql Managed Instance" please take care of below points under Networking Section while you are creating SQL Managed instance. Please make below changes.






For creating a SQL Managed Instance it will a use a dedicated subnet which is associated with NSG(Network Security Group), and we need to make change in this NSG inbound security rule. We need add 3342 in Allow inbound connections. The below Image will you will see after you created SQL Mnaged Instance, this will appear under Virtual Network.


You can take above endpoint connection string try to access from SSMS which is installed in your home system. It will allow you to connect, no need of any VPNs


Comments

Post a Comment

Popular posts from this blog

Configuring Always on setup in Microsoft Azure.

Image
I mentioned those steps here in which i face issues, remaining procedure same. 1)       1)  Go to custom deployments in market place of azure and search with below word. active-directory-new-domain . And it shown like below https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/application-workloads/active-directory/ active-directory-new-domain /azuredeploy.json Provide below values to the fields. Please provide values for the domainname and dnsprefix appropriately. domainname : aoag.contoso.com-->name should give this way and contoso.com is compulsory. dnspefix : aoagl location: eastus2 Vnet: adVNET DomainFQDN: aoag.contoso.com(this will come in later part) 3)       After creating above domain VM. Create two “ SQL Server Virtual VMs ”,(chose SQL Server 2017 version don't chose SQL Server 2019 as this version has some issues with SQL IaaS extensions) not regular VM. Search in the market place as “SQL Vir...
Read more

AZCopy-- How to copy files from Azure Storage Blob Container to on-premises local storage drive and folder

Image
 This article will describe about how to copy .bak file or .BACPAC file from Azure Blob Container to your on premises local drive and folder. Here I am only describing about only the command which can be used to fulfil our copy request which AZCopy .  This AZCopy is a command line utility which you can download from the mentioned URL. After you download this to a specific drive and folder you to run this from the command prompt(CMD). Before that we need these things. 1) Create a Azure SQL Database and take the backup to Azure Storage blob container. Once the file ready under azure storage you can run AZCopy command from your on-premises server and you can bring to on premises drive and folder. If you see the image below I am need to give READ,ADD,CREATE,WRITE  permissions based on the requirement. Once you give this permissions and after generating SAS please run AZCopy command from the command prompt of your on premises server.  Please see the last image. And the ap...
Read more