How Do I Set Up a Linked Server? (Magic xpi 4.9)
A linked server enables the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server, thereby allowing access to multiple sources of data from within one server connection.
To create a linked server to another instance of SQL server follow the steps given below.
-
Log-in to the SQL Server Management Studio (SSMS).
-
Under the Object Explorer component, expand the Server Objects menu and right click on the Linked Servers. Select the New Linked Server… option from the expanded menu to create a new server link. This will open a New Linked Server window.
-
Park on the General page. In the Linked Server field, enter the server name that is to be connected.
-
Under the Server Type select the SQL Server radio button.
-
Park on the Security page and click the Add button to create login mapping, where the Local Login is the DB User Name mentioned in the Sap B1 resource. Mention the Remote User with a login name that has appropriate permissions on the remote server mentioned above. Enter the Remote Password which is the password to authenticate the Remote User.
-
Optionally, to view or specify server options, park on the Server Options page.
-
Click OK to save the configuration. The remote login to the linked server is verified before the entry is saved.
-
Once the Linked Server is successfully created validate by running a sample query against it.
|
|
A Linked Server can also be created using Transact-SQL.
|
For more information check the following link:
https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-2017
