SecurityMode Property (DistributionDatabase, IntegratedSecurity)
The SecurityMode property directs the authentication mode used by an instance of Microsoft® SQL Server™ 2000 or a connection to a SQL Server database used for replication distribution.
Applies To
| DistributionDatabase Object | IntegratedSecurity Object |
Syntax
object.SecurityMode [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies a security mode as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write for the IntegratedSecurity object. Write-only for the DistributionDatabase object.
Prototype (C/C++)
HRESULT GetSecurityMode(SQLDMO_SECURITY_TYPE* pRetVal);
HRESULT SetSecurityMode(SQLDMO_SECURITY_TYPE NewValue);
Settings
Set value using these SQLDMO_SECURITY_TYPE values.
| Constant | Value | Description |
|---|---|---|
| SQLDMOSecurity_Integrated | 1 | Allow Windows Authentication only. |
| SQLDMOSecurity_Mixed | 2 | Allow Windows Authentication or SQL Server Authentication. |
| SQLDMOSecurity_Normal | 0 | Allow SQL Server Authentication only. |
| SQLDMOSecurity_Unknown | 9 | Security type unknown. |
Remarks
By default, an instance of SQL Server performs login authentication using either Windows or SQL Server authentication at the direction of the connection.