MySQL Forums
Forum List  »  Microsoft SQL Server

login failed for user
Posted by: Richard Errico
Date: March 07, 2011 06:23PM

Trying to evaluate MySql for a client and spent a whole day and still cannot get to the point where I can migrate an MSSQL database. (SQL 2005/Vista)

Searched all over and kept seeing the same problems. Use Workbench - woops - no migration tool (at least that I can find) - back to Migration Toolkit. Changed TCP/IP settings, changed SQL Server to use Sql and Win login. Then no matter what I do at the Source Database in MT I get " login failed for user". Added a new user with every permission set. Nothing works.

I am very reluctant to even consider having to go through all this on a production server - so at this point we must stay with what works.

Options: ReplyQuote

Written By
login failed for user
March 07, 2011 06:23PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.