Relational database authentication
Each time a database is accessed, it requires authentication. As a result, Transformation Designer has two different authentication methods. Any password information provided here is encrypted.
The Use Windows Authentication setting uses the log on credentials of the current user to access a database.
Important 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" setting 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.
Note If you provide authentication credentials to configure a database connection, they should be available to all users and
scripts using this connection.