The Trusted property controls SQL Server Authentication behavior for server-initiated connections.
object.Trusted [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | True or False |
To facilitate connections between Microsoft® SQL Server™ installations, SQL Server uses remote-server naming. When an action of a client at the named remote server directs a connection to the local SQL Server installation, the remote server attempts to connect using the login authentication data of the client. Login record mappings at the local installation determine the treatment of that authentication data.
If True, the local installation evaluates the password part of authentication data. For the connection to succeed, the password used by the login on the remote server must be the password used by the mapped local login record.
If False, the local installation does not evaluate any password provided as part of the server-initiated connection attempt.
Boolean
Read/write
HRESULT GetTrusted(LPBOOL pRetVal);
HRESULT SetTrusted(BOOL NewValue);