mssql connect

[David]

i have used dts to import tables from a mssql db to test version on my
computer. everything went well, but when i try to create data source in cf7
admin, i get

Connection verification failed for data source: coolpooldb
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Error establishing socket. Connection refused: connect

what do i do???
thanks ahead of time.
dave

[JJfutbol]

hey david, I'm glad at least I'm not the only getting this error as well. I
take it you have installed SQL Server Express 2005?? I have and I'm getting
this same error when trying to connect. I've googled for solutions and tried
many things but no luck so far. Lets hope someone can help us out.

[The ScareCrow]

Ensure that any firewall allows access to the relevant sql server port being
used.
Ensure that your install of sql server is using the same port as the port used
in the cf admin panel
The default sql server port is 1433.

David, you don't indicate which version of sql server you are using.
If sql server 2000 and you on an xp machine, you have to install at least sp3
or higher for sql server.

JJfutbol
I seem to recall reading somewhere that you need to download the jdbc driver
from MS.

Ken

[JJfutbol]

Hey ken thanks for the message. I apologize for not replying earlier as I had
figured out the issue last night. Today at CF United they SQL Server 2005
session also covered this problem. What you have to do is open up the SQL
Server Configuration Manager then on the left side in the tree menu open up SQL
Server Network Configuration and in the right pane you should see TCP/IP
disabled. Right click on it to enable it. Close that window. Then go to your
Control Panel, then Administrative Tools, then Services. Look for the SQL
Server 2005 service (there should be 4 or 5 of them, choose the first one which
should be the main one) and right click on it and select restart. Open up the
SQL Server Network Configuration again and go the the TCP/IP section. Right
click on it and select Properties or just double click on it. Select the IP
Addresses tab and the section titled IP All should have a TCP Dynamic Port of
some number other than 0. Copy that number and put it in the Port field when
setting up a SQL Server DSN in CF Administrator. For me 1433 did not work. It
ended up being a 4xxx number but now it works like a charm so I'm excited. Hope
this helps others. Give it a try David and let me know if that helped at all.
Take care.

[Keiko]

Thanks JJfutbol for the solution. It works.

Cheers,
Keiko :sun;

[JJfutbol]

Hey Keith, no problem glad to help out. :) Best of luck!