User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Configure SQL Server with Windows Authentication (Integrated Security)

To use Windows Authentication with

Managed File Transfer

, you must select the Integrated Security option from the Step 3 - Connection Information page, as well as install the sqljdbc_auth.dll file. When the Integrated Security option is set,

Managed File Transfer

will add the integratedSecurity=true flag to the JDBC URL used to connect to the database. The SQL server driver will ignore the username and password specified in the switch database configuration and use the Log On information configured in the Windows Service. Use the following instructions configure Windows Authentication:

Open the Microsoft SQL Server Management Studio.

Create a new database named GADATA.

Download the JDBC driver pack from Microsoft’s website. The sqljdbc_auth.dll file is included in the driver pack.

Place the sqljdbc_auth.dll in the

Managed File Transfer

[installdirectory]\jre\bin folder.

Open Windows Services, right-click on the

Managed File Transfer

Service, and then select Properties. The credentials that start the Windows service will need to be given permission on the SQL Server for Integrated Security.

Restart the

Managed File Transfer

Service.

Return to Microsoft SQL Server Management Studio, and create a new schema named GADATA under the database created in step 3. While creating this schema, make sure to set the server authentication to SQL Server and Windows Authentication mode.

Rename Saved Search

Table of Contents

User Guide

User Guide

Configure SQL Server with Windows Authentication (Integrated Security)

Configure SQL Server with Windows Authentication (Integrated Security)