Troubleshooting - How to turn On/Off Encryption on QRemote

Problem Description:

I am using QRemote to access QuickBooks Data & I want to add security when accessing my QuickBooks Data through QRemote.

How can I use Encryption in QRemote?

Solution 1:

QRemoteServer has an Encryption feature that will send/receive data between the client & server in an encrypted format. So you can use this feature.

The default Encryption Key/Password is set to "QODBC#QRemote$1". If you want to change your Encryption Key/Password, You can configure your encryption key on QRemoteServer and use the same on QRemote Client DSN.

By default, the Encryption feature in QRemote is disabled. 

So if you want to use Encryption, You can set up Encryption in QRemoteServer & QRemote Client.

First, We will turn on encryption in the QRemoteServer.

You can find the QRemote server running in the System Tray. Double-click the QRemoteServer icon from the system tray to maximize the QRemoteServer window.

If QRemoteServer is not running, then you can start QRemoteServer from: Start >> All Programs >> QODBC Driver for use with QuickBooks >> QRemote Server for QODBC.

QRemoteServer is running with the default configuration.

Navigate to File >> Setting

The setting window will open. Navigate to the "Encryption" tab.

Select the "On" option & enter your desired encryption key in the box and click the "Apply" button to save the configuration. Note: By Default Encryption Key/Password is set to "QODBC#QRemote$1"

QRemoteServer configuration is saved. We need to restart QRemoteServer to load the new configuration.

To exit/quit QRemoteServer, go to File >> Exit.

Start QRemoteServer from : Start >> All Programs >> QODBC Driver for use with QuickBooks >> QRemote Server for QODBC

QRemoteServer is running.

Now we will set up Encryption in QRemote Client DSN.

You can open 32-bit QRemote Client DSN from Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source

Note: If you have a 64-bit application, then You can open 64-bit QRemote Client DSN from Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source 64-bit

32-bit ODBC manager is opened. Navigate to the "System DSN" tab & click on your DSN, and hit configure. I am configuring encryption in 32-bit default QRemote Client DSN (QuickBooks Data QRemote) in this tutorial.

Enter the Encryption Key/Password which you have set up in QRemoteServer. QRemote client will be open with Default Encryption Key/Password "QODBC#QRemote$1". In this example, I have used the default Encryption Key/Password "QODBC#QRemote$1".

By Default, Encryption is set to Off. To enable Encryption, Select the "On" option & click on "Test Connection."

The test connection is successful.

If your encryption key on the QRemote client is not matched with QRemote Server or the Encryption option (i.e., On/Off) is not matched with QRemote Server. You will receive the error "QRemote Client Encryption Key does not match with the one specified on QRemote Server."

If you don't want to use the Encryption key, please set the Encryption option "Off" on QRemote Client & QRemote Server.

Solution 2:

Delete the file "QRemoteServerConfig.ini" from the below-listed location:

C:\ProgramData\QODBC Driver for QuickBooks

After deleting the file "QRemoteServerConfig.ini," exit QRemote Server

If you are using QRemote Remotely or an SQL server with QRemote from another machine, perform the above steps on that machine.

Please do not change the default encryption option or setting, try connecting it again.