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
- Enable TCP/IP connectivity.
- Open SQL Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager).
- Expand SQL Server 2005 Network Configuration and click Protocols for SQLEXPRESS. In the right panel, right click on TCP/IP and choose enable.
- Restart SQL Server Express.
- Add SQL Server as an exception to the firewall rules.
- Open Windows Firewall (Control Panel > Windows Firewall).
- Click on the Exceptions tab.
- 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).
- Click OK to close Windows Firewall.
- Confirm the port that SQL Server Express 2005 is running on - Not all installations use the default of 1433.
- Open SQL Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager).
- Expand SQL Server 2005 Network Configuration and click Protocols for SQLEXPRESS. In the right panel, right click on TCP/IP and choose Properties.
- Go to the IP Addresses tab, scroll to the IPAll section and note the TCP Port displayed.
- 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.