AD Authentication to SQL Server for GoAnywhere running on Linux server
Posted: 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.
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.
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.
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.