Artifactory 3.x
Page tree
Skip to end of metadata
Go to start of metadata

Overview

By using Microsoft SQL you can benefit from features in the Microsoft SQL Server infrastructure such as backup, restore and high availability.

Optimizing Artifactory when running with MS SQL Server

When running Artifactory with Microsoft SQL Server you may create the Artifactory schema on an existing server used for other applications, however for optimal performance, we recommend creating a dedicated Microsoft SQL Server database instance and then configure Artifactory to use it as described in the following sections.

Before You Continue

Before proceeding with the steps below, please make sure you have read and followed the steps described in Changing the Default Storage.

Page Contents

 

Creating the Artifactory Microsoft SQL Server Database

Supported Microsoft SQL Server Versions

Artifactory supports Microsoft SQL Server 2008 and above.

 

  1. Create a new user for Artifactory: 
    In  Microsoft SQL Server Management Studio, open the Object Explorer, right click on Security and select New | Login....
     

  2. Create user "artifactory" and set its password.

    Login Properties

  3. Create the Artifactory database: 
    In Microsoft SQL Server Management Studio, open the Object Explorer, right click on Databases and select New database...
     
  4. 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).


  5. 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

  1. Copy $ARTIFACTORY_HOME/misc/db/mssql.properties to $ARTIFACTORY_HOME/etc/storage.properties
    (If you do not have this file you can take it from the standalone zip distribution or directly from the JFrog domain). For a full explanation on the contents of this file please refer to The Bundled Storage Configurations.

  2. Adjust the connection definitions in the $ARTIFACTORY_HOME/etc/storage.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/password
    url=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.


  3. Download and extract the  Microsoft JDBC Driver and copy the sqljdbc4.jar file into the server's shared lib directory.
    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.



  4. Start Artifactory.