SQL Server 2008 deployment of linked servers

Source: Internet
Author: User
Tags microsoft sql server management studio microsoft sql server management studio sql server management sql server management studio

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.