[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1621
  • Last Modified:

Allowing incoming connections on windows server 2012

I have no idea how to do this.  I have never had to before.  Here is what my provider said:

"Lastly, your SQL server is setup to allow remote connections ,but your firewall isn't. You'll need to ensure that the firewall is setup to accept inbound connections to port 1433 (and port 1434 if you wish to use a named instance). Currently, I see no rule specified for this port and this would be why your remote connection isn't working."
Bob Schneider
Bob Schneider
2 Solutions
David Johnson, CD, MVPOwnerCommented:
You might want to view my video on youtube that addresses this
or run the following from an elevated command prompt
netsh advfirewall firewall add rule name="Ports for SQL Server Browser Service" dir=in action=allow localport=1434 protocol=UDP

Open in new window

netsh advfirewall firewall add rule name="Ports for Sql Server" dir=in action=allow localport=1434 protocol=TCP

Open in new window

Are you in charge of administering that server? If so - you have NO idea? This can't be.
You should at least know what firewall is used on the system and eventually on the network and where to adjust those. If not, please ask your network admin. Following advice here blindly is the worst you can do from a security standpoint. For example you could of course follow the above advice from David, but:
-is that firewall even in use?
-do you really want to open it to all IPs?
-ain't there another external firewall?
Bob SchneiderAuthor Commented:
I couldn't agree more...but the bottom line is I am a very small entrepreneur and I can't afford a managed server.  I simply need a web/data server to manage my event timing services (http://www.gopherstateevents.com) and my team training log (http://www.etraxc.com).   So I pay the subscription fee for Experts Exchange to help me do it and it has served me well.  

Now if I can just allow incoming connections for asp classic websites with vb6 I will be back where I left off on the old server.  Things went well for about 12 years until I had to move to a new server because it is a lot less expensive.

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now