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.
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)))	Oracle Registration
Register DB2 Server - Before connecting to your server, make sure you have the appropriate driver for your DB2 version and fixpack.	DB2 Registration
Register Informix Server - Informix registrations should be straight forward.	Informix Registration
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.	SQL Server Registration
Register PostgreSQL Server - If you have issues connecting to your PostgreSQL server, make sure that you have started your PostgreSQL postmaster with the ’-i’ option which enables TCP/IP connections. TCP/IP connections are required for ADS to connect to the PostgreSQL server.	PostgreSQL Registration
Register MySQL Server - Before connecting to MySQL you will need to GRANT access to your user and machine. Because the MySQL JDBC driver uses TCP/IP sockets instead of Unix Domain Sockets, the security manager in MySQL server will use the HOSTS table to determine whether or not the connection should be allowed. To grant your user access use this syntax: "GRANT ALL PRIVILEGES ON [dbname]. to ’[user]’@’[hostname]’ identified by ’[password]’"* to generate and execute an SQL command.	MySQL Registration
Register Sybase Server - Sybase registrations should be straight forward, although you should make sure your Sybase server has had the Sybase sql_serverXX.sql meta data script applied to it as documented in your Sybase documentation. This script is usually applied during installation by default.	Sybase Registration
Register Sybase Anywhere Server - Sybase Anywhere registrations should be straight forward.	Sybase Registration
Register Sybase IQ Server - Sybase IQ registrations should be straight forward.	Sybase IQ Registration
Register Apache Derby - Apache Derby registrations should be straight forward.	Apache Derby Registration
Register Generic JDBC & ODBC Server - When registering a server using the Generic-JDBC connection type, make sure you specify the location of the driver which you will be using, with the correct URL and driver name. When registering a Generic-ODBC connection make sure that an ODBC datasource has already been created for use.	Generic JDBC Registration