Artifactory supports Microsoft SQL Server 2008 and above.
Create user "artifactory" and set its password.
Select the Options page and set Collation to "Latin1_General_CS_AI".
Then click OK to confirm.
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.
Adjust the connection definitions in the
$ARTIFACTORY_HOME/etc/db.properties file to match the attributes of the Artifactory database you created.
You must configure the database URL and username/password to use. The schema and tables are created first time Artifactory is run using the new database.
url=jdbc:sqlserver://hostname:1433;databaseName=dbname;sendStringParametersAsUnicode=false;applicationName=Artifactory Binary Repository
hostname is your database address,
1433 is your database port (if not the default 1433),
dbname is the name of the database you created in the previous step.
Make sure not to overwrite
Download and extract the and copy the
mssql-jdbc-7.2.2.jre<8/11>.jar file into the server's shared lib directory. (According to the used Java version)
$TOMCAT_HOME/lib when installed as a service or
$ARTIFACTORY_HOME/tomcat/lib in the standalone version.
Make sure your driver has the same permissions as the rest of the files in the shared lib directory.