Versions Compared

Old Version 25

changes.mady.by.user Former user

Saved on

compared with

New Version 26

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

...

  1. Log in with the admin user and create USER [username] from EXTERNAL PROVIDER; on the database you use.

  2. Add ddladmin, datawriter, and datareader roles for checking the status and Deploy Packager processes:
    EXEC sp_addrolemember 'db_ddladmin', 'datical_user';
    EXEC sp_addrolemember 'db_datawriter', 'datical_user';
    EXEC sp_addrolemember 'db_datareader', 'datical_user';

  3. Install the SQL Server JDBC Driver Authentication Library - mssql-jdbc_auth-<version>-<arch>.dll file on your machine. The file is located in the <datical-install>\DaticalDB\plugins\ directory.

    1. Copy com.datical.db.drivers.mssql_1.x.x.jar to a temporary directory and unzip it (<unzip directory>). 

    2. On Windows systems you can:

      o Use <java-install-path>\JAVA\jar.exe xf <name>.jar

      o Change the extension of the file from .jar to .zip and then unzip it.

    3. Go to <unzip directory>\auth\, then go to the folder for your version of the Java Virtual Machine (JVM). 

  4. Put the mssql-jdbc_auth-<version>-<arch>.dll file in \Windows\System32. There are 32-bit and 64-bit versions of the .dll file included with the Microsoft SQL Server JDBC driver. For example: mssql-jdbc_auth-8.4.1.x64.dll.

...