Symptoms

After specifying ODBC Data Source and connection credentials to the source MSSQL database on the “Choose a Source Database” page you may receive an error “Login failed for user”.

Cause

Here might be two options:

- Incorrect password

- The specified user doesn't have enough privileges to connect to the database specified in the ODBC connection.

Solution

So please follow the steps described:

1. First of all please check the provided password. Please be sure that the password is correct.

2. If the password is correct, but you still receive the same error message, then please assign default database to the login you are using and create a user in this database. You can do that using the queries below:

 
 alter login test_pwd with default_database = itest;  -- Assign default database for login
 use itest;                                           -- We need to use the required database
 create user test_user from login test_pwd;           -- And in the requried database we need to create a user
 

Only after that we will be able to connect to the required database using our login.

If you will have any other questions regarding the usage of our tool please contact our support team: support@ispirer.com

Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays