Default SQL Server Network Configuration

To enhance security, SQL Server disables network connectivity for some new installations. Network connectivity using TCP/IP is not disabled if you are using the Enterprise, Standard, or Workgroup edition or if a previous installation of SQL Server is present. For all installations, shared memory protocol is enabled to allow local connections to the server. The SQL Server Browser service might be stopped, depending on installation conditions and installation options.

Use the SQL Server Network Configuration node of SQL Server Configuration Manager to configure the network protocols after installation. Use the SQL Server Services node of SQL Server Configuration Manager to configure the SQL Server Browser service to start automatically.

1 When shared memory (a local named pipe) is enabled, local connections can connect to the instance by using the named pipes protocol. To connect to the default instance, use osql -E –S np:. as the connection string. To connect to a named instance, use osql -E -S \\.\pipe\MSSQL$<instance_name>\sql\query as the connection string.

Note

If the instance is running on a SQL Server failover cluster, it will listen on those ports on each IP address selected for SQL Server during SQL Server setup. To enable the network protocols, use SQL Server Configuration Manager.