Creating the Artifactory Microsoft SQL Server Database
Supported Microsoft SQL Server Versions
Artifactory supports Microsoft SQL Server 2012 and above.
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
Create a user
artifactoryand 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.
Configuring Artifactory to use Microsoft SQL Server
Download and extract the Microsoft JDBC Driver and copy the
Make sure your driver has the same permissions as the rest of the files in the $JFROG_HOME/artifactory/var directory.
Adjust the database connection details in the