Client PCs takes ages to load the SQL server base application with Firewall enabled on the SQL Server
Posted on 2014-08-07
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.