Enabling TCP/IP protocol in SQL Server Express

To enable the TCP/IP protocol:

1. Click Start > All Programs > Microsoft SQL Server 20xx > Configuration Tools > SQL Server Configuration Manager, where 20xx is the SQL Server version.
2. Expand SQL Server Network Configuration in the left pane and click Protocols for ION.
3. If the TCP/IP protocol status is Disabled, right-click TCP/IP, and:

   1. Select Enable in the menu,

      or,

   2. Click Properties to open the TCP/IP Properties dialog, select Yes for Enabled, and click OK.

      When you enable the TCP/IP protocol, an informational message indicates that you need to restart the service before the change takes effect.

4. Click SQL Server Services in the left pane under SQL Server Configuration Manager.
5. Click SQL Server (ION) to select it and then click the Restart service icon in the toolbar to stop the service and restart it.
6. Close SQL Server Configuration Manager.