1 Reply Latest reply on Feb 20, 2014 12:25 PM by Xophe99

    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?