Freigeben über

  • Artikel

SuperSocketList Property

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

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);

Hinweise

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.

HinweisHinweis

MSDE applications may need to disable all the server Net-Libraries (except shared memory) by setting SuperSocketList to an empty string.

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.

HinweisHinweis

If an application calls SuperSocketList on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Applies To:

Registry2 Object

Siehe auch

Verweis

SuperSocketEncrypt Property