#Ssms azure data studio how to#
#Ssms azure data studio plus#

To retrieve data from the SQL Azure table (e.g.Hello and welcome to A Complete Introduction to Azure Data Studio.

#Ssms azure data studio plus#

This will create a linked server to an Azure SQL database (TestDatabase database), and when the plus (+) sign next to the Tables folder is pressed, the Tables folder will expand and show all tables for the TestDatabase database: Under the Security tab, use the same setting that we used in the previous example and press the OK button. Otherwise, if this field is left empty, we will encounter the same 40515 error when trying to get a list of the tables under the Catalogs folder. TestDatabase) of an Azure SQL database for which you want to create a linked server to an Azure SQL database. The most important setting in order to correctly create a linked server to an Azure SQL database is to enter the name in the Catalog text box (e.g. In the Data source text box, enter the name of the SQL Azure (e.g. Under the Provider drop down box, choose the Microsoft OLE DB Provider SQL Server item. The name for the linked server in the Linked server text box can be, this time, whatever you like (e.g. This time, under the Server type section of the General tab, choose the Other data source radio button. To resolve this, you need to connect directly to the Azure database you are going to use.ĭelete the SQL Azure linked server that we created and create a new one: This error occurs because Azure does not allow to alter the master database. Reference to database and/or server name in ‘_tables_rowset2’ is not supported in this version of SQL Server. (.Sfc)Īn exception occurred while executing a Transact-SQL statement or batch. Now, under the Linked Servers folder, Azure linked server that we created will appear and in the Catalogs folder, all available databases will be listed:īut, when expanding a particular database (e.g.TestDatabase) is needed in order to see tables of the database, the following error message will appear:įailed to retrieve data for this request.

#Ssms azure data studio how to#

More about the Security and Server Options tab can be found on the How to create and configure a linked server in SQL Server Management Studio article.Īfter entering the user credentials, press the OK button to create a linked server to an Azure SQL database. Under the Security tab, select the Be made using this security context radio button and enter user credentials that exist on Azure server: Also, on the General tab in the Linked server box, enter the name of the Azure SQL server for which a linked server is created:

Let’s first choose the SQL Server radio button under the Server type section and see what will happen. 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.