Search code examples
sqlsql-serverconnectionremote-accessremote-debugging

SQL Server 2014 cannot connect to remote Server

Before I get flagged, I will say that I have tried everything that I could find, but I still cannot connect:

  • I have opened TCP Port (1433), Server is listening on ['any' < ipv4 > 1433].

  • I have enable the server browser service

  • I have enabled remote connections in my SQL server
  • I have also assigned the TCP port to the TCP protocol for sqlexpress here
  • I also tried tried to debug the connection using the NETSTAT.exe and it says the TCP 1433 is listening.
  • I have restarted the service several times when I try to connect from my local PC I get the following error

I can connect remotely to my server using IIS and url.

Question: What can I do to debug the connection between the devices?

Solution

  • For people that are interested in the question.

    I have fixed the issue, (by luck), so what I did I was playing around with the different kind of ports and I added a rule for range ports from

    1430 to 1440

    and that seemed to fix the problem. Check it out here

    Also for people that use Azure make sure to add a rule in the network security group.

    Thanks for the help