Now, when clicking the OK button on the New Linked Server dialog, the following error message will appear: The local login can be an SQL Server Authentication local login: In the Local Login field, will be listed all the local logins. One way is to associate a local login with a remote login and other way is to impersonate. Under the Local server login to remote server login mappings, two ways of local logging to a remote login can be set. Here, different ways to authenticate the linked server can be set.
To set how a user would authenticate to the WSERVER2012\SQLEXPRESS instance, under the Select a page section on upper left corner of the New Linked Server dialog, select the Security item: Otherwise the following error may occur when the OK button is pressed: If the SQL Server is a named instance, type the name of the computer and the name of the instance separated by slash ( e.g. If a SQL Server instance is default instance, type the name of the computer that hosts the instance of SQL Server (e.g. If the SQL Server type is chosen to configure a SQL Server linked server, the name specified in the Linked server text box must be the name of the remote SQL Server. For the purpose of this article, the SQL Server radio button under the Server type section will be chosen and in the Linked server text box, a name of the server will be entered: The linked servers can be defined for different kind of data source if the Other data source radio button is chosen. In this dialog, the name of a linked server and server type must be identified. To create a linked server in SSMS, right click on the Linked Servers folder and from the context menu select the New Linked Server option: To see all created linked servers in SSMS, under Object Explorer, chose the Server Objects folder and expand the Linked Servers folder: More information about other data sources can be found on this link.
In this article will be explained how to configure a linked server using a SQL Server data source. One way is by using sp_addlinkedserver system stored procedure and another is by using SQL Server Management Studio (SSMS) GUI interface. There are two ways of configuring linked server in SSMS. By using a linked server to retrieve data from several SQL instances, the only thing that should be done is to connect to one SQL instance. A linked server allows joining data from several SQL Server instances using a single T-SQL statement when data exists on multiple databases on different SQL instances.
Linked servers allow submitting a T-SQL statement on a SQL Server instance, which returns data from other SQL Server instances.
0 kommentar(er)
