How do you configure a ColdFusion 8 datasource to connect to a local SQL Server 2008 server?

I've set up a local SQL 2008 Server, enabled SQL Authentication, created a user for ColdFusion to use and verifie开发者_如何转开发d that I can connect with that username and password using SSMS. (Connect using MACHINENAME\SQLEXPRESS)

However, I am unable to successfuly add the datasource in my CF Administrator, with the error being: Error establishing socket to host and port

Is there additional configuration of the server or ColdFusion that is necessary to connect?

You should be able to just use LOCALHOST as the server name, and port 1433 as the port number. You may have to enable IP connections through the SQL Server Configuration Manager. You can search Google for instructions on how to do that, which I found here and here.