I'm trying to connect to my MS SQL SERVER Express 2012 database, which lives on my remote server. Everything is set up and configured correctly other than the Firewall. This is the first time I've done this with SQL 2012 and W2012 server.
Reading multiple posts here on SU and the MS sites, shows that I need allow port 1433 (TCP). I have done this.
When I try to connect to my remote server, I get a fairly common error message
Error 26 - Error locating server/instance specified
If I then disable the public profile on my Windows Firewall on my W2012 server, I can connect fine. This proves the issue is with the ports some where.
What other ports do I need to open / what else do I need to do?
I have enable Named Pipes and TCP/IP.