By default, SQL Server 2005 or later Express, Evaluation, and Developer editions allow local client connections only. Enterprise, ...

By default, SQL Server 2005 or later Express, Evaluation, and Developer editions allow local client connections only. Enterprise, Standard, and Workgroup editions also listen for remote client connections over TCP/IP. Use the options below to change the protocols on which SQL Server listens for incoming client connections. TCP/IP is preferred over named pipes because it requires fewer ports to be opened across the firewall.