ODBC Connection Problem

[James74]

I'm running windows XP Professional, MS SQL Server 2000 developer, IIS 5.1 and
Cold Fusion MX 7 on my local machine.

I get the following error when trying to add a datasource in CF Administrator:

Connection verification failed for data source: testdatasource
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Unable to connect.
Invalid URL.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Unable to connect. Invalid URL.

It has something to do with finding the SQL Server, but I'm lost. Any help
would be greatly appreciated.

I've tryed putting (local) and 127.0.0.1 for the server and it didn't work.
Also, I'm not sure what port I should be using. I've
been leaving the default in there.

Thanks

James

[ke4pym]

Do you have a firewall running? MSSQL generally is configured to use 1433.
Can you create a Datasource using the ODBC control panel in the Admin Tools
Folder?

Have you tried using your machine's real IP address?