Getting an Intermitent issue with Linked Server between 2 On-premise SQL Servers

Shivendoo Kumar 736 Reputation points
2020-08-24T03:22:38.75+00:00

Hi All,

Every now and then I am getting this issue and not sure where to look into it..?

_Master_ODS:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Login timeout expired".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.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 11.0" Hresult: 0x80004005 Description: "TCP Provider: Timeout error [258]. ".

I have SSIS Package running from SERVER1 and it has a query (view /SP) which has linked server to connect to another Server2. Those packages often fail with above error.

I got this link: https://samzsimplesql.wordpress.com/2015/09/01/troubleshooting-connectivity-issues-timeout-error-258-unable-to-complete-login-process-due-to-delay-in-prelogin-response-pre-login-handshake-failed-2/

going to check with DBA and infra guy to follow steps to find out root-cause.

Please can you guide me. I checked the SQL error Log on Server2 and can't find anything that can be investigated further.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. m 4,271 Reputation points
    2020-08-27T09:35:47.087+00:00

    Hi @Shivendoo Kumar ,

    Is the reply helpful?

    BR,
    Mia
    If the reply is helped, please do "Accept Answer".--Mia

    0 comments