SharePoint 2016 due to MSSQLSERVER_845 in SQL Server 2016

SGH 1,221 Reputation points
2021-07-04T09:26:07.937+00:00

Getting 500 Internal Server error for SharePoint 2016 due to MSSQLSERVER_845 in SQL Server 2016.

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-845-database-engine-error?view=sql-server-ver15

Site collections under the following content database is not responding.

111613-2021-07-04-12-21-05.png

Now few databases show in recovery mode.
111584-2021-07-04-12-29-31.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,600 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,790 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,544 questions
{count} votes

Accepted answer
  1. Elsie Lu_MSFT 9,756 Reputation points
    2021-07-05T08:20:20.783+00:00

    Hi @SGH ,

    For this error, as this post mentioned, you could try to follow these steps:

    1.Go to Central Administration and see if you access.

    2.Go to IIS Manager and check you application pools are all running. If not, start your application pools. To see if they are running click on Application Pool folder and you should see the list on the right-side under state should be "running" or "stopped".
    111689-image.png

    3.Go to your site and see if its working now.

    4.If not, go back to IIS and check to see what application pool is turned off again. Make sure SecurityTokenServiceApplicationPool is running. If not follow this:

    SecurityTokenServiceApplicationPool Application Pool -> Advanced Settings.
    111812-31.jpg

    5.Do an IIS Reset.

    6.Go to the site and see if its working, these steps can be repeated for any app pool that keeps going off.

    Reference:
    500 Internal Server Error SharePoint
    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

    ==========================

    If there is an issue about SQL SERVER, I would suggest you post a new thread with only the SQL SERVER tag, then you will get professional advice from the SQL SERVER team. :)


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful