Error when trying to connect a SQL DB in CF MX7

[tee4]

Doesn't work for me, dont have ODBC installed so I have to connect direct!

My DSN's were working fine until I installed SP2! Tried turning off Windows Firewall with no luck.

[jschlosser]

I need the SQL Server setup. My connections to dbs on other servers work fine,
I just can't connect to those on my development machine except as ODBC Sockets
and the application I am working with doesn't like it. What is different about
my local setup - and I have colleagues in the same boat. Someone suggested it
might be related to how SQL Server was set up on them.

[dimsis]

I've spend two days to find a solution to this 'Error establishing socket.
Connection refused: connect' error... This is seems to occur only when on
Windows with SP 2. The solution to your problem is simple: After installing
SQL Server and Coldfusion INSTALL SQL Server 2000 Service Pack 4 and your done!
To save you some time searching:
[url]http://www.microsoft.com/sql/evaluation/betanominations.asp[/url]
[url]http://support.microsoft.com/kb/290211/EN-US/[/url] After that No ODBC Socket driver
or any port 'opening' is required! I have not test it with SP 3, only with SP 4
beta... perhaps it'll also works... (my congratulations to Microsoft and
please send me a tone of aspirins...) CYA! Dimitris

[bernsmi]

I am also having the same problem. I am running CF MX 6.1 with SQL Server 2000
and Windows Server 2003 Enterprise addition in a clustered environment. I was
able to setup DSN's using the Cold Fusion Admin page and the SQL Server driver
included with CF. Then my servers were moved to a new data center in another
state and the DSN's do not work anymore. I can create an ODBC DSN and point to
it from CF but I don't want to do this because about 50 dsn' that I have to
setup and deploy to multiple clusters and I wanted to use the deployment option
in CF admin. Any ideas why this would stop working when the servers were moved
to another network? I am having my IS people check to make sure that port #
1433 is not blocked. thanks Mike