How do I perform a "connection file transplant?"

Database connectivity is configured in two locations:  on the client side (within the enicq.connection file) and on the server side (from settings accessed through SQL Server Management Studio).  This topic focuses on how and when to copy the enicq.connection file from one machine to another.  This procedure may result in changes to your connectivity implementation. 

When will a connection file transplant help?

A connection file transplant is a relatively easy procedure to perform.  However, several conditions need to be true in order for a connection file transplant to be a possible solution.  At minimum, the following conditions must be true:

  • The database must be hosted on a server, not the local client machine’s drive.
  • There must be multiple installations of the client application on different machines.
  • One client installation has a higher level of database connectivity than another.

If you are using a SQL Login to sign on to the database, a connection file transplant will resolve any SQL Login differences between the two client machines. 

When a connection file transplant is not enough…

If you are using Window Authentication to sign on to the database, a connection file transplant may only solve part of the problem.  If the different Windows users have different rights assigned to them on the server, database connectivity may not be restored until work is also done on the server side. 

Extracting the connection file …from the eNICQ 5 client

On the machine that is donating the new connection file, start the eNICQ 5 application and login with an administrator level account.  An administrator level account is required to perform this operation.

  • Click Tools… Options… Database
  • Click the Copy Connection File To… button in the lower right hand corner.

  

  • Use the Save File dialog to save the file to a location you will remember.
  • Copy the file to a location that can be accessed by the receiving machine.

Extracting the connection file …from the eNICQ 5 installer

On the machine that is donating the new connection file, start the installer as normal:

  • Right click the installer an choose Run as administrator
  • Enter your Center Number and EDS Password
  • Only enter Optional Parameters if instructed to by the Vermont Oxford Network for test mode
  • Click Login to open the installer
  • Once the installer opens, click Advanced Install in the lower left corner:

On the Advanced Install screen, click on the button Copy Connection File To… in order to extract a copy of the connection file.

 

Use the Save File dialog to save the file to a location you will remember.

Copy the file to a location that can be accessed by the receiving machine.

Extracting the connection file …manually

On the machine that is donating the new connection file, browse to C:\Program Files\Vermont Oxford Network (or C:\Program Files (x86)\Vermont Oxford Network on a 64 bit operating system.)  In this location, find the enicq.connection file:

 

Make a copy of the enicq.connection file and place it in a location that can be accessed by the receiving machine. 

Backing up your connection file

On the machine that is receiving the new connection file, use one of the extraction methods described above to make a copy of the current connection file.

Additionally, be sure to… 

  • Rename the enicq.connection file copy to clarify that it is the original.
  • Place the enicq.connection file copy to a location you can recover from. 

This file can be restored back to its original name and location if it is necessary to undo the transplant. 

Inserting the connection file …using the eNICQ 5 installer

On the machine that is receiving the new connection file, start the installer as normal: 

  • Right click the installer and choose Run as administrator
  • Enter your Center Number and EDS Password
  • Only enter Optional Parameters if instructed to by the Vermont Oxford Network for test mode
  • Click the browse button to use an existing enicq.connection file:

 

  • Navigate through the open file dialog to find and select the donor connection file.
  • Click the Login button to start the installer with this new connection file in place. 

Inserting the connection file …manually

From the machine that is receiving the new connection file, locate and copy the donor enicq.connection file. 

Browse to C:\Program Files\Vermont Oxford Network (or C:\Program Files (x86)\Vermont Oxford Network on a 64 bit operating system.)  

Paste the donor enicq.connection file into the application directory, replacing the existing copy. 

Other considerations 

Please be aware of the following issues when working with connection files:

  • Proxy server settings are also stored in the enicq.connection file. When transplanting connection files, be sure that the proxy server settings on the donor machine are also appropriate for the receiving machine.
  • For group policy deployment, the enicq.connection file can be repackaged. See chapter 5 of the “eNICQ 5 System Administrator’s Guide” for more information.
  • Accidentally overwrote or lost the enicq.connection file. First, try restoring your backup connection file.  If you do not have a backup connection file, it is easy to rebuild the enicq.connection file with the installer.  See “Topic #5: Configuring Database Connectivity” in this guide for more information.
  • Found an enicq.connection file in both Program Files (x86) and Program Files. Prior to version 5.4.0, older versions of the eNICQ 5 installer experienced a bug in which they placed a connection file in Vermont Oxford Network directories in both C:\Program Files\Vermont Oxford Network and C:\Program Files (x86)\Vermont Oxford Network on  64 bit operating systems.  The correct file to use on a 64 bit system is the one stored in the (x86) directory. 
Have more questions? Submit a request

Comments