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

TCP Provider: Timeout error [258] and Unable to complete login process due to delay in login response Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2014 6:33 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 22, 2014 6:22 AM
Points: 414, Visits: 361
Hello masters,

we are facing one issue from last 3 days.
During job execution (SSIS) we are getting Login TimeOut. with the following error. Request your master help.

Error:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
ource: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired". Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in login response". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: Timeout error [258]. ". End Error


Your help will be very helpful.

Thanks
PK.
Post #1573117
Posted Friday, May 23, 2014 7:57 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:01 AM
Points: 416, Visits: 1,345
pxt_ce (5/21/2014)
Hello masters,

we are facing one issue from last 3 days.
During job execution (SSIS) we are getting Login TimeOut. with the following error. Request your master help.

Error:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
ource: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired". Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in login response". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: Timeout error [258]. ". End Error


Your help will be very helpful.

Thanks
PK.


Did it run before and you have not changed anything after that? If that's true, sounds like network issues, latency maybe?
Post #1574036
Posted Friday, May 23, 2014 8:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:58 AM
Points: 5,488, Visits: 10,340
Here are a few things I'd consider:

* Can you ping the target server from the computer the package is running on? If not, the server may be down or there may be routing or DNS issues
* Is SQL Server Browser running on the target computer, or did you supply the port number in the connection string?
* Can you get a telnet session to the server using the port number? If not, SQL Server may not be running
* Have you spelled the server and instance name correctly?
* Does the target server have TCP enabled in SQL Server Configuration Manager?
* Can you connect to the server from anywhere else?

John
Post #1574048
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse