Hello everyone! I'm having a tough time getting my Redmine container to connect to a SQL Server that's running on my Windows machine. I'm using the following Docker command to run the container:
docker run -d --name redmine-sqlserver -p 8090:3000
-e REDMINE_DB_SQLSERVER=192.168.1.16
-e REDMINE_DB_PORT=1433
-e REDMINE_DB_DATABASE=redmine
-e REDMINE_PLUGINS_MIGRATE=1
-e REDMINE_DB_USERNAME=aselsan
-e REDMINE_DB_PASSWORD=xxxxxxxxxxxxxx
neydju/redmine:v2
I've checked everything – firewall settings, SQL Server security, and I can connect to SQL Server using SSMS without issues. The connection works fine when I switch to a MySQL database, but with SQL Server, the container doesn't seem to connect at all. I'm really at a loss here!
4 Answers
What setup are you using? If your SQL Server runs directly on Windows (especially if you're using Docker Desktop or WSL), be mindful that network connections can sometimes be tricky. Loopback connections may fail. A cleaner approach might be running Docker in a Linux VM, like Debian, which simplifies access.
Is your container actually starting up without problems? If it is, check the logs – those might give clues as to why it can't connect to the SQL Server. If you don't see anything indicating a SQL timeout or an error, it might be defaulting to the built-in SQLite database instead, which could be the reason you’re not seeing any connections.
Yes, the container starts fine, and I can access my app. The logs show general activity with no SQL Server-related messages.
It looks like your host port mapping is a bit confusing. You’re mapping port 8090 (host) to 3000 (container), but SQL Server runs on port 1433. Ensure that the application inside the container tries to connect using the right port. Check that it points to the SQL Server database correctly and is using the same IP you're trying to access externally.
Just to clarify, your database connection should still be routed through 192.168.1.16:1433 and not be influenced by the web app's port mapping. Make sure the configuration is actually directing traffic to the SQL Server.
Are you sure your container is on the same network as your SQL Server? Sometimes, Docker containers run in their own isolated network environment. Check that other services can access the SQL Server's IP and port from the container and ensure they're allowed through any firewalls.
It seems like your MySQL setup works, but that might be due to different network settings. Consider using Docker’s network features to confirm your container can access your SQL Server.
Is there a straightforward way to initiate a TCP connection to the database on port 1433 from within the container? I’m looking for command suggestions.