We help IT Professionals succeed at work.
Get Started

Client PCs takes ages to load the SQL server base application with Firewall enabled on the SQL Server

361 Views
Last Modified: 2014-08-23
Hi
I have completed installing SQL server as per Microsoft BPA and I handed over the server to the Software vendor to install an application on our SQL server and they have completed installing it.

We install a client program on the Client PCs to connect to our SQL database server. I opened inbound UDP port 1434 for SQL browser and TCP port  1433 for the SQL Server on the firewall. Also I applied an inbound rule by choosing the program and giving the path to the E:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\Binn\sqlservr.exe.

I have a problem with clients connecting to the SQL server.
With the firewall enabled on the SQL Application server the clients are taking 2 minutes to load the application. If I disable the firewall on the SQL server the clients take 6-8 seconds to load application (which is really good)
 
I did some investigation on the server and the client.
1)      Firstly- I enable the firewall on the SQL server. I went to the client and opened the application and it opened after 2 minutes and within the client there is tab “Test server connection” when I click this it says  “server not working”
( In this scenario the clients takes 2 minutes to load the application)
 
 2)  Secondly- I disabled the firewall on the SQL server. I went to the client and there is tab “Test server connection” when I click this it says “Server Ok”
(In this scenario the clients takes only 6-8 seconds to load the application.
 
I don’t know where this bottle neck is happening when the firewall is enabled on the SQL server. Is there any third party software to find this bottle neck\Is there any other port that I need to open on the SQL server firewall?

Please suggest any help to trouble shoot much appreciated

Thanks in advance.
Comment
Watch Question
IT Engineering Manager
CERTIFIED EXPERT
Top Expert 2009
Commented:
This problem has been solved!
Unlock 9 Answers and 16 Comments.
See Answers
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