Relational Database Authentication
Each time a database is accessed, it requires authentication. As a result, the Transformation Designer has two different authentication methods. Any password information provided here is encrypted.
The Use Windows Authentication option uses the log on credentials of the current user to access a database.
If you are using Windows Authentication for a database that is
accessed by the
Transformation Server
Batch Processing Service,
ensure the service is logged on with a Windows user account rather than the
default local system account. You can specify the account within the Service
Configuration tool.
The "Use SQL Server Authentication" option uses an SQL Server user account to access a database. This means that the database can be modified no matter what user is validating a document.
If you provide authentication credentials to configure a database
connection, they should be available to all users and scripts using this
connection.