KBEC-00351 - Configuring CloudBees CD (CloudBees Flow) Server With SQL Server Integrated Security

Summary

By default, the CloudBees CD (CloudBees Flow) server will connect to its configured database using a username and password as defined in database properties. Some sites may require that SQL Server use Windows Authentication mode exclusively. Here is how you can configure the CloudBees CD (CloudBees Flow) server to use integrated security to connect to such a database, using the CloudBees CD (CloudBees Flow) service user to authenticate rather than a defined username and password.

Solution

  1. Download the Microsoft JDBC driver.

  2. Find sqljdbc_auth.dll in the downloaded files, and place it in the \server\lib directory.

  3. In database configuration file \conf\database.properties, add your custom JDBC URL that connects using ISS by setting COMMANDER_CUSTOM_DB_URL with integratedSecurity\=true. For example:

    COMMANDER_CUSTOM_DB_URL=jdbc\:sqlserver\://localhost\:1433;databaseName\=commander;applicationName\=ElectricCommander;selectMethod\=direct;integratedSecurity\=true

  4. Restart the CloudBees CD (CloudBees Flow) server.

You will also need sqljdbc_auth.dll in the Java library path used to run any jar utilities that needs to authenticate to this database, such as CleanupStalledJob-jar-with-dependencies.jar.

Have more questions?

0 Comments

Please sign in to leave a comment.