SQL Server 2012 – How to Enable Remote Access

sql-server-2012

I have tried everything to be able to connect to my MS SQL Server 2012 remotely.
I have read and setup everything like Kyralessa wrote in his answer HERE.

  • Enable TCP/IP done
  • Add 1433 TCP Port done
  • enable SQL Server Browser done
  • Add 1433 TCP, 1434 UDP ports to Windows Firewall done
  • Add sqlserver.exe and sqlbrowser.exe to Windows Firewall done
  • Use ip address and port to connect done

I am still receiving an error message: Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attampt failed because the connected party did not properly respond after a period of time.

Nothing works
Do you maybe have any other solution I could try to solve this problem?

Best Answer

I have solved this problem with Port Forwarding.
I've seen no tutorial for Remote Access to SQL Server with this part.
So, setup 1433 TCP Port forwarding in your Router Settings and everything will work as it should.

Related Question