none
client connectivity error. RRS feed

  • Question

  • hi all

    We run ETL jobs daily through Informatica Powercenter and we are getting following error randomly on this server while connecting to SQL Server. When we re-run the job it runs fine. This is suddenly started happening within last 1 month. There were few security windows patches applied on the informatica server, but none of them were related to SQL server, they are all windows hotfixes/updates etc.

    Any pointers will be appreciated.

    Microsoft SQL Server Native Client 11.0 : Login timeout expired
    SQL State : HYT00 Native Error: 0

    Microsoft SQL Server Native Client 11.0 : Unable to complete login process due to delay in prelogin response
    SQL State : 08001 Native Error: 258

    Microsoft SQL Server Native Client 11.0 : TCP Provider: Timeout error [258]
    SQL State : 08001 Native Error: 258
    State: 1 Severity: 16
    SQL Server MEssage: TCP Provider: Timeout error [258]

    Monday, May 2, 2016 7:05 PM

All replies