Enabling TCP/IP protocol in SQL Server Express

To enable the TCP/IP protocol:

1. Select 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 Select 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. Select Properties to open the TCP/IP Properties dialog, select Yes for Enabled, and select 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. Select SQL Server Services in the left pane under SQL Server Configuration Manager.
5. Select SQL Server (ION) to select it and then select the Restart service icon in the toolbar to stop the service and restart it.
6. Close SQL Server Configuration Manager.