Exportar (0) Imprimir
Expandir todo
Expandir Minimizar

SuperSocketList Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The SuperSocketList property returns a super socket protocol list.


object
.SuperSocketList [= value]

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

String

Read/write

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

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.

NotaNota

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.

NotaNota

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.

Adiciones de comunidad

AGREGAR
Mostrar:
© 2014 Microsoft