Supported Microsoft SQL Server Versions Artifactory supports Microsoft SQL Server 2012 and above. Create a new user for Artifactory: Only MSSQL users can be used in Create a user Select the Options page and set Collation to "Latin1_General_CS_AI". 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. Download and extract the
Microsoft JDBC Driver and copy the Permissions 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 Creating the Artifactory Microsoft SQL Server Database
In
Microsoft SQL Server Management Studio, open the Object Explorer, right click Security and select New | Login....system.yaml
/ db.properties
. artifactory
and set its password.
In Microsoft SQL Server Management Studio, open the Object Explorer, right click Databases and select New database...
Set Database name to "artifactory" and Owner to "artifactory" (the user name you created in step 2).
Then click OK to confirm.Configuring Artifactory to use Microsoft SQL Server
sqljdbc
jar
file into $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib
directorysystem.yaml
configuration file.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
For example