Creating the Artifactory Microsoft SQL Server Database
Supported Microsoft SQL Server Versions
Artifactory supports Microsoft SQL Server 2012 and above.
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
.Create a user
artifactory
and set its password.- Create the Artifactory database:
In Microsoft SQL Server Management Studio, open the Object Explorer, right click 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
Download and extract the Microsoft JDBC Driver and copy the
sqljdbc
jar
file into$JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib
directoryPermissions
Make sure your driver has the same permissions as the rest of the files in the $JFROG_HOME/artifactory/var directory.
Adjust the database connection details in the
system.yaml
configuration file.For exampleshared: 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