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 2010/03/21 7:11 UTC
Read the original article Hit count: 727

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

Related posts about sql-server-2005

Related posts about linked-server