Creating a New Enterprise Database
If your organization already has established a database server with 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 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.
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. As part of this process, a connection file will be created; starting in Version 2025, you will be prompted to create a password for this connection file. The database will not open automatically; you must connect to it. (See Connecting to an Existing Enterprise Database.)