Category : sql-server

just finish installing sql server 2019 alwaysOn on docker container. (references: https://dbtut.com/index.php/2020/06/09/sql-server-2019-alwayson-availability-group-on-docker-containers/ https://www.sqlservercentral.com/articles/sql-server-alwayson-with-docker-containers ). in the above references and others, they are not getting to the "listener" configuration point on docker containers. the question is: how to connect to SQL through listener on DOCKER environment? (how to configure it on docker) thanks Source: Docker..

Read more

I create my MSSQL database docker container with only docker-compose.yml file and setup.sql file. My .yml file looks like that: version: "3.7" services: sql-server-db: container_name: sql-server-db image: mcr.microsoft.com/mssql/server:2019-latest ports: – "1433:1433" environment: SA_PASSWORD: "secret123new!" ACCEPT_EULA: "Y" volumes: – ./data/mssql:/scripts/ command: – /bin/bash – -c – | # Launch MSSQL and send to background /opt/mssql/bin/sqlservr & ..

Read more

I have a problem with connection to MSSQL Docker database created from docker-compose.yml file and additional .sql file with ready-to-go empty database configuration. To connect to the MSSQL database i have used DBeaver. During the connection this error occured: Login failed for user ‘system’. ClientConnectionId:23649321-6526-4ec2-a6ed-9943e64ca019 Probably i have wrong docker-compose.yml file or wrong .sql configuration ..

Read more

I have docker-compose.yml file which has the following service: services: main_db: container_name: ${DB_CONTAINER_NAME} build: ./docker/main_db ports: – "1433:1433" volumes: – dbdata:/var/opt/mssql When I used the older MacBook Pro, I was able to use this docker-compose and I was able to run docker-compose –file docker-compose.yml up –detach –build –force-recreate in order to get all containers running. ..

Read more

I have a ASP.NET 5.0 Web API using Entity Framework to access SQL Server. Running (F5) from Visual Studio works fine. The connection string is Server=(localDB)MSSQLLocalDB;Database=***;Integrated Security=true I then add docker support. Now if I debug the app with the Docker profile I get a System.PlatformNotSupportedException: LocalDB is not supported on this platform. What should ..

Read more