6/20/2023 0 Comments Connecting to new xmage serverChoose the “ Microsoft OLE DB Provider SQL Server” in the Provider dropdown. Give a suitable name to the Linked Server as per your choice in the Linked Server section. U nder the Server type section, choose the Other data source option. Step-2: Go to General tab in the new Linked Server window. Expand the Server Objects, right click on Linked Server and create a New Linked Server. Step-1: Connect to SQL Server Instance in SSMS tool and go to Object Explorer. Here is the sequence of steps that you need to follow to configure Linked Server using SSMS tool. In this demo we will be querying Database1 tables in the context of Database2. We have taken example of two databases, Database1 (Copy of AdventureWorks 2019) as Azure SQL database & Database2 hosted in On-prem SQL Server Instance. Here in this blog, we are going to demo how to configure Linked server from on-prem SQL Server instance to Azure SQL database. I will have a reference to this blog in my subsequent blogs that will soon be available for Dynamic Data Masking & Cross database/server queries.
0 Comments
Leave a Reply. |