Registering a Database Server

Once you have installed Aqua Data Studio, you need to register your servers before you get started. Server Registrations are created, edited, grouped, connected to, and disconnected from most easily through the Schema Browser. 

Launch the Register Server Dialog

There are four methods of registering servers, all of which launch the Register Server dialog where you can provide the server properties for the server you are attempting to connect.

• On the Aqua Data Studio menu bar Server > Register Server. 
• Right-click in the Schema Browser > Register Server.
• On the Aqua Data Studio Toolbar, click .
• Press Insert key on Windows. 

The title at the top of the Register Server dialog indicates the RDBMS driver (the server type) in brackets, followed by a hyphen and the connection name in parenthesis. For example, a connection to an Oracle 11g server would appear as Register Server - [Oracle 9i/10g/11g]. 

Server Registration Dialog Defaults

There are defaults set for the different RDBMSes within the Register Server Dialog, depending on the database vendor and version chosen. Usually, use these defaults. There is variation in how different database types are registered and have the correct drivers. For more information, see JDBC Drivers.

Server Registrations Copied From Other Users

It is possible to register servers by using a configuration copied from another user. The servers from a copied configuration will populate the schema browser, but passwords must be entered within the properties of each one. Passwords do not copy when configurations are duplicated. For more information on sharing and portability of Aqua Data Studio configuration, see Configuration & Connection Files.

Register a Server in Aqua Data Studio 

To register a server

1. Launch the Register Server dialog.
2. In the Register Server dialog, select the RDBMS driver, provide the server details, authentication details, and location information, click Test Connection, and then click Save. 
3. After the server is successfully registered, it appears in the Local Databases Servers node. You can Connect to the Server and view its schema objects. 

Server Group

In Aqua Data Studio, you can add registered servers directly to the server node. However, you can also create server groups and register servers to those groups. You can even create subgroups within a group.

To create a server group

1. Right-click the Local Databases Servers node > New Server Group.
2. In the New Server Group Name dialog, type a name for the server group, and then click OK.
3. Right-click the server group name and then select Register Server.
4. Register the server. 
5. Expand the server group name to see the registered servers. 

Database Specific Registration Information

This table lists database specific information for registering server connections.

Troubleshooting Registrations

If you face any problem during server registration, there might be a few things that you need to review:

• Ensure that you have selected the correct RDBMS Driver initially.
• Check the username and password. Most problems are solved if the authentication information is correct.
• Make sure that the Database Server to which you are trying to connect Aqua Data Studio Client is up and running.
• Perform connection diagnostics by clicking Test Connection in the dialog. You will get to see detailed information on the connection and offer helpful tips on what may cause problems with your server registration. The Test Connection dialog contains a direct link to the documentation for the selected JDBC driver for that connection type, a Copy message and detail button, and a view details button. If you need to get in touch with AquaFold about a specific connection issue, click the Copy message and detail button and include this information when contacting AquaFold Support.

  

Edit Server Properties

To edit the server properties of an already registered server

1. Locate the server in the Server Browser.
2. Right-click the server and then choose Server Properties. Alternatively, select the server you want to edit and then use the CTRL/Command + SHIFT + P keyboard combination.
3. In the Edit Server Properties dialog, make the required changes and then click Save. 

Register a Server Clone

To create a server clone of an already registered server 

1. Locate the server in the Server Browser.
2. Right-click the server and then choose Register Server Clone. Alternatively, select the server you want to clone and then use the SHIFT + INSERT keyboard combination.
3. In the Register Server dialog, type a new name for the clone server, and then click Save. You can now connect to the newly registered server and perform data manipulations.

Connect to a Server

To connect to a server

1. Locate the server in the Server Browser. 
2. Right-click the server and select Connect. Alternatively, select the server you want to connect to and then use the CTRL + INSERT keyboard combination. On a successful connection, the icon changes to a green triangle overlay icon. You can expand the tree node to view the schema objects. Numerous tools like Query Analyzer, Query Builder, and ER Modeler become available to assist with your operations.

Disconnect from a Server

To disconnect from a registered server

1. Locate the server in the Server Browser. 
2. Right-click the server and then choose Disconnect. Alternatively, you can select the server you want to disconnect and use the keyboard combination CTRL + DELETE. The icon is changed from the green color, and the tree node is collapsed.

Delete a Server

To delete a server

1. Locate the server in the Server Browser. 
2. Right-click and then choose Unregister Server. Alternatively, select the server you want to delete and press the Delete key.
3. Click Yes to confirm your action. The server is deleted from the Local Database Servers node.