August 9, 2011 at 1:11 pm
Hi
My linked servers where working fine.
then i ran the following query to set rpc and rpc out
----------------------------------------------------
exec sp_serveroption @server='daps_linked', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='daps_linked', @optname='rpc out', @optvalue='true'
-------------------------------------------------
After i ran the above i get the following error
______________________________________________________
OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x8000ffff: The provider reported an unexpected catastrophic failure.].
________________________________________________________
any ideas on why this happened or what caused this error
August 9, 2011 at 1:17 pm
What happens if you turn them off again?
August 9, 2011 at 1:18 pm
P.S. Try to not start too many threads at the same time. It just fragments replies and waste everybody's time.
August 9, 2011 at 1:30 pm
ok, sorry about that.
i removed the rpc and rpc out and everything appears to be working now.
any idea, why it did not like me setting the rpc
August 9, 2011 at 1:41 pm
Does the other server allow remote connections and RPC? That might be the cause of that error.
But I've had that error and it doesn't look anything like that.
Anything else usefull in the windows or sql error logs?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply