Freigeben über

Networking is disabled by default

  • Artikel

After seeing a number of issues about this, I realized that we needed to comment on this.

For SQL Express, all networking protocols except shared memory are disabled by default.  There is a command line setup switch called DISABLENETWORKPROTOCOLS which is always set to 1 in SQL Express installations.  You can override this by providing the switch DISABLENETWORKPROTOCOLS=0 to setup.exe on the command line.  On an already installed machine, you can use SQL Computer Manager to configure the networking protocols.

The SQL Browser service is also not started by default *unless* the command line switch DISABLENETWORKPROTOCOLS=0 is passed to setup.exe.  You can change SQL Browser's startup type by using the Services control panel.

-Jeffrey Baker
SQL Server Setup Development

Comments

  • Anonymous
    July 02, 2004
    Thanks for the info.

    Waly
  • Anonymous
    July 03, 2004
    The comment has been removed
  • Anonymous
    July 07, 2004
    The comment has been removed
  • Anonymous
    July 08, 2004
    I think what's missing here is that if you're attempting to enable the protocols after SQL Express has been installed, you must also restart SQL Express in order for it to listen on the newly enabled protocols.

    Thanks,
    Steve