How to get Keycloak to connect to MSSQL

In order to get Keycloak working with MSSQL, you need to configure the Keycloak Helm chart to use the MSSQL database. Here’s an example of how to do it:

value.yaml

postgresql:
  enabled: false

image:
  registry: harbor.mylab.lol
  repository: chainguard-private/keycloak-iamguarded
  pullPolicy: IfNotPresent

externalDatabase:
  host: "HOSTNAME_OF_SQL_SERVER"
  port: 1433
  database: "<DB_NAME>"
  user: "<SQL_USER>"
  password: "<PASSWORD>"

extraEnvVars:
  - name: KC_DB
    value: "mssql"
  - name: KC_DB_URL
    value: "jdbc:sqlserver://<HOSTNAME_OF_SQL_SERVER>:1433;databaseName=keycloak;encrypt=true;trustServerCertificate=true"
  - name: KC_DB_SCHEMA
    value: "dbo"
  #not required
  - name: KC_DB_POOL_MIN_SIZE
    value: "10"
  - name: KC_DB_POOL_MAX_SIZE
    value: "50"

auth:
  adminUser: admin
  adminPassword: "admin"

replicaCount: 1

production: false