Configuration Wizard error - cannot connect to database Master

Question

Running the Configuration Wizard, getting the "cannot connect to database Master at" server error. Domain account has rights on the SQL Server, can be used to remote connect and navigate databases. What could be the issue?

Answer 1

Hi @Keith Vollero ,

Good day! Welcome to Q&A forum.

For your issue, check the following:

1. Can you connect to the SQL from SQL server directly?
2. Check the permissions for the Setup account which you are using to run the wizard or PowerShell. Make sure the setup account is granted with “DB_Creator” and “Security_aAdmin” Server Roles.
3. If you are using the default instance, just enter the host name instead of FQDN. In case of the Named instance, it should be “Server\InstanceName”. If it is SQL Alias, make sure the alias is properly configured and should be accessible from SharePoint Server. Verify if the SQL Server Alias is created for both 32 and 64-bit! How to Create SQL Server Alias for SharePoint
4. Check if the SQL Server Service is running on your Database Server. Verify “TCP/IP” protocol is enabled under the Network Configuration section of SQL Server Configuration Manager. 
5. Test the connectivity between SharePoint and SQL Server. Try adding a HOST file entry in your SharePoint Server to point to the SQL Server’s IP!
6. Check the firewall rules on SQL Server. If the firewall is enabled on SQL Server, Create inbound TCP rule with ports: 1433,2383,2382 (or whatever dynamic port your SQL server is running) and inbound UPD rule with port: 1434.
7. Double check if you have not fat-fingered Username or Password!

For more detailed information, refer to the following article: SharePoint 2019: Cannot Connect To Database Master At SQL Server | Microsoft Geeks

Hope these information helps.

Please do let us know if you have any further queries.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.