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.
object.SecurityMode [= value]
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies a security mode as described in Settings
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);
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. |
By default, an instance of SQL Server performs login authentication using either Windows or SQL Server authentication at the direction of the connection.