MSSQL connection to Ms SQL Server Management Studio instructions

ddsnaHOBBY

7 months ago

Hi!
I can't seem to connect to the mssql database using the tool from microsoft. I took the public proxy port and address from the variables + used the sa user + the sa password and left the certificate optional. Can you help me login to the server?

0 Replies

ddsnaHOBBY

7 months ago

f3f3aa54-1f32-4a2a-9e9a-61d26191712d


6 months ago

what error are you getting?


ddsnaHOBBY

6 months ago

Connection string error


6 months ago

do you give me permission to attempt the connection myself?


ddsnaHOBBY

6 months ago

Go for it, the database is empty since I never accessed it


ddsnaHOBBY

6 months ago

I hope it's a typo on my end or something


6 months ago

i can connect just fine with dbgate


6 months ago

1302331048839090200


ddsnaHOBBY

6 months ago

Hmm


ddsnaHOBBY

6 months ago

Interesting, never used the tool before, only used mssql sms for mssql


6 months ago

you don't need to use it, it just means that there's no issues with the database or connection


ddsnaHOBBY

6 months ago

I've tried using azure data studio as well with no success


ddsnaHOBBY

6 months ago

hmm


6 months ago

it's something


ddsnaHOBBY

6 months ago

there's nothng special about the image, is there?


ddsnaHOBBY

6 months ago

it's just a barebones mssql image


6 months ago

correct


6 months ago

this isn't anything on the railway side of things


ddsnaHOBBY

6 months ago

It seems like the template has a 30% success rate, am i reading it right?


ddsnaHOBBY

6 months ago

let me give you a ss so you on't have to dig for what i'm talking about


6 months ago

yes because trial users attempt to deploy it not knowing that you need hobby to run it


ddsnaHOBBY

6 months ago

1302361021188538600


ddsnaHOBBY

6 months ago

ooooh, okay
so it's not something like "template needs perfecting" it might in fact be readable as "templates not used right"?


6 months ago

it could be either, but in this case it is the latter


ddsnaHOBBY

6 months ago

Hey Brody


ddsnaHOBBY

6 months ago

here: some extra nugget of information you can come back to


ddsnaHOBBY

6 months ago

It's the fact that SSMS (the official tool) is unable to parse ports at GUI data entry for servers. So you can't do server:port, you have to go to the tab Additional Connection Parameters and write it like this:
Data Source=yourrlwypublicaddres.proxy.rlwy.net,YourPortNumberNoQuotes;


ddsnaHOBBY

6 months ago

Anything written there overrides the info you write in the default server connection tab


ddsnaHOBBY

6 months ago

However, one must select mandatory encryption and most likely also check the field "trust server certificate" in the first tab


6 months ago

so you got it to connect?


ddsnaHOBBY

6 months ago

Yeah, with a bit more fiddling than expected on microsoft's side


ddsnaHOBBY

6 months ago

Turns out this is a universal piece of info you can pass to other sufferers of Microsoft unique software design


ddsnaHOBBY

6 months ago

it's always the formula: server,port if you have a non-default port for their services


MSSQL connection to Ms SQL Server Management Studio instructions - Railway Help Station