Microsoft SQL Server

Creating the Artifactory Microsoft SQL Server Database

1. 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 system.yaml / db.properties. 

2. Create a user artifactory and set its password.

   

3. Create the Artifactory database: 
   In Microsoft SQL Server Management Studio, open the Object Explorer, right click 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. Download and extract the  Microsoft JDBC Driver and copy the sqljdbc jar file into $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib directory
   

   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 the Artifactory System YAML.

   For example

   shared:
     database:
       type: mssql
       driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
       url: jdbc:sqlserver://<your db server url, for example: localhost:1433>;databaseName=artifactory;sendStringParametersAsUnicode=false;applicationName=Artifactory Binary Repository
       username: artifactory
       password: password