BuyDomino Search Change Region Menu

Domino Automation - How to Use Static SQL Port

Safety Note

This document applies to:

  • The Domino Printing group
  • The IT department of Domino's customers
  • The end user of the Domino Automation software
  • The end user of the Domino Designer software

Description

This document aims to present how to verify and change the SQL port used by the database for Domino Automation and DASQL’s instance.

✍️ NOTE

For best practice, it is advised to configure SQL to use a fixed TCP port, i.e: 1433 which is set by default.

Step 1

SQL CONFIGURATION MANAGER

  1. Launch SQL Configuration Manager



  2. In "SQL Server Services" stop the "SQL Server (DOMINO_INSTANCE_NAME)" service. For example:



    Here, Domino Automation 300 is installed on the DASQL instance.

  3. On the left, go to "SQL Server Network Configuration", then "Protocols for DOMINO_INSTANCE_NAME", for example:



    This will load in the middle:



  4. Right-click, then click "Properties" on "TCP/IP"



    The following window appears.



  5. Go to "IP Addresses"



  6. Scroll down to the line labeled "TCP Port"



  7. Verify the value TCP Port equal "1433"



    Dynamic ports should NOT be used.

  8. In some scenarios, it is possible to use another available TCP Port:



    Example : 41337

    ✍️ NOTE

    The IT department from the customer needs to configure and define this.



  9. Confirm with "OK"

  10. Go back to "SQL Server Services" and start the instance service





✍️ NOTE

Don't forget to open the SQL port in the Windows firewall (on clients and servers). Also, make sure to configure it on all internal devices, firewalls, and so on.