Enabling TCP/IP

Enable TCP/IP.

  1. From the Windows Start menu, choose Microsoft SQL Server > Surface Area Configuration > Surface Area Configuration for Services and Connections.
  2. Under the Database Engine tree, click Remote Connections.
  3. Select Local and remote connections, and Using both TCP/IP and Named Pipes protocols.
Parent topic: Primary Microsoft SQL Server Configuration and Verification