MSSQL connection to Ms SQL Server Management Studio instructions
ddsna
HOBBYOP

a year 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?

33 Replies

ddsna
HOBBYOP

a year ago

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


a year ago

what error are you getting?


ddsna
HOBBYOP

a year ago

Connection string error


a year ago

do you give me permission to attempt the connection myself?


ddsna
HOBBYOP

a year ago

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


ddsna
HOBBYOP

a year ago

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


a year ago

i can connect just fine with dbgate


a year ago

1302331048839090200


ddsna
HOBBYOP

a year ago

Hmm


ddsna
HOBBYOP

a year ago

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


a year ago

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


ddsna
HOBBYOP

a year ago

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


ddsna
HOBBYOP

a year ago

hmm


a year ago

it's something


ddsna
HOBBYOP

a year ago

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


ddsna
HOBBYOP

a year ago

it's just a barebones mssql image


a year ago

correct


a year ago

this isn't anything on the railway side of things


ddsna
HOBBYOP

a year ago

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


ddsna
HOBBYOP

a year ago

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


a year ago

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


ddsna
HOBBYOP

a year ago

1302361021188538600


ddsna
HOBBYOP

a year ago

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


a year ago

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


ddsna
HOBBYOP

a year ago

Hey Brody


ddsna
HOBBYOP

a year ago

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


ddsna
HOBBYOP

a year 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;


ddsna
HOBBYOP

a year ago

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


ddsna
HOBBYOP

a year ago

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


a year ago

so you got it to connect?


ddsna
HOBBYOP

a year ago

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


ddsna
HOBBYOP

a year ago

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


ddsna
HOBBYOP

a year ago

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


Loading...