UNVERIFIED SOLUTION i
X

How To connect to a MSSQL ntegrated security DB using Spectrum.

UPDATED: July 27, 2017


Workaround for using native Microsoft JDBC driver:
  1. Stop the server.
  2. Copy all native lib (sqljdbc_auth.dll) needed for JDBC driver into: ../server/bin director.
  3. Copy all JDBC jar files (mssql-jdbc-6.2.0.jre8.jar) into: ../server/app/lib directory.
  4. Start the server.
  5. In Web MC create new JDBC driver with class name, connections string and any connections properties which is needed. Do don’t select any diver files, leave it empty. See screenshot below:
User-added image


http://support.pb.com/help/spectrum/12.0/webhelp/en/AdministrationGuide-WebUI/index.html#ClientTools/ConfiguringExternalResources/jdbc_adding_pre4x.html
 
  1. Start using the driver.

Environment Details

Product Feature:Spectrum Spatial


 

Downloads

  • No Downloads