Install Coldfusion 11 Windows

Posted on

Recently I installed Windows 8.1 in a virtual machine so I could set up IIS, ColdFusion (Developer version) and SQL Server (Express), which would match some of my client’s hosting well enough to use as a test environment.

  1. Install Coldfusion 11 Windows 10 Pro
  2. Install Coldfusion 11 Windows 7
  3. Install Coldfusion 11 Windows 10
  4. Install Coldfusion 11 On Windows 10

SQL Server Express and ColdFusion developer edition can be used for free by developers, which makes this a nice, low cost development environment.

I hit big problems trying to get ColdFusion to talk to SQL Server Express, so I thought I ought to document the setup process for next time I tried and hit these problems. Sorry if you’re reading this and some of the notes are not detailed enough, I’ve set up ColdFusion and SQL Server enough times that the basics have stuck, if you need more help you might find it useful to search YouTube for help videos.

. Run Windows Update and ensure all software running on the server is fully patched. Ensure that all partitions use NTFS to allow for fine grained access control. Download ColdFusion from adobe.com. Verify that the MD5 checksum listed on adobe.comdownload page matches the file you downloaded. Windows Server 2012, Windows 2012 R2. Supported only till 07/2015, when Microsoft support for this platform ends. At the time of release for ColdFusion 11, the certified version of Apache was 2.4.9. Once you've downloaded ColdFusion, double click on the icon. This should launch the following window. Click Next to install ColdFusion. Licence Agreement. Confirm that you've read and agree to the licence agreement: Install Type. Select the installation type. If you have purchased a copy of ColdFusion, enter your serial number at this screen. Provided by the ColdFusion GUI installer. To migrate your server, perform the following steps: 1. Stop the previous version of ColdFusion server. Take a backup of all neo-.xml files available under /lib from the previous installation. Run the Adobe ColdFusion (2021 release) GUI installer and follow the installation steps.

Setting up SQL Server Express 2014

Download SQL Server Express 2014 and running the installer. This all worked fine so just Google for wherever Microsoft are putting the installers now (which is a different place whenever I look, which is several years apart.) Try to find out if you’ve got a 32bit or 64bit version of Windows first, as you need to download the version which matches your Windows.

Install Coldfusion 11 Windows 10 Pro

Setting up IIS

Install Coldfusion 11 Windows 7

Go in to Windows settings > Control Panel > Programs > Turn Windows features on and off

I’m not sure I needed all of these, but I ended up turning them on while trying to solve problems:

Tick all of these (where nested, tick the ones inside the nest, not just to install everything):

.Net framework 3.5
.Net framework 4
Within Internet Information Services:
– Web Management Tools:
– – IIS 6 Management Compatibility
– – – IIS Metabase and IIS 6 configuration compatibility
– – IIS Management Console
– – IIS Management Service
– World Wide Web Services:
– – Application Development Features:
– – – .Net Extensibility 3.5
– – – .Net Extensibility 4.5
– – – ASP.NET 3.5
– – – ASP.NET 4
– – – CGI
– – – ISAPI Extensions
– – – ISAPI Filters
– – Common HTTP Features:
– – – Default Document
– – – Directory Browsing
– – – HTTP Errors
– – – HTTP Redirection
– – – Static Content
– – Health and Diagnostics:
– – – HTTP Logging
– – Performance Features:
– – – Dynamic Content Compression
– – – Static Content Compression
– – Security:
– – – Request Filtering

Setting up ColdFusion 11

Download from http://coldfusion.adobe.com

Run the installer

Choose the option to install a standalone web server, then, later in the install options you can choose to connect it up to IIS.

Setting up a database user in SQL Server Express 2014

In SQL Server Management Studio

Create a database:

Right click on Databases in the left column ‘Object Explorer’ > ‘New Database…’ and run through the short form

Create a user:

In left column ‘Object Explorer’, click on Security, right click on ‘Logins’ > ‘New Login…’

Add a new user, e.g. ‘CFUser’

Choose SQL Server authentication, give it a password.

Uncheck ‘Enforce password policy’

In the ‘Default Database’ drop down, change it to your new database

On the left hand ‘Select a page’ click on ‘User Mapping’

Tick the your new database, further down add them as a type of user to the database – ‘db_datareader’ & ‘db_datawriter’

Configuring Windows Firewall to allow access to SQL Server

As per these instructions from Microsoft I ran WF.msc then set up an Inbound Rule to allow TCP on port 1433 for local use.

Configuring security to allow ColdFusion to get data from SQL Server Express 2014

Apparently by default, SQL Server Express doesn’t allow remote connections, but configuring it to allow a remote connection so ColdFusion could get data from it was very hard, as the 2014 version of SQL Server Express is more locked down than previous versions. I wouldn’t have got it working without this Stackoverflow question about SQL Server Express 2012.

Open ‘SQL Server Configuration Manager’ (by searching for ‘SQL Server configuration’ on the Start screen.)

Under ‘SQL Server Network Configuration’ > ‘Protocols for SQLEXPRESS’:

Change ‘Named Pipes’ to ‘Enabled’ (by right clicking) (I’m not sure this step is necessary, as I found it in a bit of advice while I was still trying to get everything working.)

Change ‘TCP/IP’ to ‘Enabled’, then right click again and choose ‘Properties’

Under ‘IP2’ set the IP address to be that of the computer’s IP address on the local subnet (I found this out by running ‘netstat -a’ on the command line and looking down for port 1433 while I was trying something else, I’m sure there’s an easier way of finding it.)

Scroll down to the settings for IPAII.

Make sure ‘TCP Dynamic Ports’ is blank (not the 5 digit number that mine had in there by default.)

Make sure the ‘TCP Port’ is set to ‘1433’ (mine was blank by default.)

You may also need to go to ‘Services’ (by searching for it in Windows) and turning on the SQL Server Browser service (and setting it to run automatically) – I already had mine turned on during other debugging, I’ve read different advice on whether it should be on or off.

Some of the settings for SQL Server don’t take until you’ve re-started the SQL Server service. I think in the end I restarted Windows to be sure things were going to take long-term.

After all of this, I was able to go in to ColdFusion administrator and successfully set up a datasource using the database user I’d set up. Just getting SQL Server and ColdFusion to talk to each other was 3-4 hours of messing about with my settings, hence writing up these notes to make it easier next time.

UPDATE: This article has become slightly outdated, as it discusses a previous version of ColdFusion. For a more up to date version see ColdFusion 2016 Installation.

As mentioned in the introduction, you need to install ColdFusion before you can build ColdFusion applications on your local computer.

You can download ColdFusion from the Adobe website (Adobe is the company that produces ColdFusion). Adobe has this comparison of the ColdFusion editions to ensure you download the correct edition.

Don't forget that the (free) developer edition actually gives you the same functionality as the full-blown enterprise version. The only limitation is that you can only access the website from the local computer and two other IP addresses. This means that you won't actually need to pay for ColdFusion in order to build your website. And as long as your web hosting provider supports ColdFusion, you won't need to pay anything else to use ColdFusion.

Screen Shots of Installation

To give you an idea of what ColdFusion installation involves, below are the steps that I took when installing ColdFusion 11 Developer edition onto an iMac.

This page was created when ColdFusion 11 was the current version. If by the time you read this, you have a later version of ColdFusion, the steps may differ slightly from below.

Introduction

Once you've downloaded ColdFusion, double click on the icon. This should launch the following window. Click Next to install ColdFusion.

Licence Agreement

Confirm that you've read and agree to the licence agreement:

Install Type

Select the installation type.

If you have purchased a copy of ColdFusion, enter your serial number at this screen.

If you don't want to purchase ColdFusion, select Developer Edition.

Alternatively, you could select 30 Day Trial if you need to be able to access your website from more than 2 external IP addresses (in addition to the website's local computer). Once the 30 days is up, ColdFusion will revert to the Developer edition (unless you pay for the Standard or Enterprise version).

Installer Configuration

Select an installer option.

The first option (Server configuration) is the most common option. The JEE configuration option is useful for running multiple instances of ColdFusion on your computer. If you choose the JEE configuration option, you should refer to the ColdFusion documentation.

Select ColdFusion Server Profile

Select an installer option.

The first option (Server Configuration) is fine. The other options are useful for running multiple instances of ColdFusion on your computer. If you choose the second or third option, you should refer to the ColdFusion documentation.

Sub-components Installation

Select the sub-components you want to install. By default, all sub-components are selected.

Remote Component Administrator Credentials

Enter a username and password for remote start/stop ColdFusion:

Select Installation Directory

Select the directory you'd like to install Coldfusion into. The default directory is fine (unless you have a specific reason to change this):

Earlier Versions of Adobe ColdFusion Installed?

If you have an ealier version of ColdFusion installed, you can migrate the settings over to the new version. Select Yes or No accordingly:

Previous ColdFusion Directory

If you selected Yes at the previous step, you will be asked where the previous version of ColdFusion was installed. Ensure this is correct and click Next:

Install Coldfusion 11 Windows

Previous ColdFusion Installation Detected

If you don't need to run a previous version of ColdFusion on the same machine with the new version that you're installing, ensure Configure my web server for ColdFusion 11 (recommended) is selected.

Otherwise, if you want to be able to run a previous version of ColdFusion as well as the new version on the same machine, select Enable the built-in web server (coexist):

Add Web Server Configuration

If you run your own web server (such as IIS or Apache), this screen allows you to add it to be configured to serve ColdFusion pages. Select the web server from the drop down list that you'd like to configure for ColdFusion:

Configure Web Servers/Websites

This screen allows you to select which web servers/websites should be configured to use ColdFusion:

Configure OpenOffice

This step enables you to configure OpenOffice with ColdFusion so that Office documents are processed with OpenOffice. Select Configure OpenOffice or deselect it as you wish.

Administrator Password

You are required to enter a password which is used for accessing the ColdFusion Administrator.

Note that you can always disable the login requirements for accessing the ColdFusion Administrator (you can do this via the ColdFusion Administrator). In general, you should never disable this unless it is in a development environment (eg, on your own local machine).

Enable RDS

You have the option of enabling RDS (Remote Development Service). Only enable RDS if you need to access the server remotely for development purposes. As a general rule, you should disable RDS on production servers (for security reasons).

Server Updates

ColdFusion can automatically check for server updates whenever you log in to the ColdFusion Administrator. Select or deselect Automatically check for server updates as you wish.

Pre-Installation Summary

Review your settings. You can go back and change anything that's incorrect. If all is correct, click Install. This is the bit that actually installs ColdFusion on your computer.

Installing ColdFusion

After clicking Install at the previous step, you should see the following screen. It could take around 5 to 10 minutes for installation to complete, and for the next screen to appear. You can sit and watch the status bar if you like or go and make yourself a cup of coffee.

Installation Complete

Once ColdFusion has been installed, you will see the following screen. You will be notified of any errors that occurred during installation with instructions on how to view the log file.

ColdFusion Migration

Here, ColdFusion migrates settings from any previous version of ColdFusion to the new version.

Starting ColdFusion

Once ColdFusion has been installed, your web server should be able to render any ColdFusion file. That is, if it has a .cfm extension, your web server will pass it to ColdFusion to process. However, this will only occur if ColdFusion has in fact, been started.

You may need to start ColdFusion once you've finished the installation. Here's how to do that.

Windows

Install Coldfusion 11 Windows 10

  1. Open a Command Prompt window
  2. Change directory to {cfroot}cfusionbin
  3. Run the following command: coldfusion.exe -start -console

You can also stop and restart ColdFusion. To stop ColdFusion use coldfusion.exe -stop -console. To restart use coldfusion.exe -restart -console.

UNIX/Linux/Solaris/MAC OS X

  1. Open a Terminal window
  2. Change directory to {cfroot}cfusionbin
  3. Run the following command: ./coldfusion start

To stop ColdFusion use ./coldfusion stop. To restart use ./coldfusion restart.

Note that {cfroot} means the ColdFusion root directory — the directory that it is installed in. On my iMac, the default installation was /Applications/Coldfusion11.

Install Coldfusion 11 On Windows 10

Therefore, you could also use the following command to start CF: /Applications/Coldfusion11/cfusion/bin/coldfusion start.