Condividi tramite


Trusted Property

Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

The Trusted property controls SQL Server Authentication behavior for server-initiated connections.

Sintassi

object
.Trusted [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list
  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetTrusted(LPBOOL pRetVal);
HRESULT SetTrusted(BOOL NewValue);

Osservazioni

To facilitate connections between instances of Microsoft SQL Server, SQL Server uses remote-server naming. When an action of a client at the named remote server directs a connection to the local instance of SQL Server, the remote server attempts to connect using the login authentication data of the client. Login record mappings at the local instance determine the treatment of that authentication data.

If TRUE, the local instance 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 instance does not evaluate any password provided as part of the server-initiated connection attempt.

Applies To:

RemoteLogin Object