Configure Artifactory to use Microsoft SQL Server

JFrog Installation & Setup Documentation

Content Type
Installation & Setup
ft:sourceType
Paligo
  1. Download and extract the Microsoft JDBC Driver and copy the sqljdbc jar file into $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib directory

    Permissions

    Make sure your driver has the same permissions as the rest of the files in the $JFROG_HOME/artifactory/var directory.

  2. Adjust the database connection details in the Artifactory System YAML.

    For example

    shared:
      database:
        allowNonPostgresql: true
        type: mssql
        driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
        url: jdbc:sqlserver://<your db server url, for example: localhost:1433>;databaseName=artifactory;sendStringParametersAsUnicode=false;applicationName=Artifactory Binary Repository
        username: artifactory
        password: password