Posts

Showing posts from August, 2022

Creating a Linked Server between Azure SQL Database and On Premises database.

Image
The topic below describes about how to create a linked server between a Azure SQL Database and an on premises environment. Before that please follow the steps below. 1) Create an Azure SQL Database in Azure 2) Create a login in Azure SQL database or use the same login with which you are connecting to the Azure SQL Database. 3) Create a Linked Server in On premises environment by providing the login details(2nd step). Follow the below images The images below are self explanatory Go to on premises server under server objects to create a linked server. Here the testDB is the name of the database which got created in Azure SQL Database The below Image is the second image where you need to provide security . Here the user name and password are Azure Login information. After click on OK button the linked server will automatically gets created. However the linked server is not shown here. But you can see it from your end once it gets created. The image below is an example of Azure SQL Datab...

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

Image
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