To prepare the SQL server:
- On the server hosting your database, launch SQL Server Configuration Manager.
- In the left pane, expand SQL Server Network Configuration and then select Protocols for <SQL Server> .
- In the middle pane, right-click TCP/IP and then select Enable.
- Right-click TCP/IP and then select Properties.
-
In the
TCP/IP Properties dialog box:
- On the Protocol tab, set Enabled to Yes.
- Click the IP Addresses tab.
- In the IPAll section, in the TCP Port field, enter a TCP port. The default port is 1433.
- Click Apply and then click OK.
- In the left pane, select SQL Server Services.
- In the middle pane, right-click SQL Server an then select Restart.
- In the middle pane, right-click SQL Server Browser and then select Restart.