Nota
L'accés a aquesta pàgina requereix autorització. Podeu provar d'iniciar la sessió o de canviar els directoris.
L'accés a aquesta pàgina requereix autorització. Podeu provar de canviar els directoris.
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.
Sintaxis
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);
Notas
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.
[!NOTA] 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.
[!NOTA] 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.