Timeout expired, Error: -2

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  October 15, 2012 at 10:30 pm

  #263295

  Hi,

  source server and destination server have same SQL Version - SQL2K8 R2 b3 bit, and SP2 - 10.50.4000.0

  Two servers are located to two different location and connected thru Via WAN network...

  Destination server can able to connect source server thru SSMS...but source can not connect due to as below errors...

  what could be issues?

  ------------------------------

  ADDITIONAL INFORMATION:

  Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

  ------------------------------

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  October 16, 2012 at 1:33 am

  #1549398

  Have you checked basic connections issue:

  - ping by ip

  - ping by host name

  - telnet to sql port number

  etc.