CF MX, SQL Server and XP

[neilsytner]

Hi all,

I do alot of development on my laptop which has got Windows XP SP2, ColdFusion
MX 6.1 and SQL Server 2000 (Dev Ed) installed on it.

When I try to create a MS SQL datasource to the Northwind database in SQL
Server I get the following connection error:

Connection verification failed for data source: northwind
[]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

The connection setting are as follows:

Server: 127.0.0.1
Username: northwind
Password: *********
Port: 1433

The username of northwind is setup in SQL Server as:

Authentication: SQL Server
Type: Standard
Default database: Northwind
Server Roles: System Administrator
Database Access: Northwind

Does anyone have any ideas as to how I can get ColdFusion and SQL Server
talking to each other on XP? I'm new to SQL Server so any tips would greatly be
appreciated :)

Thanks in advance for any replies.

[neilsytner]

the problem was that SQL Server wasn't service patched - once the latest SP was applied it all worked fine.