Hi,
Can someone please help me solve my problem with getting MS Sql server to work as backend for keycloak, using the Quay docker image?
It works fine when trying with postgres, both locally and in azure.
This command below works fine with postgres backend, but no when i try with mssql.
docker run -p 8080:8080 --name kcsql -e KEYCLOAK_ADMIN=admin -e KEYCLOAK_ADMIN_PASSWORD=admin -e KC_DB=mssql -e KC_DB_URL=jdbc:sqlserver://mysql.database.windows.net:1433;database=keycloak -e KC_DB_USERNAME=keycloak -e KC_DB_PASSWORD=password quay.io/keycloak/keycloak:latest start-dev
I think I could solve it if someone could provide me the connection string for mssql found in:
/admin/master/console/#/master/providers
and under “connectionsJpa” you will find the connectionstring. If anyone can give me a clue to how this one looks like, it will be greatly appreciated.