Unable to connect to MSSQL container through TCP Proxy | Railway | Page 1

patent vessel Oct 3, 2023, 5:20 PM

#

I was able to build and run a SQL Server database through a Dockerfile, exposing the standard port and providing the proper build arguments but am unable to connect after setting up a TCP Proxy (since this is a Docker-based deployment and not a supported Database Service it doesn't have a connection string if I understand right).

The error I first receive when trying to connect from SQL Server Management Studio is:
Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

I also receive the error:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Framework Microsoft SqlClient Data Provider)

Is this a TLS issue? I've tried various combinations of encrypt and trust server certificate parameters but to no avail.

lament cairnBOT Oct 3, 2023, 5:20 PM

#

Project ID: 664eb8d7-2ff0-44d3-a9ab-537fd41b5746

glass waspBOT Oct 3, 2023, 5:20 PM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

patent vessel Oct 3, 2023, 5:20 PM

#

664eb8d7-2ff0-44d3-a9ab-537fd41b5746

brittle dome Oct 3, 2023, 10:08 PM

#

any reason for trying to deploy your own mysql service instead of railway's provided mysql template?

patent vessel Oct 4, 2023, 12:49 AM

#

MSSQL = SQL Server

#

If it was MySQL I would've absolutely gone with a template. I'm mostly trying to avoid the pain that is Azure.

brittle dome Oct 4, 2023, 12:53 AM

#

oh yeah sorry my bad

#

can you link me the docker image you are using to deploy a mssql server and I will see if I can get a template up and running for you

patent vessel Feb 11, 2024, 4:31 AM

#

Hi Brody, sorry I forgot about this! Here is my Dockerfile:

FROM mcr.microsoft.com/mssql/server:2019-latest

ARG ACCEPT_EULA
ARG MSSQL_SA_PASSWORD

# Default SQL Server TCP/Port.
EXPOSE 1433

# Run SQL Server process.
CMD [ "/opt/mssql/bin/sqlservr" ]

brittle dome Feb 11, 2024, 4:59 AM

#

does that run a windows based image?

patent vessel Feb 11, 2024, 11:10 AM

#

mcr.microsoft.com/mssql/server:2019-latest is an ubuntu-based image

#

https://hub.docker.com/_/microsoft-mssql-server

brittle dome Feb 11, 2024, 1:22 PM

#

I assume you do have the EULA and password variables set?

patent vessel Feb 11, 2024, 5:01 PM

#

Yes

brittle dome Feb 11, 2024, 5:02 PM

#

can you send the deployment logs for the service? https://bookmarklets.up.railway.app/log-downloader/

patent vessel Feb 11, 2024, 8:12 PM

#

📎 deployment_logs_railway-mssql_1707682323.log

patent vessel Feb 11, 2024, 9:30 PM

#

Connection Details

#

Error Message:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

brittle dome Feb 11, 2024, 9:38 PM

#

screenshot of the public networking section of your service settings please

patent vessel Feb 11, 2024, 9:48 PM

#

brittle dome Feb 11, 2024, 9:58 PM

#

I honestly have no clue, try the other ports in the logs 1434, 1431

patent vessel Feb 11, 2024, 10:29 PM

#

hmm you mean like EXPOSE those ports as well in the Dockerfile, as well as TCP proxy them, then try it?

brittle dome Feb 11, 2024, 10:32 PM

#

the expose keyword does absolutely nothing on railway, I'm talking about with the tcp proxy

patent vessel Feb 11, 2024, 10:55 PM

#

OK will give it a shot

brittle dome Feb 11, 2024, 10:56 PM

#

something else that just popped into my mind, are you perhaps on a public network? they could be blocking non standard ports such as 29343

patent vessel Feb 11, 2024, 10:57 PM

#

I'm at home, should be ok in that regard I think? 1433, 1434, 1431 all had the same error message

#

Error changes to:

The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following: the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

when changing connection parameter Encrypt to "strict"

brittle dome Feb 11, 2024, 11:01 PM

#

I'm back to being out of ideas 😦

patent vessel Feb 11, 2024, 11:07 PM

#

I don't see anything in the logs. Oh well, appreciate your help regardless. Was hoping to make this work to save some money and headache working with Azure.

brittle dome Feb 11, 2024, 11:09 PM

#

I'll give this a try myself when I'm home

brittle dome Feb 12, 2024, 3:49 PM

#

it worked!

patent vessel Feb 12, 2024, 4:45 PM

#

Nice! What did you do differently?

brittle dome Feb 12, 2024, 4:46 PM

#

uh idk, set the three variables the image wants and connected to it with dbgate

patent vessel Feb 12, 2024, 4:47 PM

#

I only set two, accept_eula and sa_password. Can you share your Dockerfile?

#

Looks like you used SQL server 2022 image?

brittle dome Feb 12, 2024, 4:48 PM

#

i dont use a dockerfile, but i did use the latest tag

#

#

#

if i where to use a dockerfile id use this

FROM mcr.microsoft.com/mssql/server:2019-latest

this would be the entire dockerfile, this one single line is all thats needed

patent vessel Feb 12, 2024, 4:49 PM

#

How did you not use a Dockerfile? Is Microsoft SQL a database option now? I think when I last tried this months ago it wasn't which is why I went with docker

brittle dome Feb 12, 2024, 4:50 PM

#

i deployed the image directly

patent vessel Feb 12, 2024, 4:50 PM

#

I'm guessing there is an option to do that when setting up a new project?

brittle dome Feb 12, 2024, 4:51 PM

#

no, the dashboard doesnt let you deploy an image from mcr, but thats besides the point

patent vessel Feb 12, 2024, 4:51 PM

#

Lol I don't follow. How do I go about recreating what you did?

brittle dome Feb 12, 2024, 4:52 PM

#

brittle dome if i where to use a dockerfile id use this ``` FROM mcr.microsoft.com/mssql/serv...

^

patent vessel Feb 12, 2024, 4:54 PM

#

But if I understand, you're saying you deployed an image directly but I can't do that bc it's an MCR image?

brittle dome Feb 12, 2024, 4:54 PM

#

correct

patent vessel Feb 12, 2024, 4:55 PM

#

What can I do differently? Add that third variable?

#

I can use latest tag as well, I'm not pinned to 2019

brittle dome Feb 12, 2024, 4:56 PM

#

brittle dome if i where to use a dockerfile id use this ``` FROM mcr.microsoft.com/mssql/serv...

2019 works fine

brittle dome Feb 12, 2024, 4:57 PM

#

patent vessel What can I do differently? Add that third variable?

are you using the dockerfile i provided?

patent vessel Feb 12, 2024, 4:57 PM

#

Are you thinking this is a networking thing on my end?

brittle dome Feb 12, 2024, 4:57 PM

#

not sure, try dbgate, its free

patent vessel Feb 12, 2024, 4:57 PM

#

I was using Azure Data Studio to test connection previously. I'll try dbgate

#

Alright I'll try the 1 line Dockerfile, add the missing variable you have, and connect w dbgate and get back to you

brittle dome Feb 12, 2024, 5:03 PM

#

i omitted the variable and it still worked for me

patent vessel Feb 12, 2024, 5:18 PM

#

Can I also try connecting to yours and see if it works?

brittle dome Feb 12, 2024, 5:18 PM

#

sure, but does that mean dbgate wasnt working for you either?

#

roundhouse.proxy.rlwy.net:39537
sa
MK$!Q5tr+LS#AZgeq6&HjFcz7Rkvma4h

patent vessel Feb 12, 2024, 5:19 PM

#

Haven't got to the computer yet

#

Starting it now

#

While installing dbgate I was able to connect with azure data studio to yours

brittle dome Feb 12, 2024, 5:24 PM

#

are you using the dockerfile I gave you?

patent vessel Feb 12, 2024, 5:25 PM

#

Yes, just updated the repo and railway redeployed

#

Aaaand I'm connected

#

The one-line Dockerfile vs my original was the difference

brittle dome Feb 12, 2024, 5:29 PM

#

awesome

patent vessel Feb 12, 2024, 5:37 PM

#

This could be big! Railway already hosts an API for an azure SQL DB that costs the local govt I work for hundreds a month.

#

If I can replace that DB and colocated it with the API on railway, thats a financial and security win to me

#

Thanks a bunch man, really appreciate your help

brittle dome Feb 12, 2024, 5:38 PM

#

if only railway supported deploying images directly from mcr

#

deploying a database from a repo just sounds ugly

#

even if its using the same image in the end

patent vessel Feb 12, 2024, 5:41 PM

#

Yeah I feel ya, a repo for one file with one line to create a DB haha

brittle dome Feb 12, 2024, 5:43 PM

#

but the dashboard only supports deploying images directly from dockerhub, ghcr, and quay

#Unable to connect to MSSQL container through TCP Proxy