While trying to open a SharePoint Site, we were getting the following error in the event log.
Unable to connect to the database SharePoint_Config on Server. Check the database connection information and make sure that the database server is running..
The password of the account that was specified within the Identity tab of App Pool of the site had changed.
Correcting it resolved the issue.