SuperSocketList Property
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The SuperSocketList property returns a super socket protocol list.
Syntaxe
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);
Notes
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.
.gif "ms133955.note(fr-fr,SQL.90).gif") Remarque : |
|---|
| 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.
| Remarque : |
|---|
| 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. |