Cloud customer?
Start for Free >
Upgrade in MyJFrog >
What's New in Cloud >


By using MicrosoftSQL, you can benefit from features in the Microsoft SQL Server infrastructure such as backup and restore.

Optimizing Artifactory when running with MS SQL Server

When running Artifactory with Microsoft SQL Server you may create the Artifactory schema on an existing server used for other applications, however for optimal performance, we recommend creating a dedicated Microsoft SQL Server database instance and then configure Artifactory to use it as described in the following sections.

Before You Continue

Before proceeding with the steps below, please make sure you have read and followed the steps described in Configuring the Database.

Page Contents

Creating the Artifactory Microsoft SQL Server Database

Supported Microsoft SQL Server Versions

Artifactory supports Microsoft SQL Server 2012 and above.

  1. Create a new user for Artifactory: 
    In  Microsoft SQL Server Management Studio, open the Object Explorer, right click Security and select New | Login....

    Only MSSQL users can be used in system.yaml /

  2. Create a user artifactory and set its password.

    Login Properties

  3. Create the Artifactory database: 
    In Microsoft SQL Server Management Studio, open the Object Explorer, right click Databases and select New database...
  4. In the New Database dialog window, select General in the Select a page: navigation pane. 
    Set Database name to "artifactory" and Owner to "artifactory" (the user name you created in step 2).

  5. Select the Options page and set Collation to "Latin1_General_CS_AI". 
    Then click OK to confirm.

    Selecting a Case-sensitive Collation

    While Microsoft SQL Database Server is not case-sensitive by default, it is important to select a case-sensitive collation because Artifactory is case-sensitive.

Configuring Artifactory to use Microsoft SQL Server

  1. Download and extract the  Microsoft JDBC Driver and copy the sqljdbc jar file into $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib directory


    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
        type: mssql
        url: jdbc:sqlserver://<your db server url, for example: localhost:1433>;databaseName=artifactory;sendStringParametersAsUnicode=false;applicationName=Artifactory Binary Repository
        username: artifactory
        password: password

Copyright © 2022 JFrog Ltd.