SuperSocketList Property
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The SuperSocketList property returns a super socket protocol list.
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. |
