Windows account

In the ConnectionString parameter, you must provide the following information: domain, user name and password. The domain and user name must be specified using the following syntax:

User ID=<Domain>\<UserName>; Password=<pasword>;

The SQLData Script Library takes the following actions:

1. Removes domain, user name, and password from <ConnectionString>.

2. Sets Integrated Security=True in <ConnectionString>.

3. Configures the connection manager with the specified domain, user name, and password and then requests impersonation of this user.

The SQLData Script Library impersonates the user based on the properties that were provided in the connection string.