AD Authentication to SQL Server for GoAnywhere running on Linux server

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere MFT. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
1 post Page 1 of 1

Support_Julie

User avatar
Support Specialist
Posts: 91
Joined: Thu Mar 05, 2009 3:49 pm
Location: Ashland, NE USA

Post by Support_Julie » Fri Feb 15, 2019 3:37 pm
Question:
Can I use AD Authentication to a database resource on SQL Server? My SQL Server only uses AD authentication. The JDBC driver provided with MFT supports connects using integrated authentication but that is specific to Windows.

Answer:
Obtain the driver for SQL server that does accommodate AD authentication.

Copy to the GoAnywhere [Install Directory]\userdata\lib folder. (in this case, the jar file was jtds-1.3.1.jar).

Create the database resource with AD authentication through JTDS.

After the jar file is in the lib directory, configure the resource.

Here is the documentation for JTDS. http://jtds.sourceforge.net/faq.html#dr ... ementation

Instead of selecting a driver from the list you can type in the driver name. You will need to stop and restart GoAnywhere before it can find the driver.

The connection string would be something like this:

Jdbc:jtds:sqlserver://myServer:myPort/myDB;domain=myDomain

For the JDBC URL, where you see “myServer”, replace with your SQL server name.

Where you see “myPort”, replace with port number.

Where you see “myDB”, replace with your DB name.

Where you see “myDomain”, replace with your domain name.

For the “User” field enter your Windows AD user id.

From the documentation the domain property invokes authentication against AD.
AddDB.jpg
Below is an example of a working connection. It did require a restart of MFT to recognize the jTDS jar in lib. Here is the successful URL.

jdbc:jtds:sqlserver://server:1433/db-name;domain=COV;useNTLMv2=true;ssl=request

useNTLMv2=true (needed to specify AD authentication)
ssl=request (needed for encryption.)

11/28/18 1:45:57 PM Registering 'net.sourceforge.jtds.jdbc.Driver' with the Driver Manager.
11/28/18 1:45:57 PM Connecting to database server.
11/28/18 1:45:57 PM Retrieving database and driver information.
11/28/18 1:45:57 PM Database Name: 'Microsoft SQL Server'
11/28/18 1:45:57 PM Database Version: '12.00.5571'
11/28/18 1:45:57 PM Driver Class: 'net.sourceforge.jtds.jdbc.Driver'
11/28/18 1:45:57 PM Driver Name: 'jTDS Type 4 JDBC Driver for MS SQL Server and Sybase'
11/28/18 1:45:57 PM Driver Version: '1.3.1'
11/28/18 1:45:57 PM Closing database connection.
This connection is to MSSQL 2014.
Julie Rosenbaum
Sr Support Analyst
e. [email protected]
p. 1.800.949.4696
w. HelpSystems.com
1 post Page 1 of 1