Skip to main content
X
Xophe99
Participant
February 20, 2014
Answered

Can't add datasource for local SQL Server Express

  • February 20, 2014
  • 1 reply
  • 609 views

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?

    This topic has been closed for replies.
    Correct answer Xophe99

    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-958558.html.

    1 reply

    X
    Xophe99AuthorCorrect answer
    Participant
    February 20, 2014

    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-958558.html.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices