For a very long time we extract data from a linked server without any issues. We use a scheduled DTS package to call a stored procedure which in turn is doing a bulk copy from the linked server. The linked server 'AAA' is MSSQL 2005 SP2 and the
server which is doing the extraction is SQL2000 SP unknown at this stage. For a while now we get the following error:
"The OLE DB provider "AAA" for linked server "AAA" reported an error. The provider reported an unexpected catastrophic failure. Error source: Microsoft OLE DB Provider for SQL Server " Later
on the error may turn into the follwoing:
"Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server "
We did not changed network security, nor usernames or whatever. It just stared to happen. Together we may get a "locked" error message. We do run Redgate to try and trace this error to no avail. The only way to resolves
this error is to restart both servers.
Any help would be appreciated - this is getting too much now.
View Complete Post