Creating History Infrastructure

Scenario
You want to create and configure HDB on the Desigo CC Server and link it to the project so that the data is logged in the HDB. You can also create an LTS to archive project data such as values, events, activities, and incidents.

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

For information on creating and configuring the notification database, see Creating Notification Database (NDB).

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 HDB 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 HDB owner user when HDB workflow do not need system administrator privileges.
• HDB workflows such as change HDB 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 HDB to the Server project, the Server project is created in SMC.

Overview