We help IT Professionals succeed at work.
Get Started

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

Last Modified: 2015-10-25
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.
Watch Question
Lead Technical Consultant
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE