Today, we got a requirement to connect our Azure VM SQL (Report server) instance to access the Azure Database. Let me show you how create linked server for SQL Database on Azure from Azure VM SQL instance.
Please follow the mentioned steps to create a Linked Server to Azure SQL Databse:
Step 1: Open SQL Server Management Studio
Step 2: Execute script: "SP_addlinkedserver".
Step 3: Execute the script to provide the SQL Server login for the above created linked server.
Step 4: Verify the created linked server, under the Databases > Server Objects > Linked Servers > Your Linked Server Name
Step 5: Access the azure SQL database table. You need to use FOUR part query. [linked server name].[database name].[schema name].[table name]"
Posted by Tejas Shah on November 11, 2017
Posted by Tejas Shah on August 12, 2015
Posted by Tejas Shah on November 22, 2017
Posted by Tejas Shah on February 26, 2009
Posted by Tejas Shah on February 09, 2009