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
-
Download the Microsoft JDBC driver.
-
Find sqljdbc_auth.dll in the downloaded files, and place it in the \server\lib directory.
-
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
-
Restart the CloudBees CD (CloudBees Flow) server.