QQube Multi-User Client Cannot See Server | CLEARIFY

You install the QQube multi-user client, and arrive at the screen where the QQube Engine Name is expected to be populated with the server name and address - and it is blank.

Cause

The IP Address and/or port is being blocked.  The QQube installer uses a Sybase Utility to "ping" the database server using UDP

There are five potential reasons for this:

1. SQLAnywhere Service not running on server
2. Incorrect DNS settings on the server
3. Workstation Firewall is blocking port 2638
4. Server Firewall is blocking port 2638
5. The workstation is on a different subnet

Resolution

Cause 1.  Login to the dedicated server synch user, and open up the QQube Configuration Tool.  Go to Advanced Options>Database (Show More).  The Start Database Service should be greyed out.  If it isn't then exit the qqube synchronizer in the lower right hand tray (right click on the lightning bolt and exit); then Start the Database Service.

Cause 2.  Open up a DOS Prompt Window, and do a ping on the server name to see if it comes up with the expected IP address.  If it doesn't please get with your IT personnel to troubleshoot and fix.

Cause 3. Temporarily disable the firewall on the workstation, then hit the "Back" button, and the "Next" button again to see if it finds the Server Engine Name.

Cause 4. If the resolution for Cause 2 did not work, then either temporarily disable the server firewall, or disable the firewall operation that prevents pings, and ports.

Cause 5.  There is a new option in QQube Release 7.7 Build 508 that is an easy work around.

FIRST - cancel the current installation.

SECOND (ON A WORKSTATION ONLY) - open up a cmd window (with administrative rights) and run a switch (OVERRIDENODBSERVER=1) that will allow the installer to ignore the search. 

ON A SERVER ONLY - the switch is  (OVERRIDESERVERCLIENT=1): 

In these two examples above, the qqubeinstall.exe was placed in the downloads directory; and run from that directory.

As you run through the installer, then you will notice that the "Next" button is now available in the Other Installation Options Window, even though there are no database servers found.

THIRD - once you complete the installation, run the QQube Configuration Tool.  It will return a message saying that it can't find the database server, and defaults to this window:

FOURTH - Type in the name of the database server that you see in the QQube Configuration Tool on the server, then physically type in the IP Address and Port in the Server IP Address window.  Unless the database service is not running on the server, or your firewall is specifically blocking this port, this option will always work.

Cause 5 - for versions BEFORE QQube Release 7.7 Build 508  This is a more involved work around that involves the installation of a single-user, changing some registry entries, and "fooling" it to act as multi-user client with the information already filled in.

FIRST. Install QQube as a single-user.   This is going to install its own database etc, but when it is done, we are going to change some settings to make it a multi-user client, and then manually point it to the correct server. 

After it is installed as a single-user (don't open up the QQube Configuration Tool), then we need to go in the registry and change the setting as follows:

Then you should be able to open up the QQube Configuration Tool, and it should be pointed to the server with no error.