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