Registering a Database Server

Once you have installed Aqua Data Studio, you will 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. 

Contents

• Launch the Register Server Dialog
  • Server Registration Dialog Defaults
  • Server Registrations Copied From Other Users
• Register a Server in Aqua Data Studio
  • Database Specific Registration Information
  • Troubleshooting Registrations
• Edit Server Properties
• Register a Server Clone
• Connect to a Server
• Disconnect from a Server
• Delete a Server

Launch the Register Server Dialog

• 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 

Launch Register Server	Provide Server Details	Server appears in the Local Database Servers Node

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 now Connect to the Server and view its schema objects. 

Server Group

Launch New Server Group	Provide Group Name	Launch Register Server	Provide Server Details	Server appears in the Local Database Servers Node

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

Verify Driver Connection	Verify Login Name and Password	Test Connection

• Ensure that you have selected the correct RDBMS Driver initially.
• Check the username and password. Most problems are solved by 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.

  

The title at the top of the Register Server, Edit Server and Server Properties dialogs indicate the RDBMS driver (the server type) in brackets, followed by a hyphen and the connection name in parenthesis to assist in troubleshooting. If you are not sure what connection type you are using, look at the title text. For example, a connection to an Oracle 11g server, with the name "My Connection," would appear as [Oracle 9i/10g/11g] - [My Connection].

Edit Server Properties

Locate & Right-Click Server > Server Properties	Edit the Server Properties

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

Locate & Right-Click Server for Cloning	Type a New Name for the Clone 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.

To share or copy registered server connections for use on another computer, see Configuration & Connection Files.

Connect to a Server

Locate & Right-Click Server > Connect	Server is Successfully Connected

1. Locate the server in the Server Browser. 
2. Right-click the server and then choose 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

Locate & Right-Click Server > Disconnect	Server is Successfully Disconnected

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

Locate & Right-Click Server > Unregister Server	Confirm Your Action

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 then press Delete key.
3. Click Yes to confirm your action. The server is deleted from the Local Database Servers node.