.net Core Web Api Application Cannot Connect To Sql Server Running On Docker

Using MAC. Error (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server). Connection string 'Data Source=localhost,1433;Initial Catalog=MyDatabase;Integrate

Solution 1:

Reference the container by name. You could do something like this

sql-data:
   environment:
      - SA_PASSWORD=Pass@word
      - ACCEPT_EULA=Y
    ports:
      - "5433:1433" # Important: In a production environment, you should be using a managed service



- ConnectionStrings__DefaultConnection=Server=sql-data;Database=MyDatabase;User Id=sa;Password=MyPassword;MultipleActiveResultSets=true