The SubscriberSecurityMode property is used to configure the authentication mode used for connections originated by the agent implementing a Subscriber-initiated subscription.
| MergePullSubscription Object | TransPullSubscription Object |
object.SubscriberSecurityMode = value
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer or constant value as described in Settings |
| Constant | Value | Description |
|---|---|---|
| SQLDMOSecurity_Integrated | 1 | Use Windows NT Authentication. Windows NT account used by the SQL Server Agent service provides a network username for authentication. |
| SQLDMOSecurity_Normal | 0 | Use SQL Server Authentication. Login and password are specified by using the SubscriberLogin and SubscriberPassword properties. |
Long, enumerated
Write-only
HRESULT SetSubscriberSecurityMode(
SQLDMO_SECURITY_TYPE NewValue);