Cannot open all site - SharePoint 2019

Question

When I open any site, the error returned, how to fix it. my sites ever worked, don't know why it stopped.

Check ULS log, it showed:

Could not access the Search database. A generic error occurred while trying to access the database to obtain the schema version info. Context: Application '445c11f2-268c-433b-83d9-2ae21f9e7565' Details: (0x80131904)

Answer 1

Hi @Andy ,

From the error in the ULS log, it seems to be only related to search database. As all sites cannot access, please check if there is any other error in the ULS log.
Besides, according to your description, we can do some troubleshooting.
First, check to see whether your SQL Server still works, make sure all SQL server services are running.
Ping SQL server from SharePoint server and see if you get the response.
Second, ensure that TCP\IP and Named Protocols are enabled for the local SharePoint instance.
Go to SQL Server configuration Manager, and check whether Shared Memory option is enabled under "Client Protocols". It should be enabled.

Third, clear the SharePoint Configuration Cache files and restart the timer. Please click here for your reference.
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.
Fourth, ensure the port number 1433 is open (on the server where you are hosting the SQL databases). If you are using a custom port, please enable the port number for incoming connections in the firewall. Please click here for your reference.
Finally, check the Event Viewer log to see if there is any error message.

Thanks,
Yanli Jiang

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

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.