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 option uses the log on credentials of the current user to access a database.
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.