SQL-DMO
SubscriberSecurityMode Property
The SubscriberSecurityMode property is used to configure the authentication mode used for connections originated by the agent implementing a Subscriber-initiated subscription.
Applies To
| MergePullSubscription Object | TransPullSubscription Object |
Syntax
object.SubscriberSecurityMode = value
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer or constant value as described in Settings
Data Type
Long, enumerated
Modifiable
Write-only
Prototype (C/C++)
HRESULT SetSubscriberSecurityMode(
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 |