Cannot connect to the configuration database

When I tried to browse a SharePoint Site, I got the following error.

Cannot connect to the configuration database

1

Cause:

This issue might occur because of

  1. The SQL Server Services was stopped.
  2. The account used to run the SharePoint application pool didn’t have a sufficient privilege to connect to the configuration database.
  3. Network connectivity issue with SQl Server.

Solution

1-SQL Server Services was stopped.

  • Open SQL Server Configuration manager.
    SQL Server Configuration manager
  • In SQL Server Services check that SQL Server Instance is running and it’s agent.

SQL Server Configuration manager window

  • 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.Reset SQL Server Account

2-The account used to run the SharePoint application pool 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 assigned account have a sufficient privilege > Reenter the account credentials.reset application pool account
  •  Reset IIS.

iisreset

Note : Make sure that this account must have Security Admin, DB Creator as SQL Server roles.

DBcreator SecurityAdmin

3-Network connectivity issue with SQl Server.

  • From SharePoint server > Try to Ping the SQL Server IP.
    • If the command can not reach the server, you should check the following:
      • Check SQL Server Network Configuration TCP/IP status and ensure it Enabled.Sql Server Netowrk Configration
      • Check Firewall Settings. where Firewall can block access and communication with  Microsoft SQL Server server, so you have 3 possibilities.
        • Disable Firewall,
          • Open windows firewall with advanced security.firewall open
          • Right Click > Select Properties.firewall properties
          • In firewall state > select off.
        •  Adjust firewall state to On > Allow Inbound Connections.firewall disable
        • Create Two Inbound Connections Rules
          • One inbound TCP rule with ports: 1433,2383,2382.
          • One inbound UPD rule with port: 1434.

If all previous steps did not solve the issue,contact the Network administrator.

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s