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
.Create a user
artifactory
and set its password.Create the Artifactory database:
In Microsoft SQL Server Management Studio, open the Object Explorer, right click Databases and select New database...
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).
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.