Mysql migration tool, source parameter string | connection string for sql server

Question

Hi all,

I always got failed to "fetching of list failed error" this is my connection string in asp.NET "Data Source=maywood\XSQLSERVER;Initial Catalog=maywood_test;Integrated Security=SSPI"

What exactly i should input at Mysql migration tool for source parameter string

FYI,'maywood' is my conputer name and i am using sql sevrer 2000.

Thanks

Answer 1

You have integrated Integrated Security=SSPI set -- perhaps you should try setting the UID and Password manually to values that you know are correct.

Data Source=maywood\XSQLSERVER;Initial Catalog=maywood_test;
User ID=myUsername;Password=myPassword;

Integrated Security uses the credentials from the Windows system that you're using to log in -- these credentials might not be valid for the database you're trying to access.