How to troubleshoot “SQL Server is terminating because of fatal exception C0000005 . Error code 17311

Seelan, Sathiya 40 Reputation points
2024-05-16T12:45:55.47+00:00

We have a legacy version SQL Server MSSQL 2008 , where we are getting an error “SQL Server is terminating because of fatal exception C0000005 " SQL Service gets stopped frequently on every Sunday. Unable to find solution for the above error , can I have some expert advise for the issue .

User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,127 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,576 Reputation points
    2024-05-17T05:45:14.2366667+00:00

    We have a legacy version SQL Server MSSQL 2008

    SQL Server 2008 is out-of-support since a very long time.

    Have you installed latest SP 4 + latest CU?

    https://sqlserverbuilds.blogspot.com/#sql2008x


  2. Erland Sommarskog 104.2K Reputation points MVP
    2024-05-18T15:31:05.21+00:00

    What does SELECT @@version return? If you are not on Service Pack 3 for SQL 2008 R2, make sure you install it. You could be facing a bug that has been fixed.

    If you are on SP3, the best option to resolve this issue is to upgrade to a more modern version. But, unless you can run with Express Edition, that comes with a price tag.

    You should also make investigation if you are using any of the following:

    1. Extended stored procedure.
    2. Unsafe CLR assemblies.
    3. Linked servers using third-party OLE DB or ODBC drivers.
    4. sp_OAxxxxx.

    That is, it may be an external component that runs in-process that corrupts SQL Server memory.

    0 comments No comments