You can connect another SQL Server database or different type database from SQL Server database with Linked Server feature. You can use below operations to create new linked server for SQL Server database to SQL Server database.
Create Linked Server Steps
- Create a user on remote database to use connection and give permission on which database using.
- SQL Server Management Studio with sysadmin privilege.
- Open SQL Server Management Studio with sysadmin privilege.
- Click New Linked Server below Server Objects > Linked Servers
- General Section > Select SQL Server as Server type.
- Write remote Instance Name to Linked Server text box.
- Security Section > Add > write Local and Remote User information for connection, and OK.
- You can see added new Linked Server below Linked Server section