Cannot connect to database master at SQL server at SERVERNAME. The database might not exist, or the current user does not have permission to connect During Installing and Configuring SharePoint

After I have been installed SharePoint,I checked Run SharePoint Product Configuration Wizard and during configuring the database server name setting with a correct domain farm account credentials, I got the following error :

“Cannot connect to database master at SQL server at SERVERNAME. The database might not exist, or the current user does not have permission to connect”

Cannot connect to database master at sql server

Cause :

This problem might occur because of

  • The domain user credentials might not be provided correctly.
  • SQL Server Service / SQL Agent / SQL Server Browser was stopped.
  • The provided domain user didn’t have a sufficient permission to access DB Server.
  • SQL Server Network Configuration TCP/IP disabled.
  • SQL Server server was blocked by Firewall.

Solution:

  • The domain user credentials might not be provided correctly.
    • Retype the provided domain user and its password again, make sure it correct.
  • SQL Server Service was stopped.
    • Open SQL Server Configuration Wizard.SQL Server Configuration manager
    • Check the SQL Server Service and SQL Agent and make sure it was started. SQL service Started
    • If it was stopped try to start it by following the mentioned steps in this article.
    • Login to SQL server as windows authentication to make sure that the provided domain user enables to connect to SQL Server via “SQL server management studio”
  • The provided domain user didn’t have a sufficient permission to access DB Server.
    • If you couldn’t connect to DB Server using the provided domain user.thence, it does not have a permission access and you need to permit access.
      • Open SQL Management Studio > Connect to SQL Server as SQL Authentication via sa account > Security > New Login > search for the required user.New Login Sql
      • Set it’s server roles to Dbcreator,Securityadmin permission.DBcreator SecurityAdmin
  • SQL Server Network Configuration TCP/IP disabled.
    •  Check SQL Server Network Configuration TCP/IP status and ensure it Enabled.Sql Server Netowrk Configration
  • SQL Server server was blocked by Firewall.
    • If all previous steps did not solve the issue, you need to 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.
          firewall disable
    • Adjust Firewall state to On and Allow Inbound Connections.firewall allow inbound connections
    • Create Two Inbound Connections Rules
      • One inbound TCP rule with ports: 1433,2383,2382.
      • One inbound UPD rule with port: 1434.

In my case, the problem occurred because of Firewall Setting that should now be worked properly.

SharePoint Products Configration Wizard

Enjoy 🙂

Advertisements

One thought on “Cannot connect to database master at SQL server at SERVERNAME. The database might not exist, or the current user does not have permission to connect During Installing and Configuring SharePoint

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