When you run a query against a linked server, it is referred to as a distributed query. Once you have configured your linked server, you will be able to run queries etc against it. You should now see your new linked server sitting under the Linked Server node of the Object Explorer. When you're happy with the configuration, click OK to create the linked server.Note that the RPC option enables stored procedures to be called from the remote server to the local machine. This option enables users to run stored procedures against the linked server. And the Server Options allows you to make further configurations for the linked server.This Windows domain authenticated user is also on the remote machine, so the local user can simply impersonate the remote user: We also have a local Windows domain authenticated user mapped to the same user on the remote machine, and set to Impersonate. The password provided here must be the password of the Web_User account on the remote machine. Here, the local SQL Server user Zoidberg is mapped to the Web_User account on the remote machine. Under the Security option, you have the ability to map local users to a user on the remote machine.In this case, I am linking to SQL Server on a remote server called Parrot that has a database called Paywiz. Complete the details for the linked server.Right click on Linked Servers and select New Linked Server.:.In the Object Explorer, open Server Objects and navigate to Linked Servers.All you need is details of the remote server, and the database that you need to query. Setting up a linked server is quite straight forward in SQL Server Management Studio. This can be useful if you need to perform distributed queries (query a remote database). The Linked Servers node allows you to connect to another database, often/usually running on a different machine, perhaps remotely in a different city/country. This is made possible via the Linked Servers node. This is often used to link to other SQL Server databases, but it can also be used to link to a Microsoft Access database. SQL Server provides the option of linking to another server.

Sql server linked server credentials