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

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 Database.





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