Impersonate Property

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 Impersonate property specifies Microsoft Windows login credential use for connections attempted by the referenced OLE DB data source user.

Syntax

object
.Impersonate [=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 GetImpersonate(LPBOOL pRetVal);
HRESULT SetImpersonate(BOOL NewValue);

Remarks

If TRUE, logins that use Microsoft SQL Server authentication use their own credentials to connect to the referenced OLE DB data source. TRUE is not valid for logins that use Windows authentication unless the Windows environment supports security account delegation and the provider supports Windows Authentication.

If FALSE, a connection attempt uses a specified user name and password.

Applies To:

LinkedServerLogin Object

See Also

Reference

RemotePassword Property
RemoteUser Property

Help and Information

Getting SQL Server 2005 Assistance