April 10, 2014 at 12:38 pm
I am getting the following error, about once per day, and the server it is trying to connect to is always the same server. I would perfer not to run a wide open trace on the production server.. so trying to find a much better way of finding out what is going on.
[SQLSTATE 42000] (Error 258) OLE DB provider "SQLNCLI10" for linked server "R2D2" returned message "Login timeout expired". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI10" for linked server "R2D2" returned message "Unable to complete login process due to delay in prelogin response". [SQLSTATE 01000] (Error 7412). The step failed.
April 11, 2014 at 4:16 pm
What exactly are you trying to find out? The error is pretty specific: the authentication process is timing out.
Try increasing the connection timeout property on the actual linked server and increase the remote query timeout on the actual server. If it's not a timing issue, the link below may be of some assistance in determining the cause
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 14, 2014 at 3:07 pm
Check if there is any resource contention (CPU, Memory, Ntk ..) \ blocking on the server that's causing this ..
--
SQLBuddy
April 15, 2014 at 11:49 am
It is set at 20 sec.. I would think that should be long enough...it is a SQL Auth login, so all the server has to do is process the request.
April 15, 2014 at 1:40 pm
Yes, it should, but as sqlbuddy mentioned, it could be blocked for a variety of reasons. Try extending it to 180 for testing purposes only (or zero for no timeout) and see if it connects.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply