One Orange Chip
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 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.
Change is inevitable... Change for the better is not.
Hall of Fame
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.
Viewing 4 posts - 1 through 3 (of 3 total)