well there is two pieces of the puzzle.
IF the linked server is using dynamic ports, you need to have the SQl Browser Service running on the linked server. If it's not
running, or you know you've already configured that other instance to listen on a specific port, you just make sure to specify the port when creating the linked server:
EXEC master.dbo.sp_addlinkedserver
@server = N'My2012LinkedServer',
@provider=N'SQLNCLI',
@srvproduct = N'',
@datasrc=N'DEV223\SQL2012,14330'
--Or
EXEC master.dbo.sp_addlinkedserver
@server = N'My2012LinkedServer',
@provider=N'SQLNCLI',
@srvproduct = N'',
@datasrc='192.168.0.55,14330'
you can use the SQL Configuration manager to change from dynamic to static ports:
Lowell