How to configure a remote connection with Microsoft SQL Server

Allow client remote access to Microsoft SQL Server 2016 database

[ChronoDegeneration]

I want you to know that I'd been trying to get this to work for three days straight surfing stack overflow, microsoft docs, and chatGPT and this video finally fixed it. Turns out I was using the wrong IP, so using IPconfig told me the IP that was actually listening since the one in SQL management studio was wrong. THANKS

[scientist]

I did this and tried with IP connection along with computer name, it worked but whenever I try to connect from another computer within the network (under the same domain of this domain controller) it fails; I have enabled this port and still fails, should I be setting something else or is this a permission issue within the domain controller not allowing external connections this way? The reason I say it may be a permission issue is because I get the generic "Access is Denied" but I'm using the Administrator user and I have tried the sa user which work on the local server machine. Please let me know as I have struggled to connect from another computer within the same domain and network. Thank you.

[rebelliouskazmi]

Sir in my sql configure management there is no TCP/IP protocol what should i do?

[xristinarose]

Connects from within my house (same network) but not from somewhere else. I have 2 instances of servers running. Not sure if that s the problem? Any solutions by chance?

[reardeltoit]

Thx for video. Can i connect a database on the host/remote server from my computer with this method ?