The SubscriberSecurityMode property is used to configure the authentication mode used for connections originated by the agent implementing a Subscriber-initiated subscription.
object.SubscriberSecurityMode = value
object
Expression that evaluates to an object in the Applies To list
value
Long integer or constant value as described in Settings
Long, enumerated
Write-only
HRESULT SetSubscriberSecurityMode(
SQLDMO_SECURITY_TYPE NewValue);
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 |