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 SchneiderCo-OwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
McKnifeCommented:
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?
0
Bob SchneiderCo-OwnerAuthor 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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.