Using the latest version?
JFrog Platform User Guide
JFrog Artifactory 6.x Documentation
To get the latest version, go to the JFrog Unified Platform
Creating the Artifactory Microsoft SQL Server Database
Supported Microsoft SQL Server Versions
Artifactory supports Microsoft SQL Server 2008 and above.
- Create a new user for Artifactory:
In Microsoft SQL Server Management Studio, open the Object Explorer, right click on Security and select New | Login....
Create user "artifactory" and set its password.
- Create the Artifactory database:
In Microsoft SQL Server Management Studio, open the Object Explorer, right click on 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
- Copy
$ARTIFACTORY_HOME/misc/db/mssql.properties
to$ARTIFACTORY_HOME/etc/db.properties
.
For a full explanation on the contents of this file please refer to The Bundled Storage Configurations. 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.
For example:Configuring the Database URL and user/passwordurl=jdbc:sqlserver://hostname:1433;databaseName=dbname;sendStringParametersAsUnicode=false;applicationName=Artifactory Binary Repository
Where
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.sendStringParameterAsUnicode
Make sure not to overwrite
sendStringParametersAsUnicode=false
since this is critical for appropriate and efficient use of the database indices.Download and extract the Microsoft JDBC Driver 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)
For example$TOMCAT_HOME/lib
when installed as a service or$ARTIFACTORY_HOME/tomcat/lib
in the standalone version.Permissions
Make sure your driver has the same permissions as the rest of the files in the shared lib directory.
- Start Artifactory.