BuyDomino Search Changer de région Menu

Domino Automation - How to manually create an SQL Instance named "DASQL"

Safety Note

This document applies to:

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

Description

✍️ NOTE
  • This document aims to present the Microsoft SQL Server instance as well as the manual creation of an instance (SQL Express or SQL Standard).
  • Case scenario, instance name: DASQL

Step 1

Download SQL Express

By default, Domino Automation 300 uses an SQL Express 2022 database.

  1. Download Microsoft SQL Express 2022 - Click Here

✍️ NOTE

If the IT department wishes to use the STANDARD or FULL version with a paid license, they commit to creating an instance manually by following the attached procedure

Step 2

Create Manual Instance

  1. Extract the SQL setup files to the directory C:\temp



  2. Run the setup as administrator.

  3. Choose a directory where you extract all SQL files:



  4. Select "New installation stand-alone installation or add features":



  5. Read and accept license terms and click on “Next”:



  6. Uncheck “Include SQL server” and go on the next menu:



  7. Check if any warning or error messages are displayed:



    This can be a good hint in case of unexpected behaviour. For example if the IT department recently installed Windows update, sometimes you just need to restart the server beforehand.

  8. Warnings can be ignored, simply click on next button:



  9. Uncheck “Azure extension for SQL Server” and click “Next”:



  10. The "Feature Selection" page appears:



    • By default: C:\Program Files\Microsoft SQL Server
    • You can change (if needed) the installation path of the SQL instance via the "..." button.

      • Example: D:\Program Files\Microsoft SQL Server

  11. Click "Next" after choosing the appropriate path.

    The menu for changing the instance name appears

  12. Check "Named instance" and enter the instance name: DASQL


  13. Click "Next" to configure the server settings, specifically the following services:

  14. For both services: "SQL Server Database Engine" and "SQL Server Browser," choose the startup type as automatic and then click "Next."

  15. The following menu appears: "Database Engine Configuration":

  16. In "Specify SQL Server administrator," it is necessary to add another account to administer the database, for example, the domain administrator account via "Add…":





    This will have the effect of adding the domain administrator as an admin of the SQL instance.

  17. Click on "Next."

  18. Wait several minutes for the installation to complete:

  19. Once the installation is complete:

  20. Click on "Close" to exit the installation setup. You now need to enable communication protocols in "SQL Server Configuration Manager."

  21. (All Programs -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager)

     

  22. The following window appears:

  23. You now need to stop the service "SQL Server (INSTANCE_NAME)," for this, right-click and choose "Stop."

    • INSTANCE_NAME = DASQL

  24. Go to the menu "Protocols for INSTANCE_NAME" under "SQL Server Network Configuration":

  25. You need to enable:

    1. Named Pipes

    2. TCP/IP

  26. (Right-click, "Enable" on both protocols)

  27. Confirm the warning messages:

  28. Result:

  29. Restart the SQL Server instance service:

  30. The installation and configuration of the database instance are now complete.

Attachments