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.
重要 : 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.