JFrog

    JFrog Help Center

    Our new portal is coming soon!
    Documentation + Knowledge Base





    JFrog Help Center - A new knowledge experience is coming your way soon!


    Skip to end of metadata
    Go to start of metadata

    Overview

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

    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 inConfiguring the Database.

    Page Contents


    Creating the Artifactory Microsoft SQL Server Database

    Supported Microsoft SQL Server Versions

    Artifactory supports Microsoft SQL Server 2012 and above.


    1. Create a new user for Artifactory:
      InMicrosoft SQL Server Management Studio,打开Object Explorer, right click安全and selectNew | Login....

      Only MSSQL users can be used insystem.yaml/db.properties.

    2. Create a userartifactoryand set its password.

      Login Properties

    3. Create the Artifactory database:
      In Microsoft SQL Server Management Studio, open theObject Explorer, right clickDatabasesand selectNew database...
    4. In theNew Databasedialog window, selectGeneralin theSelect a page:navigation pane.
      SetDatabase nameto "artifactory" and老板to "artifactory" (the user name you created in step 2).


    5. Select theOptionspage and setCollationto "Latin1_General_CS_AI".
      然后clickOK来确认。

      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. Download and extract theMicrosoft JDBC Driverand copy thesqljdbcjarfileinto$JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/libdirectory

      Permissions

      Make sure your driver has the same permissions as the rest of the files in the $JFROG_HOME/artifactory/var directory.

    2. Adjust the database connection details in theArtifactory System YAML.

      For example 
      shared: database: type: mssql driver: com.microsoft.sqlserver.jdbc.SQLServerDriver url: jdbc:sqlserver://;databaseName=artifactory;sendStringParametersAsUnicode=false;applicationName=Artifactory Binary Repository username: artifactory password: password

    Copyright © 2023 JFrog Ltd.