Create the Artifactory Microsoft SQL Server Database

JFrog Installation & Setup Documentation

Content Type
Installation & Setup
ft:sourceType
Paligo
  1. Create a new user for Artifactory:

    In Microsoft SQL Server Management Studio, open the Object Explorer, right click Security and select New | Login....

    Note

    Only MSSQL users can be used in system.yaml / db.properties.

  2. Create a user artifactory and set its password.

    LoginProperties.png
  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).

    sqlServer_new_database.png
  5. Select the Options page and set Collation to "Latin1_General_CS_AI".

    Then click OK to confirm.

    sqlServer_new_database_options.png

    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.