2.2 How to Register a Server (Revision #29)

Registering Servers

Once you have installed Aqua Data Studio you will need to register your servers before you get started. There are three methods of registering servers, all of which launch the Register Server dialog

• You can navigate to the Main Application Menu to Server, then select Register Server
• You can right-click in the Schema Browser to bring up the context menu and select Register Server
• You can also click the Query Analyzer Icon at the top left of the Main Application window

All of these launches the Register Server dialog, which lets you fill in the properties of the server you are attempting to connect to.

The properties of any registered server can be viewed and altered by right-clicking on a server in the Schema Browser and selecting "Server Properties."

There are defaults set for the different RDBMSes within the Register Server Dialog, depending on the database vendor and version chosen. In most cases it is good to use these defaults. There is some variation in how different database types are registered and it is important to have the correct drivers. For more information on drivers see the "JDBC Drivers" section.

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 will have to be entered within the properties of each one. Passwords do not copy when configurations are duplicated. See the "Application: Settings" section for more information on sharing and portability of Aqua Data Studio configurations.

Each section below offers specific notes for the different database types.

• Oracle


• DB2 iSeries


• DB2 LUW


• DB2 zOS


• MS SQL Server


• Sybase ASE


• Sybase Anywhere


• Sybase IQ


• Informix


• Teradata


• Aster nCluster


• MySQL


• PostgreSQL


• Apache Derby


• Generic JDBC


• Generic ODBC

Register Oracle Server - If you have any issues connecting to your Oracle instance, make sure that you can ping your server with ’tnsping’. Also, make sure you have the correct JDBC driver if you are connecting through OCI libraries.  (Drivers)

Aqua Data Studio also allows you to connect to Oracle RAC and Oracle Connection Manager by entering into "Host" value:

Oracle Connection Manager Examples:

(description=(address_list=(address=(protocol=tcp)(port=1610)(host=webHost)) (address=(protocol=tcp)(port=1521)(host=oraHost))) (connect_data=(INSTANCE_NAME=orcl))(source_route=yes))

Oracle RAC Examples:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PRIMARY_NODE_HOSTNAME)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=SECONDARY_NODE_HOSTNAME)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=DATABASE_SERVICENAME)))

(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx) (PORT=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1526))) (CONNECT_DATA=(SERVICE_NAME=somesid)))

Register Microsoft SQL Server - SQL Server registrations should be straight forward.

Windows Single Sign-On - Aqua Data Studio supports trusted single sign-on connections to SQL Server on the Windows platform. You may specify the authentication as "Windows Single Sign-On", which will allow ADS to login into a server using the currently logged in authentication of the OS. This is only supported on the Windows platform, and not on Linux, OSX or other platforms. For other platforms use the "Windows Authentication" option.

Windows Authentication - Aqua Data Studio supports trusted connections to SQL Server on non-Windows platforms. You may specify the authentication as "Windows Authentication" and specify the Domain/Username and password of the user to authenticate with.

Connecting to Multiple Instances of SQL Server on the same machine - When registering an SQL Server you may specify in the Hostname text the name of the SQL Server and the Instance name in the format \\ServerName\InstanceName without a port, to enable an Instance connection. You may also connect to multiple Instances of SQL Server on the same machine by identifying on what ports each Instance is running. For SQL Server 2000 you can run the "SQL Server Network Utility". You may then select the Instance of SQL Server and make sure the "TCP/IP" protocol is enabled. Then you may select the TCP/IP protocol and click properties, this should tell you the default port.

Once you know the port of each Instance you may register a connection for each Instance by specifying the hostname and the port for each connection/instance.

Connecting and Use with MS SQL Server Debugger (Microsoft SQL Server 2005) -  The Advanced Tab requires entering Domain, Username and Password when connecting to SQL Server 2005 for debugging.  If your SQL Server is not part of a domain, enter its IP address as the domain.

When registering an SQL Server for use with the MS SQL Server Debugger it is important to set the security on the server itself to allow for the debugger’s connection. On the server hosting SQL Server 2005, the following must be set correctly to allow for debugging.

• Configure DCOM Security
• Disable the server’s Firewall.