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