Configure Artifactory to use Microsoft SQL Server

Download and extract the Microsoft JDBC Driver and copy the sqljdbc jar file to the following directory. Assign the driver the same permissions as the other files in the directory:

$JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib

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