Creating Notification Database (NDB)

Scenario
You want to create and configure NDB on the Desigo CC Server and link it to the project so that the data (recipients, incidents, and notifications) is logged in the NDB.

For working with the NDB on a remote server, follow the steps as indicated. Once created you should link it to the project and encrypt the communication between the NDB on the remote server and the server project. See Encrypting the Communication Between Project and Remote HDB.

For background information, see the reference section.

Prerequisites

• For the hard disk sector-size support boundaries in the SQL server, you have reviewed the http://support.microsoft.com/kb/926930/[language code] from Microsoft.
• SQL Server or SQL Server Express is installed and available.
• A named instance is defined on the SQL Server.
• The host name of the SQL Server is not more than 15 characters.
• The Windows user configured in the System Account and in the NDB Service Account must be valid and assigned all required rights. See Log on as a Service Right in System Settings Procedures.
• The SQL Server Browser is set to automatic. See Enabling the SQL Server Browser.
• All required Windows system users are available.
• To work with SQL Server on the remote machine, the following prerequisites apply:
• The required firewall ports are enabled. For more information, see Configure Windows Defender Firewall Settings and Firewall Software in Complete the Installation Planning Requirements.
• The remote SQL Server is switched on for TCP/IP.
• SMC must be launched , the following prerequisites apply :
• The required Windows account configured on SQL Server with sysadmin fixed server role is available.
• If the required privileges are not available, a dialog box appears to provide a Windows account configured on SQL Server with sysadmin fixed server role.
• SMC launched with a Windows NDB owner user when NDB workflow do not need system administrator privileges.
• NDB workflows such as change NDB owner, which need system administrator privileges, a dialog box displays to provide a user having system administrator privileges on the SQL Server.
• For linking the NDB to the Server project, the Server project is created in SMC.

Overview