SQL Server via Integrated Authentication

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 Director. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.

SQL Server via Integrated Authentication

Postby Support_Steve » Tue Jun 14, 2011 10:25 am

SQL Server supports SQL and Windows based authentication. If Windows (Integrated) authentication is the preferred method to connect to SQL Server then GoAnywhere must be installed on Windows as well.

Follow the instructions below to connect to SQL Server using Windows authentication:
1) Download and locate the sqljdbc_auth.dll file. This file is located in the jdbc driver pack and can be downloaded from Microsoft's website.
2) Place this .dll file in the [installationDirectory]\jre\bin folder. e.g. C:\program files\linoma software\goanywhere\jre\bin.
3) Open up the Windows Services and right click on the 'GoAnywhere' service and view the properties. The credentials that start the Windows service will need to be given permission on the SQL Server for Integrated Authentication.
4) With SQL server permission and the .dll file in the \bin folder you will need to restart the 'GoAnywhere' service.
5) Open an internet browser and login into GoAnywhere.
6) Navigate to Resources -> Database Servers and either add or edit a server.
7) At the end of the JDBC URL field append the following ;integratedSecurity=true. Note: You will need to select the SQL 2008 driver rather than the older 2000 version.
Support Specialist
Posts: 13
Joined: Fri May 08, 2009 8:59 am

Re: SQL Server via Integrated Authentication

Postby Bjarkisv » Fri Jun 27, 2014 4:26 am


Regarding step #3. GoAnywhere is running as a local system account on a windows server. To give GoAnywhere access to the database I need to run GoAnywhere with some specific system account? Right?

This is the error I get.

2014-6-27 09:18:01 Login failed for user 'Domain\MachineName$'. ClientConnectionId:90ea2ed1-6a7d-47d5-a824-f56502c87b08
Posts: 1
Joined: Thu Nov 07, 2013 4:47 am

Re: SQL Server via Integrated Authentication

Postby Support_Rick » Fri Jun 27, 2014 11:31 am


The common practice is to start GoAnywhere with a Service Account that you give permissions to for access to Servers inside your network.
Rick Elliott
Sr. Product Specialist
(402) 944.4242
(800) 949-4696
Support Specialist
Posts: 393
Joined: Tue Jul 17, 2012 2:12 pm

Return to Knowledge Center

Who is online

Users browsing this forum: No registered users and 0 guests