- Download the JDBC Driver for SQL Server 2008 from the Microsoft’s web site, http://www.microsoft.com/downloads/deta ... laylang=en. This URL may change down the road, in which case make sure to download the product, Microsoft SQL Server JDBC Driver 2.0.
- On the EULA (End User License Agreement) page, you will have options to download either the Windows version of the driver (exe) or the UNIX version (tar.gz) of the driver
- If you are downloading from a Windows PC, download the Windows version
- Install/uncomress the downloaded file
- Stop GoAnywhere service/subsystem
- Navigate to the directory where you have installed/uncompressed the new driver
- Navigate to the sub-directory, enu.
- Copy the file named sqljdbc.jar (DO NOT use the sqljdbc4.jar) to the system where GoAnywhere is installed. The location to copy is [INSTALL_DIR]/WebRoot/WEB-INF/lib. Where [INSTALL_DIR] is the directory where GoAnywhere is installed. There is already a file with the same name under this folder. If you want to be extra cautious, backup the existing file to a different location before overwriting it with the new file.
- Start the GoAnywhere service/subsystem
- Now create a resource using the pre-listed driver SQL Server com.microsoft.sqlserver.jdbc.SQLServerDriver, which will use the new driver we have copied in step 8.
NOTE: The new driver also works with SQL Server 2005 and SQL Server 2000.