Can't Connect to SQL Server DB

[dwright65]

I just installed ColdFusion MX and SQL Server Desktop Edition on my laptop for
development purposes. I've got the database up and have have created a few
tables and populated those tables with data. The problem is that when I try to
set up the datasource in ColdFusion Administrator, it won't connect. I get
this error

Connection verification failed for data source: FDP_dev
java.sql.SQLException: Error establishing socket to host and port:
M-XP207020:1433. Reason: Connection refused: connect
The root cause was that: java.sql.SQLException: Error establishing socket to
host and port: M-XP207020:1433. Reason: Connection refused: connect

I have tried everything that I can think of, but still don't have a clue as to
what is wrong. I've installed the latest ODBC drivers, shutdown, restarted,
searched the KB, but to no avail.

Any help will be greatly appreciated.

David

[cfdoogan]

this may help

[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0 0001743.htm[/url]

[BKBK]

Disable your firewall and try again. Some block port 1433 by default.

[mdi_george_java man]

Hi,
Am Having the same problem; i was wondering if you have found a solution to it
so you can let me know about it to.
Am Still trying very hard to find a solution, incase i do first, i'll let you
know but please if you have, i really need a helping hand on this.
it gives me this error

--------------------------------------------------------------------------------
-------------------------------
Connection verification failed for data source: fusetalk
java.sql.SQLException: Error establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: Error establishing socket.
Connection refused: connect

--------------------------------------------------------------------------------
-------------------------------

Am really confused, i have tried everything i know so far and its not getting
any better.

[drforbin1970]

Every time I have a problem connecting to a SQL Server DB via CF Admin, I do
the following:

In Windows, Control Panel, Administrative Tools, Data Sources(ODBC), set up a
User DSN and a System DSN to the SQL Server DB. USE THE SAME NAME FOR BOTH. If
you are using the local server on the machine, type in (local) as the server
for the select box 'Which SQL Server do you want to connect to?' Make sure the
connection tests OK at the end of each setup.

Go into CF Admin under Data Sources and Add a new datasource but DO NOT pick
SQL Server, use ODBC. Select the ODBC DSN(the entry you added should be in the
dropdown list). Click 'Trusted Connection'. Leave username set to system .
Click Submit and you should be connected.

If this does not work, you may have to add a user to the Users section of the
database with sufficient access. You will have to add the user under Control
Panel/User Groups also.

Then go back into CF Admin and replace username with the username of the new
user you added and the password you assigned this user under Control Panel/User
Groups

[I'mAndy]

In Windows, Control Panel, Administrative Tools, Data Sources(ODBC), set up a
User DSN and a System DSN to the SQL Server DB. USE THE SAME NAME FOR BOTH. If
you are using the local server on the machine, type in (local) as the server
for the select box 'Which SQL Server do you want to connect to?' Make sure the
connection tests OK at the end of each setup.

I'm getting connection failed
"sql server does not exist or access denied"
having used the windows nt authentication in trying to set up these as your
suggestions

The express server does exist (i can access it through the management studio)
so what should I be trying next

Cheers