Cannot connect to database master at SQL server at SQL2008R2
When I try to install SharePoint and run the configuration wizard, I got the following SQL error:
Most of the solutions I got from the internet are either dealing with the permissions for the service account or windows firewall that block the TCP/IP port. However, I have doubled checked these and they are all well set. The actual problem was the SQL Server connection settings.SQL Server TCP/IP connection is disabled by default (see screenshot below).
You need to enable the TCP/IP connection settings by going to SQL Server Configuration Manager and you need to restart the SQL Server services to make the changes happen. After the changes, it works like a charm.