Category : sql-server

Keycloak container is unable to establish connection to a remote SQL Server database and is stuck in a boot loop. Output from container logs: {"logs":"Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Certificates do not conform to algorithm constraints". ClientConnectionId:8c3fca80-a572-4014-abe0-6e55adf39c44 {"logs":"Caused ..

Read more

Started working with Docker images recently, and my main problem is that while my docker-compose can spin up the api, and the database I need, what it lacks is the actual scheme of the database that the entities within my API project look for when getting data. So I have a DbContext already, all the ..

Read more

I have a backup database file from sql windows server. And I run the sql docker image (mcr.microsoft.com/mssql/server:2017-latest). Now I want to restore this database from the file. I change the file path to match the linux image filesystem: But I got an error: Restore of database ‘B…a’ failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) System.Data.SqlClient.SqlError: The operating system returned ..

Read more

I download and use sql docker image from offical sql hub docker run -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=password’ -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-latest The command line say Unable to find image ‘mcr.microsoft.com/mssql/server:2017-latest’ locally 2017-latest: Pulling from mssql/server 07d362b67a1c: Pull complete 2897b7b360f2: Pull complete d9ca653e6fba: Pull complete 595653115183: Pull complete b3549553cbbf: Pull complete b877d94c9861: Pull complete 32ad42be7dae: Pull ..

Read more

I’m trying out apache airflow with the docker-compose using base container container apache/airflow:2.0.1. I’m following this tutorial https://airflow.apache.org/docs/apache-airflow/stable/start/docker.html# How do you run a simple query to get data from a SQL SERVER database? At this stage, I’d just like to see if it’s possible. I’ve tired to extend the image FROM apache/airflow:2.0.1 RUN pip install ..

Read more