When I tried to browse a SharePoint Site, I got the below error.
Cannot connect to the SharePoint configuration database.
The “Cannot connect to the SharePoint configuration database” issue might occur because of
- The SQL Server Services was stopped.
- You have changed your farm account and you need to update its credentials.
- The account used to run the SharePoint application pool didn’t have a sufficient privilege to connect to the configuration database.
- Network connectivity issue with SQL Server.
SQL Server Services is stopped.
- Open SQL Server Configuration Manager.
- In SQL Server Services, check that SQL Server Instance is running and it’s agent.
- If it was stopped, try to restart it.
- If it was unable to start,
- Right click on service.
- Select properties > Reset the account credentials > Click start.
For more details check Unable to start SQL Server service.
Update Farm Account Credential Using PowerShell
If you have changed your Farm account, you may get “Cannot connect to the SharePoint configuration database”. if you didn’t update the Farm credential using PowerShell.
stsadm -o updatefarmcredentials -userlogin domain\username -password
Network connectivity between SharePoint Server and Database Server
- On SQL server, Make sure that the TCP/IP has been enabled.
- On the Application Server, Try to telnet to the database server IP & port (In case, it’s highly available, try to use the Virtual IP ).
For more details check Enable the telnet client feature on Windows Server.
- Also, you can use UDL file to check connectivity between App server and SQL Server instance
- Make sure that the firewall didn’t block the SQL Server Port (default port is 1433)
Check this steps with your system and network administrators, or disable the firewall state in case, it’s dev environment.
The SharePoint application pool account didn’t have a sufficient privilege to connect to the configuration database.
- Open IIS > Application pool.
- Select the application pool for your web application > Advance Settings > Identity.
Make sure that the application pool account (Identity) is a member of WSS_WPG.
Make sure that the application pool account (Identity) has a sufficient privilege on the following database.
- ‘db-owner‘ and ‘SP_DATA_ACCESS’ on all web application Content Databases.
- ‘WSS_CONTENT_APPLICATION_POOLS‘ on SharePoint Config database.
- ‘WSS_CONTENT_APPLICATION_POOLS‘ on SharePoint_Admin.
- SharePoint 2016.
- SharePoint 2013.
- SharePoint 2010.
- Enable the telnet client feature on Windows Server.
- Unable to start SQL Server service.
- How to Check SQL Server Instance Connectivity from the application server to database server for a specific user.
- An error occurred in deployment step ‘Recycle IIS Application Pool’: The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.