2

How to add a SQL Server Express datasource to ColdFusion

Posted by Paul@outside5.com on Jul 31, 2008 in How To

At last, a definitive method of that troublesome task of adding a SQL Server Express 2005 datasource to Coldfusion.  For anyone else facing the same frustrating situation, see the instructions below.

What you will need:

How to add a SQL Server Express 2005 datasource to ColdFusion 8

  1. Enable TCP/IP connectivity.
    1. Open SQL Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager).
    2. Expand SQL Server 2005 Network Configuration and click Protocols for SQLEXPRESS.  In the right panel, right click on TCP/IP and choose enable.
    3. Restart SQL Server Express.
  2. Add SQL Server as an exception to the firewall rules.
    1. Open Windows Firewall (Control Panel > Windows Firewall).
    2. Click on the Exceptions tab.
    3. Click on Add Program, then locate the SQL Server executable, which on our dev machines is under C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe).
    4. Click OK to close Windows Firewall.
  3. Confirm the port that SQL Server Express 2005 is running on - Not all installations use the default of 1433.
    1. Open SQL Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager).
    2. Expand SQL Server 2005 Network Configuration and click Protocols for SQLEXPRESS.  In the right panel, right click on TCP/IP and choose Properties.
    3. Go to the IP Addresses tab, scroll to the IPAll section and note the TCP Port displayed.
  4. Open CFAdministrator and add your datasource using your SQLEXPRESS\WHATEVER as the server, your database username and password as username and password and desired datasource name as datasource name.

Tags: , ,

Copyright © 2017 Inside Outside5 All rights reserved. Theme by Laptop Geek.