Back to Blog
Sql server in azure6/23/2023 In this window, the first thing that needs to be done is to enter a name for a linked server in the Linked server box and to choose the server type by clicking the SQL Server or Other data source radio button under the General tab. The New Linked Server window will be opened: To create a linked server via SSMS, go to Object Explorer under the Server Objects folder, right click on the Linked Servers folder and from the context menu choose the New Linked Server command: Also, we will explain how to solve some common problems/issues during the process of creating a linked server to an Azure SQL database.Ĭreate a linked server to an Azure SQL database via SSMS This article will explain how to create and configure a linked server to retrieve data from an Azure SQL database. Excel) by using SQL Server Management Studio (SSMS) or Transact-SQL. Linked servers allow to access data from another SQL Server or another data source (e.g.
0 Comments
Read More
Leave a Reply. |