Authentication Tab, Data Link Properties Dialog Box

Use the Authentication tab to specify whether you want to use standard authentication or an authentication service when logging on to your data. An authentication service enables you to log on using your Windows NT user name and password and eliminates the need for you to supply this information in a separate step.

Depending on your OLE DB provider, some tab options may not be available.

Tab Options

Use Standard Authentication

Click to use a supplied user name and password to authenticate a user who logs on to the data source.

User Name

Enter the User ID to use for authentication when a user logs on to the data source.

Password

Enter the password to use for authentication when a user logs on to the data source.

Authentication Security

These options specify how your OLE DB provider saves authentication information and the level of password security you want to use.

Allow Saving of Authentication Information

Persists sensitive authentication information such as a password along with other authentication information.

Allow Temporarily Saving of Authentication Information

Caches sensitive authentication information such as a password in an internal cache.

Mask Passwords Sent to the Provider

Sends the password to the OLE DB provider in a masked form. Masking provides less security than encryption.

Encrypt Passwords Sent to the Provider

Sends the password to the OLE DB provider in an encrypted form. Encryption provides greater security than masking.

Use Integrated Security

Select to use an authentication service to identify the user.

To use this feature, your OLE DB provider must support an authentication service and you must have permissions in the data source to use the authentication service.

Authentication Service

Enter the name of the authentication service to use.

Note   The Microsoft OLE DB providers currently do not support authentication services.

See Also

Working with Data Link Properties