Enabling SQL Server Express communication over TCP/IP

By default, the SQL Server 2012 Express® database is not configured to communicate over the TCP/IP protocol. If you are installing a site Database that uses SQL Server Express, then you must enable the TCP/IP protocol before the site Database can function properly.

Procedure

  1. On the Start menu, click All Programs > Microsoft SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager.
  2. Click SQL Server 2012 Services.
  3. Expand the SQL Server 2012 Network Configuration node, and then select Protocols for MSSQLServer (SQL Instance Name).
  4. Right-click TCP/IP, and then click Enable.
  5. Select SQL Server 2012 Services in the tree.
  6. Right-click SQL Server (SQL Instance Name), and then click Restart.
Parent topic: Installing a minimum or small deployment using the express install