Artifactory Microsoft SQL Server Configuration

Configure JFrog Artifactory to connect to an external Microsoft SQL Server database by installing the JDBC driver and updating the system.yaml database settings.

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 system.yaml configuration file. 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

Updated 7 days ago