Re: Network error IOException: Connection Refused: connect in MS SQL Server 2000

[Alexey Rusakov]

I'm having exactly the same problem: "Network error IOException: Connection refused: connect" both on the source database selection screen (clicking the [...]) and connecting to servers screen.

I have MSDE 2000 installed locally on my machine, so I'm quite positive that host names (I've tried any possible combination), port, user name and password are correct. I can connect to the server using the enterprise manager, query analyzer or whatever else with the same credentials.

I've also ensured that both named pipes and tcp/ip are enabled. This post (http://forums.mysql.com/read.php?104,40871,40885) suggests that MS SQL SP3a helps: I've installed SP4 but again with no luck.

I'm resorting to manual migration at the moment, but I'd really appreciate if I could get migration toolkit working.

Update:
I've searched the web, and tried to enable named pipes (http://jtds.sourceforge.net/faq.html#urlFormat): jdbc:jtds:sqlserver://127.0.0.1;user=user;password=password;namedPipe=true.

First it gave me some error code instead of the 'connection refused' and the migration toolkit application crashed. But it actually worked after restart!

Hope this helps! And now I can proceed with the migration..

(The full post can be found here - http://www.alexeyrusakov.com/sitecoreblog/2005/09/30/MySQL+Migration+Toolkit.aspx)