SuperSocketEncrypt Property
后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。
The SuperSocketEncrypt property specifies whether Super Sockets Net-Library encryption is enabled on an instance of Microsoft SQL Server.
语法
object
.SuperSocketEncrypt [= value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetSuperSocketEncrypt(LPBOOL pRetVal);
HRESULT SetSuperSocketEncrypt(BOOL NewValue);
备注
Before you can enable SSL encryption, your system must meet these conditions:
- The database computer must be running an instance of SQL Server 2000 or later and be assigned a server certificate from a public certificate authority.
- The application must use the client components from SQL Server 2000 or later, and the application computer must be assigned a root CA certificate from the same certificate authority that issued the server certificate to the database computer. The application must connect to an instance of SQL Server 2000 or later.
- You must be a member of the sysadmin fixed server role.
.gif "ms131541.note(zh-cn,SQL.90).gif")
重要提示：Setting the SuperSocketEncrypt property changes registry settings, and should be used with caution. 注意：If an application calls SuperSocketEncrypt 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.