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.

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.

If you provide authentication credentials to configure a database connection, they should be available to all users and scripts using this connection.