The SecurityMode property directs the authentication mode used by a Microsoft® SQL Server™ installation or a connection to a SQL Server database used for replication distribution.
| DistributionDatabase Object | IntegratedSecurity Object |
object.SecurityMode [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying a security mode as described in Settings |
| Constant | Value | Description |
|---|---|---|
| SQLDMOSecurity_Integrated | 1 | Allow Windows NT Authentication only |
| SQLDMOSecurity_Mixed | 2 | Allow Windows NT or SQL Server Authentication (IntegratedSecurity object only) |
| SQLDMOSecurity_Normal | 0 | Allow SQL Server Authentication only |
By default, a SQL Server installation performs login authentication using either Windows NT or SQL Server authentication at the direction of the connection.
Long, enumerated
Read/write for the IntegratedSecurity object. Write-only for the DistributionDatabase object.
HRESULT GetSecurityMode(SQLDMO_SECURITY_TYPE* pRetVal);
HRESULT SetSecurityMode(SQLDMO_SECURITY_TYPE NewValue);