Can't add datasource for local SQL Server Express

[Xophe99]

I can't get new datasource to connect to a local SQL Server Express (2008).

On SSE, I enabled non-NTLM authentication, created an account specifically for CFServer, and was able to log into SQL Server through Management Studio. But the datasource still won't connect.

When I enter computerName/SQLServerName for the Server, I get a message saying "...The requested instance is either invalid or not running."

When I enter just SQLServerName, message says "Error establishing socket. Unknown host: SQLServerName."

When I enter (local), I get a message saying "Error establishing socket. Unknown host: (local)"

When I enter 127.0.0.1, message says "Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect"

I don't know why the first is considered invalid, or why the fourth is refusing connection. Am I forgetting something?

[Xophe99 · Accepted solution]

I found the solution, which doesn't have to do with Coldfusion, but rather with configuring SQL Server for TCP/IP.  In case someone else ever stumbles upon this post with a similar problem, I wrote about it at http://forums.devshed.com/ms-sql-development-95/trying-to-connect-to-sql-server-on-localhost-1433t-9....