I'm trying to set up Rundeck to use MS SQL backend with Windows Integrated Authentication. The service is running on Windows with an AD service account.
I have the following properties set in my rundec-config.properties:
dataSource.driverClassName = com.microsoft.sqlserver.jdbc.SQLServerDriver
dataSource.url = jdbc:sqlserver://hostname.domain.local;DatabaseName=Rundeck
When I start Rundeck it fails to log in as sa. I want it to use the service account credentials it runs as. Is that possible?
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:98bbc124-7656-4f2f-963a-1ed675089b5d