SQL Server 2008 deployment of linked servers

A linked server allows users to distribute heterogeneous queries against OLE DB data sources. After you create a linked server, you can make distributed queries on that server, and you can link tables from multiple data sources. If the linked server is defined as an instance of SQL Server, you can execute a remote stored procedure.

Environment: master server, 10.20.9.2 standby server, 10.20.9.3

Now create a linked server on the primary server.

Step one: Open Microsoft SQL Server Management Studio and log in to the SQL library

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/79/E7/wKioL1ad3OOwMb0EAADG5Pfrruo946.png "title=" 2.png " alt= "Wkiol1ad3oowmb0eaadg5pfrruo946.png"/>

Step Two: Create a new linked server

Open server objects-linked servers-new linked server

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/79/E7/wKioL1ad3KiBR5MiAACEkcYOsjI515.png "title=" 1.png " alt= "Wkiol1ad3kibr5miaacekcyosji515.png"/>

When you open the new Linked server window, for example, in the linked server bar, fill in the Ip\ instance name of the standby server, which is the server you want to link to.

Note: Here you want to link the standby server, which must be accessible on the primary server. If the standby server is the default instance when you install SQL Server, when you fill out the linked server, you can fill in the IP directly, without adding the instance name, if the SQL Server is a named instance when you installed it, you need to add the instance name. There is also a trick, if you want to name and do not want to use IP, can be in the host server hosts a local resolution, for example, sqlbak resolution of 10.20.9.3, so that you can fill in the SQLBAK\IIS_SQSS

Server type can be directly selected SQL Server, other data sources are not introduced here.

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/79/E8/wKiom1ad3hmjzeQEAADVB2UYC3E287.png "title=" 3.png " alt= "Wkiom1ad3hmjzeqeaadvb2uyc3e287.png"/>

Security, local login Select a local account that can log on to the primary server's SQL Server, and the remote user is the SQL account that is used to log on to the standby server that you want to link to, where you can use the SA account directly. The following "Make a connection using this security context" is also checked, enter just the SA account.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/79/E8/wKiom1ad4M3hjubKAAFgS4TETaI409.png "title=" 4.png " alt= "Wkiom1ad4m3hjubkaafgs4tetai409.png"/>

When the above procedure is complete. Basically the linked server is created successfully. Such as.

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/79/E9/wKiom1ad4iOhu7wHAABtb7WG1pc911.png "title=" 5.png " alt= "Wkiom1ad4iohu7whaabtb7wg1pc911.png"/>

This article is from the "Nick-gui" blog, make sure to keep this source http://52yunwei.blog.51cto.com/7309147/1736505

SQL Server 2008 deployment of linked servers