Blog

How to configure Artifactory with SqlServer and Integrated Authentication

Posted on April 13, 2016

I have created my first short video on how to configure Artifactory with SqlServer and Integrated Authentication.

I hope to be able to produce more videos like this in the future.

 

Below the video, you will find the same guide in a step-by-step print out.

 

 

Guide for migrating Artifactory metadata storage from Derby to SqlServer with integrated authentication

  • Make a full backup of the entire %artifactory_home% directory
  • Export system and repositories through the Artifactory admin interface
  • Stop the service
  • Make sure the Artifactory service account is created as a user in the SQL database.
  • Create a database with the newly created sql user as db-owner – Latin1_general_CS_AI
  • Download the MSJDBC driver (http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774) and extract it
  • Copy the sqljdbc42.jar file from extracted files to %artifactory_home%\tomcat\lib
  • Copy the sqljdbc_auth.dll from extracted files to %windows%\system32
  • Open %artifactory_home%\etc\storage.properties
    • Copy settings from %artifactory_home%\misc\db\mssql.properties
      • type=mssql
      • driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
      • url=jdbc:sqlserver://localhost:1433;databaseName=artifactory;sendStringParametersAsUnicode=false;applicationName=Artifactory Binary Repository
    • Don’t copy username and password settings
    • Adjust the connection string to point to your SqlServer instance
    • Add “;integratedSecurity=true” to the connectionstring
  • Delete %artifactory_home%\data folder
  • Start the service
  • Import system
  • Import repositories

 

Happy artifactoring

Categories: DevOps, Video

Tags: , , ,