Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:troubleshooting-guide:sql-server:export:login-failed-for-user [May 17, 2018, 09:46:28 AM] (current)
alexandr.kirpichny created
Line 1: Line 1:
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products/sql-server-migration|Ispirer SQLWays Product Page - Migration to SQL Server]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
  
 +
 +====== Login Failed For User ======
 +
 +**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". 
 +
 +{{:sqlways:troubleshooting-guide:sql-server:export:log_failed2.png|}}
 +
 +
 +**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: [[[email protected]]]
 +
 +
 +
 +
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products/sql-server-migration|Ispirer SQLWays Product Page - Migration to SQL Server]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
sqlways/troubleshooting-guide/sql-server/export/login-failed-for-user.txt · Last modified: May 17, 2018, 09:46:28 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement