<< Click to Display Table of Contents >> Navigation:  Administration > Connection problems

If connection problems occur between the client and the MS-SQL server, the problem is usually due to the firewall settings.

By default, the MS-SQL server is installed with TCP/IP disabled during a new installation. You must enable TCP/IP using the SQL Server Configuration Manager.

We have developed a script that allows you to enable all the necessary firewall ports to allow clients to access the server.

Create a .bat file with the following content and run the script.

----------------------------------------------------------------------------------------------------------------------------------------------------

The script contains the following commands:

@echo ========= SQL Server ports ===================

@echo Enabling port 1433 for the SQL Server default instance

netsh firewall set portopening TCP 1433 "SQLServer"

@echo Enabling port 1434 for dedicated administrator connections

netsh firewall set portopening TCP 1434 "SQL Administrator Connection"

@echo Enabling port 4022 for the conventional SQL Server Service Broker  

netsh firewall set portopening TCP 4022 "SQL Service Broker"

@echo Enabling port 135 for Transact-SQL debugger/RPC

netsh firewall set portopening TCP 135 "SQL Debugger/RPC"

@echo ========= Ports for analysis services ==============

@echo Enabling port 2383 for the SSAS default instance

netsh firewall set portopening TCP 2383 "Analysis Services"

@echo Enabling port 2382 for SQL Server Browser Service

netsh firewall set portopening TCP 2382 "SQL Browser"

@echo ========= Various applications ==============

@echo Enabling port 80 for HTTP

netsh firewall set portopening TCP 80 "HTTP"

@echo Enabling port 443 for SSL

netsh firewall set portopening TCP 443 "SSL"

@echo Enabling the port for the 'Browse' button of the SQL Server Browser service

netsh firewall set portopening UDP 1434 "SQL Browser"

@echo Allowing multicast/broadcast response on UDP (browser services enumeration OK)

netsh firewall set multicastbroadcastresponse ENABLE

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

To execute these commands, run the setports.bat file on your server. This will enable all of the ports described.

If connection problems persist, you will need to enter exceptions in your firewall (incoming and outgoing). The paths may vary depending on your operating system and installation. On Windows 10, they are:

•C:\Program Files (x86)\microsoft sql server\mssql.1\mssql\binn\sqlservr.exe

•C:\Program Files (x86)\microsoft sql server\90\shared\sqlbrowser.exe

•C:\Program Files (x86)\microsoft sql server\90\shared\sqlwriter.exe

The connection between the server and client should now be working. If you are still experiencing problems, domain settings may be preventing access.