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.
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.