Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
1.7k views
in SharePoint Server by 62 69 83

Iam trying to install SharePoint 2019 during the configuration in sharepoint configuration wizard, I get the below error:

Cannot Connect to Database Master at SQL Server at DbServer. The Database might not exist, or the current user does not have permission to connect to it. 

Cannot connect to database master at SQL server

I provide the farm account the below permission in SQL Server:

  • DB_Creator
  • Security_Admin

And I'm using SQL Alias in cliconfg, also I check the connection in telnet and it's open.


1 Answer

0 like 0 dislike
by 150 169 345
selected by
 
Best answer

Solving: Cannot connect to database master at SQL server SharePoint 2019

The "Cannot connect to database master at SQL server SharePoint 2019" issue might occur in case,

  1. The Database Server is not reachable from the SharePoint Application Server.
  2. The SQL Server port is closed and is not accessible from SharePoint Application Server.
  3. The domain user credentials maybe not provided correctly.
  4. SQL Server Service is stopped.
  5. SQL Agent is stopped.
  6. SQL Server Browser is stopped.
  7. The provided domain user (Farm Account) doesn’t have sufficient permission (dbCreator, SecurityAdmin) to access DB Server.
  8. SQL Server Listener IP is not added to the Hosts File, Check Configure Hosts File
  9. SQL Server Network Configuration TCP/IP is disabled.
  10. SQL Server server was blocked by Firewall.

Check the detail steps for each root cause at Cannot connect to database master at SQL server. The database might not exist, or the current user does not have permission to connect

See Also

If you don’t ask, the answer is always NO!
...