Enabling IP Connectivity for MSSQL

Prerequisites

• Start SQL Server Configuration Client (SSCC) on the MSSQL host.

Procedure

1. In the SSCC, in its left pane, expand SQL Server Network Configuration, and then click Protocols for <service name>.

   

2. In the right pane, right click TCP/IP, and from the action menu select Enable.

   If a warning appears, accept it.

3. Apply changes by restarting MSSQL service:

   1. In the left pane, expand SQL Server Configuration Manager (Local), and then click SQL Server Services.
   2. In the right pane, right click SQL Server, and from the action menu select Restart.

Postrequisites

• Complete the remote MSSQL server access using SQL Server Management Studio.

See Also

• MSSQL Prerequisites