Inside Outside5

We seem to have issues in the past adding a SQL Server Express 2005 datasource to Coldfusion 8 on the development machines at Outside5, so we thought a post was in order for anyone else facing the same frustrating situation.

What you will need:

• ColdFusion 8
• SQL Server Express 2005
• SQL Server Management Studio Express

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.

Our new website is up and running at long last.  It has been too long in the making and we are glad to have the basics of it up and running.

Keep your eyes open for updates to the site coming soon.