I've searched for the solution for this problem for days now, found a lot of stuff but none of it worked.
I've got an SQL Server 2012 running on Windows Server 2012. I'm trying to connect to the SQL Server from a client computer remotely (with internet IP), and I keep getting the message 'No connection could be made because the target machine actively refused it.
- I can connect locally.
- I opened ports 1433 and 1434 in my firewall
- I forwarded these ports in my router
- I tried turning the firewall off
- I enabled TCP/IP and set the static port to 1433
I STILL cannot connect externally.
Any ideas? I'm at a dead end here.