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?
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-localho st-1433t-958558.html.