November 26, 2012 at 9:41 am
I have a linked server, with server options ...
Connection Timeout = 0
Query Timeout = 0
Running a job, we got the following error:
OLE DB provider "SQLNCLI" for linked server "NDCSQLASPP02" returned message "Query timeout expired"... The step failed.
How is that possible with the settings???
November 26, 2012 at 1:58 pm
Network timeouts will look the same way a query timeout will. There's also server level timeout settings, the linked server timeout will merely override it.
Rt-Click your server, then go to properties. Under advanced look at 'Query Wait'. It usually defaults to -1 (indefinately) but if it's set to something else it can timeout. Also go to the linked server side and check the 'connections' settings. Remote Server Connections have a forced timeout, usually defaulted to 600 seconds.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 29, 2012 at 8:15 am
The remote is set to 600 seconds. So this looks like the problem. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply