SuperSocketList Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The SuperSocketList property returns a super socket protocol list.

Syntax

object
.SuperSocketList [= value]

Parts

• object
  An expression that evaluates to an object in the Applies To list

• value
  A SQL Distributed Management Objects (SQL-DMO) multistring that lists super socket protocols

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetSuperSocketList(SQLDMO_LPBSTR pRetVal);
HRESULT SetSuperSocketList(SQLDMO_LPCSTR NewValue);

Remarks

The protocol list specifies the Net-Libraries (for example, TCP/IP, IPX/SPX, or named pipes) on which Microsoft SQL Server can listen. To set the SuperSocketList property, you must be a member of the sysadmin fixed server role.

• np
  Named Pipes

• tcp
  TCP/IP

• rpc
  Multiprotocol

• spx
  IPX/SPX

• adsp
  AppleTalk

• bv
  Banyan Vines

• via
  VIA system area networks (Giganet and QLogic

Each time you set the SuperSocketList property the Net-Libraries listed are enabled and all other Net-Libraries are disabled except for the shared memory Net-Library, which is always enabled and cannot be configured.

The example shows how to configure an instance with shared memory, named pipes, and TCP/IP Net-Libraries enabled:

Dim r as NEW SQLDMO.Registry2
Set r = oSQLServer.Registry
r.SuperSocketList = "[np] [tcp]"

The example shows how to disable all the Net-Libraries (except shared memory) for an instance:

Dim r as NEW SQLDMO.Registry2
Set r = oSQLServer.Registry
r.SuperSocketList = ""

For more information about setting multistring parameters, see Using SQL-DMO Multistrings.

Applies To:

See Also

Reference

SuperSocketEncrypt Property

Help and Information

Getting SQL Server 2005 Assistance