Enabling remote SQL Server connections

To enable remote SQL Server 2014 connections

1. On the SQL Server, in the Microsoft SQL Server 2014 program folder, navigate to the SQL Server Configuration Manager.
2. Under SQL Server Configuration Manager (Local), expand SQL Server Network Configuration and click Protocols for <SQL Server instance name>.
3. In the right pane, right-click Named Pipes and click Enable.
4. In the right pane, right-click TCP/IP and click Enable.
5. Under SQL Server Configuration Manager (Local), click SQL Server Services.
6. In the right pane, right-click SQL Server (<SQL Server instance name>) and click Restart.
7. In the right pane, right-click SQL Server Browser and click Properties.
8. Click the Service tab and after Start Mode, select Automatic.
9. Click Apply.
10. Click OK.
11. In the right pane, right-click SQL Server Browser and click Start.