SharePoint 2019: Cannot Connect to Database Master at SQL Server

Question

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. 

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.

Answer 1

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

• SQL Server Best Practices for SharePoint 2019
• SharePoint 2019: Cannot connect to database master at SQL server
• Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment
• How to Check SQL Server Connectivity between Application Server and Database Server