James Smith wrote: >> 1. Use SQL Server Express 2005 instead. It is so much better. > > No can do, the production server is 2000 so he must develop on 2000 to avoid > things going wrong between dev and production.
Then I would still recommend using SQL Server Management Studio Express over Enterprise Manager. >> 3. What is the error? > > It is a connection error... > > ------------------------------------------------------- > Connection verification failed for data source: test > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing > socket. Connection refused: connect Have you configured the server to listen to TCP/IP connections? Can you connect to the port with telnet? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

