Try JFrog
Guides
Contact SupportTry JFrog
  1. Configurations
  2. Database Configuration
  3. Microsoft SQL Server for Artifactory

Artifactory Microsoft SQL Server Database Creation

Create the SQL Server artifactory database and login in Management Studio, setting Latin1_General_CS_AI collation required by JFrog Artifactory.

  1. In Microsoft SQL Server Management Studio, open the Object Explorer, right click Security and select New | Login.... Create a new user named artifactory and set its password.
📘

Note

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

  1. Open the Object Explorer, right click Databases and select New database.... The New Database dialog opens.

  2. 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

  3. Select Options in the Select a page: navigation pane. Set Collation to "Latin1_General_CS_AI".

📘

Select a Case-sensitive Collation

Microsoft SQL Database Server is not case-sensitive by default, but Artifactory is case-sensitive. Select a case-sensitive collation.

  1. Click OK to create the database.

    sqlServer_new_database_options.png

Updated 13 days ago