Connecting to an Existing Enterprise Database

If your organization has already created an enterprise database on Oracle or SQL Server and you have an active user account, you can use an enterprise database connection file (*.rserp) to connect with the database. You can create this file yourself or use a file that has been created by someone else.

Creating a Connection File

To create a connection file, choose File > New > Enterprise Database Connection File.

Tip: Starting in Version 20.0.2, if you need to be able to create a connection file 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.

This command creates an enterprise database connection file (*.rserp) that is stored locally on your computer; the file contains all of the necessary information for connecting to the enterprise database.

Enter a name for the connection file, then choose the database type and version.

Note: If you want to encrypt the connection for an Oracle implementation, you must set the encryption type to either "requested" or "required" for the Oracle database. For more information, please consult the Oracle documentation (e.g., https://docs.oracle.com/cd/B19306_01/network.102/b14268/asoconfg.htm#i1007808).

Using an *.rserp File to Connect to an Enterprise Database

If you have used the connection file recently, choose File > Recent and then select the file in the Recent Databases list.

Otherwise, choose File > Open Database and then browse for the *.rserp file.

If you are unable to connect to an enterprise database, you may be encountering any of the following issues:

  • No access to the database. If you have not been given access to the database, you will see a message stating that your account in the database is not active or not assigned to at least one security group. You will need assistance from someone who can create and update user accounts (see Managing User Accounts).

  • Windows authentication failed. If your Windows login (domain and username) is different from what was specified for your user account, you will see a message to connect using alternative credentials. You will need assistance from someone who can enable the use of alternative credentials for your user account.

Note: If you get an "error occurred when reading the connection file" message, the connection file may be corrupted or is using old encryption. You can create a new connection file by choosing File > New > Enterprise Database Connection File.


Related Topics and Links