Excel Add-In Declares Database Server Not Found

Modified on Sun, 26 Jul at 12:34 AM

Overview

In a QQube Multi-User environment, the Excel Add-In may report that the QQube database server cannot be found.

Excel Add-In Message

Excel Add-In database server not found message

QQube Configuration Tool Message

QQube Configuration Tool database server not found message

Possible Causes

The QQube database service is not running on the server.
QQube was moved to a new server.
The existing server was renamed.
Firewall rules are blocking communication with the QQube database server.

Resolution

1. Confirm the Dedicated Server User Is Logged In

Confirm that the dedicated Windows server user created for QQube synchronization is logged in and running.

If every workstation displays the same database-server error, first check the QQube server and its dedicated synchronization user.

For information about the required server user, review the QQube Requirements Checklist.

2. Search for the QQube Database Server

If the dedicated server user is logged in:

Select OK on the QQube Configuration Tool error message.
Select the button containing three dots.
Wait several seconds while QQube searches the network for an available database server.

Searching for a QQube database server

3. Test the Workstation Firewall

If QQube reports that no database servers were found, temporarily turn off the Windows firewall on the workstation and repeat the search.

No QQube database servers found message

Firewall test only

Turn off the firewall only long enough to test database discovery. Turn it back on immediately after the test.

If database discovery works only while the firewall is off, have your IT administrator allow TCP/IP communication through port 2638.

Windows firewall settings are available under:

Control Panel > System and Security > Windows Defender Firewall > Turn Windows Defender Firewall on or off

4. Select the Correct QQube Database Server

When QQube finds the database server, select it from the list.

QQube database server found

Only one QQube database engine

If more than one QQube database server appears, the network contains an incorrect or duplicate installation. Only one QQube database engine should exist on a physical network.

Select Select to return to the database settings window. The discovered database engine or server name should now be displayed.

New QQube database server selected and ready to save

Save the setting. You will then return to the main QQube Configuration Tool window.

Expected Result

The QQube Configuration Tool and Excel Add-In should connect to the selected QQube database server without displaying the database-server-not-found message.