Creating a New Enterprise Database

If your organization already has established a database server with Oracle or Microsoft SQL Server and you have the permissions necessary to create databases on the server, you can create a new enterprise database by choosing File > Manage Database > New Enterprise Database.

Tip: If you need to be able to create an enterprise database without using a ReliaSoft desktop application (i.e., without taking up one of the available license seats), you can access this same feature from the ReliaSoft Admin tool.

You can choose to create the new database in either Oracle or Microsoft SQL Server.

If you choose SQL Server, you will be required to enter:

• Server Name: The name of the Microsoft SQL Server implementation where the new database will be created. Note that if you are using SQL Server Express, the server name is usually your login for that computer followed by \SQLEXPRESS (e.g., Username\SQLEXPRESS).
• Database Name: The name of the new database that will be created.
• Options:
  • Encrypt communication secures the connection information between the ReliaSoft application and the enterprise database. When using this option, your IT group must also install an SSL certificate on the SQL Server and turn on the encrypted communication protocol for the instance where the database is installed. If an SSL certificate is not available, then you must clear this option.
  • Trust server certificate. Select this option if the server has a self-signed certificate.

IMPORTANT: A self-signed certificate used in this configuration is less secure and allows for the possibility of man-in-the-middle attacks or identity spoofing. This is not a recommended setting for production systems.

If you choose Oracle, you will be required to enter:

• Port, Host and Service identifiers for the Oracle server where the new database will be created.

IMPORTANT: If you are using Oracle 19c with a pluggable database (PDB), the Service name must be fully qualified (e.g., [PDBName].[db_domain]).

• The Schema of the new Enterprise database.
• The Password for the new enterprise database schema. If you are including special characters in the password, you must include quotes around each special character when entering the password.
• The administrative username and password for the Oracle server (entered in the Admin Information area).

For either server type, select the Import from existing database check box if you want to import entire projects and other data from an existing database.

Click OK to create the database. The database will not open automatically; you must connect to it. (See Connecting to an Existing Enterprise Database.)