Cannot Connect to Database MASTER at SQL server at SERVERNAME – SP2010 Configuration Wizard

ISSUE:

When running the Sharepoint 2010 Configuration Wizard on a new SQL server instance, you may get the following error when configuring the Specify Configuration Database Settings page:

 

 

SOLUTION:

The default SQL 2008 R2 ports are not open on the Windows Firewall on the SQL Server. Use the following steps to correct the issue:

1. On the SQL server, open the Windows Firewall Advanced Security Page.

2. Click the INBOUND RULES option on the left pane.

3. In the right pane for Inbound Rules Actions, click New Rule.

4. On the New Inbound Rule Wizard Page, select Port  for the Rule Type, Click Next.

5. Select TCP for the Protocol and type 1433-1434 in the Specific Local Ports text box. Click Next.

6. On the Action page, make sure Allow the connection is selected. Click Next .

7. On the Profile page, make sure Domain, Private and Public are checked. Click Next.

8. On the Name page, provide a descriptive name and click Finish.

Advertisement