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

[arminatwork]

@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