Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The StandardPassword property identifies a string used as a password for login authentication when a connection to an instance of Microsoft SQL Server is required.
Syntax
object
.StandardPassword [= value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
A string
Data Type
String
Modifiable
Read/write for the ReplicationSecurity object. Write-only for the DistributionDatabase object.
Prototype (C/C++)
HRESULT GetStandardPassword(SQLDMO_LPBSTR pRetVal);
HRESULT SetStandardPassword(SQLDMO_LPCSTR NewValue);
Note
SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.
Remarks
The StandardPassword property is evaluated only if the SQL-DMO object indicates that SQL Server Authentication will be used by the referenced replication component. Use the SecurityMode property of the SQL-DMO object to direct authentication mode selection.
Applies To:
See Also
Reference
SecurityMode Property (DistributionDatabase, IntegratedSecurity)
SecurityMode Property (ReplicationSecurity)