Default SQL Server Network Configuration
To enhance security, SQL Server 2005 disables network connectivity for some new installations. Network connectivity using TCP/IP is not disabled if you are using 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.
Services and protocols can be started or enabled using the SQL Server Surface Area Configuration tool. Use the SQL Server 2005 Network Configuration node of SQL Server Configuration Manager to configure the network protocols after installation. Use the SQL Server 2005 Services node of SQL Server Configuration Manager to configure the SQL Server Browser service to start automatically.
Default Configuration
The following table describes the configuration after installation.
| Edition | New install vs. previous installation is present | Shared memory | TCP/IP | Named pipes | VIA |
|---|---|---|---|---|---|
Enterprise |
New install |
Enabled |
Enabled |
Enabled for local connections, disabled for network connections |
Disabled |
Standard |
New install |
Enabled |
Enabled |
Enabled for local connections, disabled for network connections |
Disabled |
Workgroup |
New install |
Enabled |
Enabled |
Enabled for local connections, disabled for network connections |
Disabled |
Developer |
New install |
Enabled |
Disabled |
Enabled for local connections, disabled for network connections |
Disabled |
Evaluation |
New install |
Enabled |
Disabled |
Enabled for local connections, disabled for network connections |
Disabled |
SQL Server Express |
New install |
Enabled |
Disabled |
Enabled for local connections, disabled for network connections |
Disabled |
All editions |
Previous installation is present but not being upgraded |
Same as new install |
Same as new install |
Same as new install |
Same as new install |
All editions |
Upgrade |
Enabled |
Settings from the previous install preserved |
Settings from the previous install preserved |
Disabled |
Note
If the instance is running on a SQL Server 2005 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 either the SQL Server Surface Area Configuration tool or SQL Server Configuration Manager.
Note
When installing SQL Server 2005 with command-prompt arguments, you can specify the protocols to enable by using the DISABLENETWORKPROTOCOLS parameter. For more information, see How to: Install SQL Server 2005 from the Command Prompt.
SQL Server Browser Settings
The SQL Server Browser service can be configured to start automatically during setup. The default is to start automatically under the following conditions:
- When upgrading an installation.
- When installing side-by-side with an instance of SQL Server 2000.
- When installing on a cluster.
- When installing a named instance of SQL Server Enterprise, Standard, or Workgroup Edition.
- When installing a named instance of Analysis Services.
See Also
Concepts
Default Client Connection Behavior
Other Resources
Hardware and Software Requirements for Installing SQL Server 2005
SQL Server Surface Area Configuration
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
5 December 2005 |
|