Connection string to a docker container in c#

Question

I need help in writing a connection string to connect to a SQL Server database which is running in a docker container.

It's a .NET app that needs to be connected, but initially I want to test the connections with the database I have on SQL Server on docker.

IDE being used is Riders, OS is Mac OS.

do you have any idea about what connection string will contain ?? — RJ-
– RJ-, Commented Oct 14, 2017 at 4:27
Yes, little bit as I am beginner. It needs server name, user name, pass word, port number and we can also mention a specific db name. — Bhavesh Injamara
– Bhavesh Injamara, Commented Oct 14, 2017 at 15:44

Raúl Martín Ramos · Accepted Answer · 2017-10-16 06:47:32Z

6

If your .NET app is running into docker in the same solution, you have to use the name of sql server container.

docker-compose.yml

sqlserver:
    image: 'microsoft/mssql-server-linux:2017-latest'
    container_name: sqlserver
    volumes:
      - 'mssql-server-linux-data:/var/opt/mssql/data'
    environment:
      - ACCEPT_EULA='Y'
      - SA_PASSWORD=xxxxxxxx
    ports:
      - '1433:1433'

Your connection string will be :

"ConnectionString": "Server=sqlserver;Database=xxxx;User Id=xx;Password=xxx;"

Otherwise, use in Server parameter the IP address for the computer hosting the container.

answered Oct 16, 2017 at 6:47

Raúl Martín Ramos

6647 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bhavesh Injamara Over a year ago

Hello @Raul Martin Ramos. Thank you for your help. However am running my app on my Mac and SQL server is on docker. In the visual studio(changed me IDE from previous) should I add the docker file above and connect it. Am a bit confused about all this process.

Raúl Martín Ramos Over a year ago

Hi Bhavesh, If docker is running in you mac machine, you should access by localhost. Example : var connection = new SqlConnection("Server=localhost;Database=xxxxx;User Id=xx;Password=xxxx;");

Collectives™ on Stack Overflow

Connection string to a docker container in c#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related