Migrating from ms sql serve with Migration toolkit

[ushtabalakh]

Hey

I have an instance of ms sql server running at this address:

COMPUTER_NAME\SQLEXPRESS

Now when in MySQL Migration toolkit I enter this as hostname, it does not fetch the list of databases.

it says

unknown server host name "COMPUTER_NAME\SQLEXPRESS"

This is the address that sql studio manager uses to connect so it can't be worong but I guess mysql is looking for an ip address and a port.

How can I overcome this issue?

 

[Kozusnik]

Sounds like windows...not my forte, but can you get to \\COMPUTER_NAME\? It could be a sharing or dns problem.

Mark

 

[ushtabalakh]

thanks, but that didn't help.
I realize instead of filling those textbox I can enter a jdbc connection string.

Does anyone know how to make a connection string for
server:COMPUTER_NAME\SQLEXPRESS
database:dbname
username:sa
password:sapassword

I'm using ms sql 2005 express.