top of page

eCertrack/iFastrack SQL Firewall and Port Config

Microsoft SQL Server ports

Ports and protocols used by Microsoft SQL Server database engine (SQLServer).

​

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. It is the primary data store for eCertrack and iFastrack software applications. You need to allow remote users to connect to the SQL server.

​

Note: The first step of this procedure is sufficient in most cases. Go through the other steps if you encounter any issue.​

Procedure

Microsoft SQL Server by default uses TCP 1433.

Microsoft SQL Server Express uses Dynamic TCP (can be any port it chooses)

​

This can be changed using SQL Server Enterprise Manager or the database Management Studio.

  1. ​Enable remote connections to your SQL Server.

    1. Open SQL Server Management Studio.

    2. Right-click your server's name and select Properties.

    3. Tick the checkbox Allow remote connections to this server.

    4. Select OK.

  2. Enable TCP/IP.

    1. Open the SQL Server Configuration Manager.

    2. In SQL Server Network Configuration select Protocols for [yourServerInstance].

    3. In the right-hand pane, make sure that TCP/IP is Enabled.

  3. Configure SQL to use TCP 1433 (if set to dynamic, ie; SQL Express)

    1. In SQL Server Network Configuration, expand ​"Sql Server Network Configuration Node"

    2. Select Protocols for [yourServerInstance]

    3. In right pane, Right-Click TCP/IP and select Properties

    4. Select IP Address tab

    5. Delete All TCP Dynamic Ports fields

    6. Set All TCP Port fields to 1433

    7. Click Ok

    8. Select Sql Server Services

    9. In right pane, right click SQL Server (yourServerInstance} and select Restart

  4. ​Open the 1433 port in your firewall.

    1. Display the firewall advanced settings by navigating to Control Panel > System and Security > Windows Firewall > Advanced settings.

    2. Select Inbound Rules in the left-hand pane, then click New Rule in the right-hand pane.

    3. In the New Inbound Rule Wizard, Rule Type step, select Port.

    4. Protocols and Ports step, select TCP and set Specific local ports to 1433.

    5. Action step, select Allow the connection.

    6. Profile step, tick the Domain checkbox.

    7. Name step, enter a name for this rule, e.g. SQL Server port 1433.

    8. Select Finish

  5. If you are using a named instance, create an extra rule in your firewall with the port 1434. Note: For a named SQL Server instance (e.g. [yourServerInstance]\SQL2012SP2), the firewall needs an extra rule on the UDP protocol with the specific port 1434. Without this rule the system will return the exceptionerror: 26 - Error Locating Server/Instance Specified.

    1. Display the firewall advanced settings by navigating to Control Panel > System and Security > Windows Firewall > Advanced settings.

    2. Select Inbound Rules in the left-hand pane, then click New Rule in the right-hand pane.

    3. In the New Inbound Rule Wizard, Rule Type step, select Port.

    4. Protocols and Ports step, select UDP and set Specific local ports to 1434.

    5. Action step, select Allow the connection.

    6. Profile step, tick the Domain checkbox.

    7. Name step, enter a name for this rule, e.g. Named instance port 1434.

    8. Select Finish.

  6. If you still receive SQL connection errors, change your database name in the application configuration wizard to include the communication protocol and port number.

    1. Example 1: Your SQL Server is named "MySqlServer", change it to "tcp:MySqlServer,1433"​

    2. Example 2 (named instance): Your SQL Server instance is name "MySqlServer\MyInstance" change it to tcp:MySqlServer\MyInstance,1433"​

What to do next

For more information, refer to:




bottom of page