Window Server Firewall and SQL Server -- Accessing from Windows 10 client

On my home network, I have the Windows Server (2012 R2) set up as a domain server and I have SQL Server (2014 developer edition)installed.  From my Windows 10 client machine, I am trying to connect to the SQL Server using Visual Studio 2013.  The Windows firewall on the server (and perhaps other factors) are causing problems.  

I will just try to go through the facts:

1.  If I turn off the server firewall, I can reach the SQL DB from SQL Management Studio or Visual Studio on the Win10 client, but performance is painfully slow if I use TCP as the protocol.
2.  When using named pipes, connecting to the DB server from SQL Management Studio on the client works fine and feels fast as expected.  
3.  Visual Studio does not have a protocol option so I can't use named pipes, it forces me to use TCP so it will only work with the firewall completely turned off and is slow (same as #1 above)
4.  Turning on the firewall blocks the connection, even though I believe I have all the appropriate ports opened (I'm sure I've missed something but I'm open to ideas)
5.  When I ping the server from the client, I get <1ms as expected, but it shows the address as a hex address rather than an IP address.
6.  I'm able to reach the hard disk of the server from the client with \\MYSERVER\c$ without problem and with good performance
7.  I am trying to connect from the client using SQL Server authentication (the sa account and the password), the client is not logged into a domain account.

Can anyone help?  I want to leave the firewall on the server on, but be still able to connect with Visual Studio (no named pipes) and with decent performance.  I am not an experienced at server administration at all, my focus is development, so there's lots I don't know here.

Thanks for any help you can provide.
LVL 3
pragmatistMSAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Ganesh Kumar ASr Infrastructure SpecialistCommented:
The windows firewall on Server 2012 does pretty good job. But in my experience i also have faced issues while the windows firewall is turned on. I have allowed port 1433 on the firewall and enabled the timed out on the SQL SERVER properties. Please refer this article : http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

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
pragmatistMSAuthor Commented:
Thanks for the link to the article, after I looked at the screenshot I went back and checked the protocols for MSSQLSERVER under SQL Server Network Configuration, and it showed TCP/IP as disabled.  After I enabled it, all seems to be working as expected with the firewall port rules I already had in place.  It is somewhat puzzling, first because I checked that property early on and it was enabled (not sure how it later became disabled), and also that it worked at all with the firewall off, even with reduced performance, if TCP was disabled before?  It seems to be working fine now, from all clients, so I'm happy to live with that mystery.

Thanks again for the response.
Ganesh Kumar ASr Infrastructure SpecialistCommented:
I am glad your issue is resolved.
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.