January 23, 2009 at 8:03 am
Hi Guys,
We have a strange problem since moving our SQL Server 2005 onto a new Windows 2008 box.
The schduled jobs which use a Linked Server connection outside our domain no longer 'remember' the connection details beyond about 4 minutes. The jobs can be manually kicked off and succeed on the second time of trying.
The jobs which use linked servers within our domain work fine.
If I schdule any of these jobs to run at intervals of less that 5 minutes they work, but beyond that magic time they fail.
I am just guessing that it is the connection details that are 'being forgotten' as I can't think of anything else.
Any ideas anyone ???
Below is the error that is posted in the job history
Message
Executed as user: nnnnn\Administrator. Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "hoswebdb01". [SQLSTATE 42000] (Error 7303) OLE DB provider "SQLNCLI" for linked server "hoswebdb01" returned message "Unable to complete login process due to delay in opening server connection". [SQLSTATE 01000] (Error 7412). The step failed.
January 23, 2009 at 9:04 am
Do you have jobs within the domain which run at > 5 minutes? If so, are they experiencing the same problem? If not, can you set one up as a test?
The reason I ask is this sounds like more than a SQL Server issue.
K. Brian Kelley
@kbriankelley
January 23, 2009 at 10:01 am
Hi Keeper,
Yes we do have jobs within the domain that run successfully each nightly using Linked Servers.
So you think it is possibly a network issue ? - interesting.
thanks for the reply
January 23, 2009 at 11:49 am
If the non-domain servers are on a different network segment or have to cross a firewall, etc., those would be where I'd start. If one group is working and another isn't, you have to look at what's different.
K. Brian Kelley
@kbriankelley
January 26, 2009 at 2:12 am
Thanks - but the non domain links work manually and as a schedule if they run every couple of minutes.
so it looks like the server can access the non domain servers, but in a limited way.
January 29, 2009 at 10:27 am
Is there anything in the event logs for either set of servers when you've got it scheduled for 5 minutes or more? Specifically in the system event log about network connectivity?
K. Brian Kelley
@kbriankelley
February 12, 2010 at 6:28 am
Did this ever get resolved ? I'm having the same problem.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply