Knowledgebase: QODBC
[QODBC-Desktop] Troubleshooting - How to turn On/Off Encryption on QRemote
Posted by Jack - QODBC Support on 17 April 2017 09:42 AM

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 I accessing my QuickBooks Data through QRemote.

How can I use Encryption is QRemote?

Solution:

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

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

By default, Encryption feature in QRemote is disabled. 

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

First, We will turn on Encryption in the QRemoteServer.

You can find 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 default configuration.

Navigate to File >> Setting

Setting Window will open. Navigate to "Encryption" tab.

Select "On" option & enter your desired encryption key in the box and click "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 setup 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 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 "System DSN" tab & click on your DSN and hit configure. In this tutorial, I am configuring encryption in 32-bit default QRemote Client DSN (QuickBooks Data QRemote).

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

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

Test connection is successful.

If your encryption key on QRemote client is not matched with QRemote Server or Encryption option (i.e. On/Off) is not matched with QRemote Server, then You will receive 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, then please set Encryption option "Off" on QRemote Client & QRemote Server.

 

(0 vote(s))
Helpful
Not helpful

Comments (2)
John Lundberg
26 October 2017 07:15 PM
For the past two years I have used QRemote Server and a DSN QuickBooks data. Today for the first time an encryption key/password has appeared in my QRemote for QuickBooks Version 1.0.0.323. The connection works using the key/password automatically provided with Encryption turned off.

Why do I need this?
Jack
27 October 2017 09:00 AM
Hi John,

We have released new security feature in our latest version. So you need to provide the password for QRemote DSN.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).