Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Timeout expired, Error: -2 Expand / Collapse
Author
Message
Posted Monday, October 15, 2012 10:30 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:58 AM
Points: 1,061, Visits: 3,020
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

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


Post #1373024
Posted Tuesday, October 16, 2012 1:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, September 27, 2014 4:20 AM
Points: 223, Visits: 1,726
Have you checked basic connections issue:
- ping by ip
- ping by host name
- telnet to sql port number
etc.
Post #1373066
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse