How do I connect to a remote Microsoft SQL Server?

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Body

As title suggests. How do I connect to a remote MS SQL Server, hosted in another state?

I have a server URL & port, database name, and login, and password, all correct.

My company wants me to try to connect to this and query it, but every single "guide" I've found on the internet just wants me to set up a local SQL Server, I have found ZERO info on how to connect to one that is not on my local machine.

I know this is probably bare bones basic, but how do I do this?

What programs do I need, etc? (currently have MSSM18 & SQL Server 2019)

I am so lost, I have tons of experience with MongoDB, but very limited with SQL. Just a nudge in the right direction would help immensely

Author

Account Strength

50%

Account Age

2 years

Verified Email

Yes

Verified Flair

Total Karma

n/a

Link Karma

Comment Karma

n/a

Profile updated: 6 days ago

Posts updated: 6 months ago

OnlyAFather

Subreddit

r/learnSQL

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 2 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/learnSQL/co...