[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
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?
QRemoteServer has Encryption feature which will send/receive data between client & server in an 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, the 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.
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 CDKEY step during installation