Home Forums SQL Server 2008 SQL Server 2008 Administration TCP Provider: Timeout error [258] and Unable to complete login process due to delay in login response RE: TCP Provider: Timeout error [258] and Unable to complete login process due to delay in login response

  • John Mitchell-245523 - Friday, May 23, 2014 8:11 AM

    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

    Hi John,

    As listed by you, I am able to connect to the server from anywhere else.

    regards,
    Thulasi