Sql Server Link Server. Now open sql server management studio (ssms) and login to sql server. In the object explorer for the sql server instance, go to server objects and right click and select new > linked.

Follow these steps to add a database reference for a linked server: There are several important settings to know when setting up a linked server. And if the sql server is a named instance, enter the name of the computer and the name of the instance, such as accounting\sqlexpress.