Allowing incoming connections on windows server 2012

Posted on 2014-08-30
Last Modified: 2014-08-30
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."
Question by:Bob Schneider
    LVL 77

    Accepted Solution

    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

    LVL 52

    Assisted Solution

    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?

    Author Comment

    by:Bob Schneider
    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 ( and my team training log (   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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Recently, I read that Microsoft has analysed statistics for their security intelligence report. It revealed: still, the clear majority of windows users do their daily work as administrator. An administrative account is a burden, security-wise. My ar…
    Container Orchestration platforms empower organizations to scale their apps at an exceptional rate. This is the reason numerous innovation-driven companies are moving apps to an appropriated datacenter wide platform that empowers them to scale at a …
    In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.
    This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now