Create the Artifactory Microsoft SQL Server Database

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.

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

3. 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).

   

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

📘

Select a Case-sensitive Collation

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

2. Click OK to create the database.