Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The SQLForceEncryption property gets or sets a Boolean value that indicates whether a secure connection is to be used when logging to a SQL Server database.
C++
HRESULT put_SQLForceEncryption(
VARIANT_BOOL fSQLForceEncryption
);
HRESULT get_SQLForceEncryption(
VARIANT_BOOL* pfSQLForceEncryption
);
Parameters
fSQLForceEncryption
Boolean value that indicates whether a secure connection is to be used when logging to a SQL Server database.pfSQLForceEncryption
Pointer to a Boolean variable that is set on return to VARIANT_TRUE if a secure connection is to be used when logging to a SQL Server database, or to VARIANT_FALSE if a secure connection is not to be used when logging to a SQL Server database.
Return Value
These property methods return S_OK if the call is successful; otherwise, they return an error code.
Visual Basic
Property SQLForceEncryption As Boolean
Property Value
Boolean value that indicates whether a secure connection is to be used when logging to a SQL Server database.
Remarks
This property is read/write. Its default value is True (VARIANT_TRUE in C++).
When this property is set to True (VARIANT_TRUE in C++) (the default value), the array members use Secure Sockets Layer (SSL), which enforces both encryption and mutual authentication, for direct connections with the SQL server. If the Forefront TMG computers belong to a workgroup, a server certificate must be installed on the SQL Server computer.
Requirements
| Client | Requires Windows 7 or Windows Vista. |
| Server | Requires Windows Server 2008 R2 or Windows Server 2008 x64 Edition with SP2. |
| Version | Requires Forefront Threat Management Gateway (TMG) 2010. |
| IDL | Declared in Msfpccom.idl. |
| DLL | Requires Msfpccom.dll. |
See Also
Send comments about this topic to Microsoft
Build date: 6/30/2010