TCP Provider: A connection attempt failed for target server

  • Hi.

    In source SQL Instance target linked server has been created and connection tested succeeded. but while executing stored procedure execution failed as below errors. how to fix this issues? checked it is enabled at target instance allow remote connection.

    TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed.

    Thanks

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • The first thing to do is to see what login the stored procedure was running under and then look at the settings for the linked server connection to see if it accommodates such users.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • I'm with Jeff M, probably a security setup issue, like remote user mapping issue.

    If using Win Auth, it could be an SPN issue.

    Or possibly not calling it correctly in the Stored Proc.

    • This reply was modified 2 months ago by  rothj.
    • This reply was modified 2 months ago by  rothj.
    • This reply was modified 2 months ago by  rothj.
    • This reply was modified 2 months ago by  rothj.
    • This reply was modified 2 months ago by  rothj.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply