How do I create a test site on my production server? (ColdFusion)

Note: These instructions only apply to Version 12.5 or earlier.

Test sites can be created using your existing intranet to test how a Patch or Upgrade may affect your data. Please note that this is only for testing Patches and Upgrades in your environment and any errors during this process however, we are not able to provide support for 2 sites - only Production. 


Installing your Test Intranet Site

The following instructions are for installing a test site using the SQL database on your production server for testing purposes only. The following is a general overview of the information covered by this article:

Step One: Getting Started
Step Two: Copying Your Existing Intranet
Step Three: Adding the Test Site Customized File
Step Four: Copying your Existing Intranet Database
Step Five: Creating your Test SQL Data Source
Step Six: Accessing your Test Site and Updating the Location

If you are interested in installing a test site on a separate server, or if your production server uses an Access database, please contact Support for the correct instructional document.

Step One: Getting Started

Navigate to the location on your production server where the Intranet has been installed. The default installation location is C:\inetpub\wwwroot\Intranet however your site may be installed in a different location.

To confirm the location of your Intranet site, you can open IIS Manager, right click on the Intranet website (or Default Website), choose Basic Settings... in the far-right pane.  The intranet directory location will be defined in the Physical Path field.

For the purposes of this document, we will assume that your live intranet site is installed at the default C:\Inetpub\wwwroot\Intranet location.

The test intranet site will have a local path of C:\inetpub\wwwroot\TestIntranet.

Note: If your live site is running at the root (C:\inetpub\wwwroot\Intranet) you will need to create a second website in IIS opening at a different port (Port 8080) or host name. This website will have a Physical Path of C:\inetpub\wwwroot\TestIntranet.

Step Two: Copying Your Existing Intranet
  1. Create the following new folder: C:\inetpub\wwwroot\TestIntranet
  2. Copy the contents of your existing Intranet folder (C:\inetpub\wwwroot\Intranet)
  3. Paste these files into your new Testintranet folder (C:\inetpub\wwwroot\TestIntranet)

Step Three: Adding the Test Site Customized File

Please download the attached file at the bottom of this article.

Please be aware that it is essential to add this file to your test intranet site. If at any point you recreate the test site by copying over the content of the test site with the current production site files, you must re-add this file to your test intranet site.

  1. Add the cfregdn file to the following folder on your test server's admin folder:


  2. Choose replace when prompted if you want to overwrite the exiting file of this name.

Step Four: Copying your Existing Intranet Database
Open SQL Server Management Studio or Enterprise Manager. Copy your production database, generally called IntranetConnections. The recommended way of doing so is to create a new database called TestIntranetConnections, backup your existing production database, and restore the production database to the new TestIntranetConnections database.

For more information on creating a backup of your IntranetConnections database, please view our Creating a SQL Database Backup article.

Step Five: Creating your Test SQL Data Source

Log into your ColdFusion Admin site:


Please replace the [intranetsiteaddress] portion of the above link with the appropriate DNS name or IP address of your server.

Once authenticated, go to Data and Services -> Data Sources


Confirm that you now have two datasources. SQLFunctions and TestSQLFunctions.

Step Six: Accessing your Test Site and Updating the Location

Visit your test site by going to the following address:


Login and go here:


You should see the Drive and Web locations under System Information updated to reflect the test site address

Have more questions? Submit a request


Article is closed for comments.