question

sajithgh avatar image
0 Votes"
sajithgh asked ElsieLu-MSFT edited

SharePoint 2016 due to MSSQLSERVER_845 in SQL Server 2016



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

https://docs.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-generalsql-server-transact-sqloffice-sharepoint-server-administration
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So did you go through the checklist in the SQL Server topic you linked to?

0 Votes 0 ·

Went through the checklist. Restarted the server and after that the site collections under the content database started working. But we could not find any other issue ther than log database size 16 GB.

0 Votes 0 ·

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ElsieLu-MSFT edited

Hi @sajithgh ,

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.


image.png (208.3 KiB)
31.jpg (82.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.