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 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

Close all the applications that use QODBC or QuickBooks application.
Close / Exit QRemoteServer
Uninstall QODBC. (Do not deactivate your current CDKEY/License)
Install QODBC again.
Skip the CDKEY step during installation
Restart Windows


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.

(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).