SQl server Database is not connected using docker compose

[viralchauhan]

I am trying last 3 days sql server database connectivity not work

compose file below

orderdb: container_name: orderdb environment: SA_PASSWORD: "SwN12345678" ACCEPT_EULA: "Y" restart: always ports: - "1433:1433"

ordering.api: container_name: ordering.api environment: - ASPNETCORE_ENVIRONMENT=Development - "ConnectionStrings:OrderingConnectionString=Server=orderdb;Database=OrderDb;User Id=sa;Password=SwN12345678"
- "EventBusSettings:HostAddress=amqp://guest:guest@rabbitmq:5672" - "ElasticConfiguration:Uri=http://elasticsearch:9200" depends_on: - orderdb - rabbitmq ports: - "8004:80"

I have not use entity framework I am using dapper

I have check API connection string is "Server=orderdb;Database=OrderDb;User Id=sa;Password=SwN12345678"

error given is docker-compose database container file Login failed for user 'sa'. Reason: Failed to open the explicitly specified database 'OrderDb'. [CLIENT: 172.20.0.3]

How to fix this issues

I have try to remove orderdb and try this host.docker.internal,1433 working fine so how to multicontainer setup

[armintodev]

@viralchauhan I think you need to create a network bridge. see my last issue about Ocelot's and docker-compose configurations. you will figure it out