Creation of linked server from SQL Server Management Studio
1. Open SQL server Management Studio
2. Connect to the database where you would like to create the linked server.
3. Expand the note Sever Objects

4. Choose the option New linked server.
5. Update the below details

a. Update the linked server name (This will be the name of the Linked server)
b. Set the provider name as specified in the screen shot

c. Enter the product name
d. Specify the Data source as
Driver={SQL Server};Database=databasename;Server=servername;UID=userid;PWD=password;

Notes : if you are facing any issues with accessing the database using the credentials provided , click on the Security tab and choose the security content and set the credentials.