mssql-jdbc_auth-8.2.0.x64.dll (when using Windows authentication)
Driver version
Microsoft JDBC Driver 8.2 for SQL Server
How to get library
Download Microsoft JDBC Driver 8.2 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-US/download/details.aspx?id=100855).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy mssql-jdbc-8.2.0.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2019_adapter directory.
When you use Windows authentication, copy mssql-jdbc_auth-8.2.0.x64.dll to a directory included in Windows system paths of the computer where the JDBC driver is installed.
Start DataSpiderServer and DataSpider Studio.
SQL Server 2017 JDBC Adapter
Required library
mssql-jdbc-6.2.2.jre8.jar
sqljdbc_auth.dll (when using Windows authentication)
Driver version
Microsoft JDBC Driver 6.2 for SQL Server
How to get library
Download Microsoft JDBC Driver 6.2 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-US/download/details.aspx?id=55539).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy mssql-jdbc-6.2.2.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2017_adapter directory.
When you use Windows authentication, copy sqljdbc_auth.dll to a directory included in Windows system paths of the computer where the JDBC driver is installed.
Start DataSpiderServer and DataSpider Studio.
SQL Server 2016 JDBC Adapter
Required library
sqljdbc42.jar
sqljdbc_auth.dll (when using Windows authentication)
Driver version
Microsoft JDBC Driver 6.0 for SQL Server
How to get library
Download Microsoft JDBC Driver 6.0 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-us/download/details.aspx?id=11774).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy sqljdbc42.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2016_adapter directory.
When you use Windows authentication, copy sqljdbc_auth.dll to a directory included in Windows system paths of the computer where the JDBC driver is installed.
Start DataSpiderServer and DataSpider Studio.
SQL Server 2014 JDBC Adapter
Required library
sqljdbc42.jar
sqljdbc_auth.dll (when using Windows authentication)
Driver version
Microsoft JDBC Driver 6.0 for SQL Server
How to get library
Download Microsoft JDBC Driver 6.0 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-us/download/details.aspx?id=11774).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy sqljdbc42.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2014_adapter directory.
When you use Windows authentication, copy sqljdbc_auth.dll to a directory included in Windows system paths of the computer where the JDBC driver is installed.
Start DataSpiderServer and DataSpider Studio.
SQL Server 2012 JDBC Adapter
Required library
sqljdbc42.jar
sqljdbc_auth.dll (when using Windows authentication)
Driver version
Microsoft JDBC Driver 6.0 for SQL Server
How to get library
Download Microsoft JDBC Driver 6.0 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-us/download/details.aspx?id=11774).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy sqljdbc42.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2012_adapter directory.
When you use Windows authentication, copy sqljdbc_auth.dll to a directory included in Windows system paths of the computer where the JDBC driver is installed.
Start DataSpiderServer and DataSpider Studio.
SQL Server 2008 R2 JDBC Adapter
Sales and support for SQL Server 2008 R2 Adapter are finished.
Required library
sqljdbc42.jar
sqljdbc_auth.dll (when using Windows authentication)
Driver version
Microsoft JDBC Driver 6.0 for SQL Server
How to get library
Download Microsoft JDBC Driver 6.0 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-us/download/details.aspx?id=11774).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy sqljdbc42.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2008r2_adapter directory.
When you use Windows authentication, copy sqljdbc_auth.dll to a directory included in Windows system paths of the computer where the JDBC driver is installed.
Start DataSpiderServer and DataSpider Studio.
SQL Server 2008 JDBC Adapter
Sales and support for SQL Server 2008 Adapter are finished.
Required library
sqljdbc42.jar
sqljdbc_auth.dll (when using Windows authentication)
Driver version
Microsoft JDBC Driver 6.0 for SQL Server
How to get library
Download Microsoft JDBC Driver 6.0 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-us/download/details.aspx?id=11774).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy sqljdbc42.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2008_adapter directory.
When you use Windows authentication, copy sqljdbc_auth.dll to a directory included in Windows system paths of the computer where the JDBC driver is installed.
Start DataSpiderServer and DataSpider Studio.
SQL Server 2005 JDBC Adapter
Sales and support for SQL Server 2005 Adapter are finished.
Required library
sqljdbc4.jar
sqljdbc_auth.dll (when using Windows authentication)
Driver version
Microsoft JDBC Driver 4.0 for SQL Server
How to get library
Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-us/download/details.aspx?id=11774).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy sqljdbc4.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2005_adapter directory.
When you use Windows authentication, copy sqljdbc_auth.dll to a directory included in Windows system paths of the computer where the JDBC driver is installed.
Sales and support for SQL Server 2008 R2 Adapter are finished.