SQL Server crashes when remote query fails
Posted
by
Hemanshu Bhojak
on Server Fault
See other posts from Server Fault
or by Hemanshu Bhojak
Published on 2009-08-17T08:29:48Z
Indexed on
2012/03/23
5:32 UTC
Read the original article
Hit count: 679
Setup: I have a linked server setup on SQL Server 2005 which is pointing to an Oracle DB. The linked server has RPC enabled.
Problem: When a query throws an exception on the remote server (Oracle DB) the SQL Server instance crashes. The logs say that the crash was due to some problem with the RPC call. Is there a way in which I can prevent the entire server to collapse but also use RPC over my linked server.
EDIT: Event Log
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
© Server Fault or respective owner