Linked Server is not working for me for physically separated machine

• Jon-183221

  SSCommitted

  Points: 1908

  More actions

  March 4, 2016 at 3:37 am

  #1863040

  Definitely need to check and confirm the port the instance is listening on.

• assefamisganaw

  SSC-Addicted

  Points: 435

  More actions

  March 4, 2016 at 4:01 am

  #1863047

  When I run the following on Server 2

  USE master

  GO

  xp_readerrorlog 0, 1, N'Server is listening on'

  GO

  LogDate ProcessInfo Text

  2016-03-04 12:57:37.180ServerServer is listening on [ 'any' <ipv6> 1433].

  2016-03-04 12:57:37.180ServerServer is listening on [ 'any' <ipv4> 1433].

  2016-03-04 12:57:37.210ServerServer is listening on [ 'any' <ipv6> 49156].

  2016-03-04 12:57:37.210ServerServer is listening on [ 'any' <ipv4> 49156].

  2016-03-04 12:57:37.240ServerServer is listening on [ ::1 <ipv6> 49162].

  2016-03-04 12:57:37.240ServerServer is listening on [ 127.0.0.1 <ipv4> 49162].

  Any support

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  March 4, 2016 at 4:11 am

  #1863050

  In SSMS on Server1 try connecting to these and let us know:

  Server2,1433

  Server2,49156

  Server2,49162

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato