philduba.com

SQL Server 2005 Express and ColdFusion MX 7

Posted On July 4, 2006 10:28 AM By Phil in ColdFusion

I got the SQL Server 2005 Express Edition while at CFUnited to begin to use it and play around with it. Unfortunately, there are some intersting things occuring when installing it and then trying to connect ColdFusion MX. I didn't find a solution until going through Google. Here is what has to be done (or at least what I had to do):

1. Open the SQL Server Configuration Manager under Microsoft SQL Server 2005 --> Configuration Tools
   
2. Expand SQL Server 2005 Network Configuration
3. Click on Protocols for SQLEXPRESS
4. If TCP/IP is Disabled, right-click and Enable
5. Click SQL Server 2005 Services
6. Click SQL Server (SQLEXPRESS) and restart (circular blue arrow in toolbar)
7. Click back to the Protocals for SQLEXPRESS
8. Right-click on TCP/IP and select Properties
   
9. Click IP Addresses tab
10. Look at port number in IPAll --> TCP Dynamic Ports (apparently, this is randomized)
11. Open up ColdFusion Administrator and create as you would any other SQL Server datasource, except use the port number listed in Step 10.

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 2611 Views

Related Blog Entries

• Thanks for catching up Adobe! (January 4, 2007)
• Import/Export in SQL Server Management Studio Express (October 25, 2006)

Comments

Post Your Comments

Name:

Email Address:

Website:

Comments:

Enter text that you see in the image:

Remember My Information:

Subscribe:

If you subscribe, any new posts to this thread will be sent to your email address.