To connect to Sybase IQ databases, you need to specify certain parameters:
Host and port number for the server
Username and password for the user account
You may specify these parameters in a Connection Profile.
For details, see “Creating
connection profiles” in Sybase IQ System Administration Guide.
On the Connection Parameters screen, the Username defaults to:
DBA
This identifies a user with full administration and resource creation rights.
The password for this user defaults to:
SQL
By default, all newly-created Sybase IQ databases contain this user ID and password. The database administrator is responsible for providing the desired level of security by changing passwords and creating other user IDs. For security reasons, Sybase strongly recommends that you change the DBA password from the default.
To change the DBA password, you must have DBA authority.
To change the DBA password using dbisql.
GRANT CONNECT TO DBA IDENTIFIED BY new_password
Unless there is only one server per system, always change the default port number for the host machine. You can specify any port number that is not already in use. To list port numbers in use, use the netstat or dblocate command. Port numbers are listed after the host name in the Local Address column.
If a connection profile exists for the server, you may instead choose the server from the Server Lookup dropdown menu. Click Next to continue.
If you chose not to start the database automatically, type the password for the DBA user and check that the host machine and port number are correct, then click Next.
If you chose not to start the database automatically, and use an active server instead of the Utility Server, the screen looks like this:
Type the server name and port number for the active IQ server. If a connection profile exists for the server, you may instead choose the server from the Connection Profile dropdown menu.
Click Next when you have specified all connection information.
