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