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]
alexandr.kirpichny created
sqlways:troubleshooting-guide:sql-server:export:login-failed-for-user [June 29, 2018, 07:13:56 AM] (current)
vera.bonda
Line 9: Line 9:
 **Symptoms** **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". +After specifying ODBC Data Source and connection credentials to the source MS SQL databaseon a"Choose a Source Database" page you may receive an error "Login failed for user". 
  
 {{:sqlways:troubleshooting-guide:sql-server:export:log_failed2.png|}} {{:sqlways:troubleshooting-guide:sql-server:export:log_failed2.png|}}
Line 16: Line 16:
 **Cause** **Cause**
  
-Here might be two options:+Here might be two reasons:
  
-Incorrect password+The indicated password is incorrect.
  
 - The specified user doesn't have enough privileges to connect to the database specified in the ODBC connection. - The specified user doesn't have enough privileges to connect to the database specified in the ODBC connection.
Line 24: Line 24:
 **Solution** **Solution**
  
-So please follow the steps described:+In order to resolve the issue, pleasefollow the steps described below:
  
-1. First of all please check the provided password. Please be sure that the password is correct. \\ +1. First of allpleasecheck the provided password. Pleasebe 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:\\ +2. If the password is correct, but you still receive the same error message, thenpleaseassign default database to the login you are using and create a user in this database. You can do this using the queries below:\\ 
        
    alter login test_pwd with default_database = itest;  -- Assign default database for login    alter login test_pwd with default_database = itest;  -- Assign default database for login
Line 40: Line 40:
 \\ \\
 \\ \\
-If you will have any other questions regarding the usage of our tool please contact our support team: [[[email protected]]]+If you have any other questions regarding the usage of our toolpleasecontact our support team: [[[email protected]]]
  
  
sqlways/troubleshooting-guide/sql-server/export/login-failed-for-user.1526550388.txt.gz · Last modified: May 17, 2018, 09:46:28 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement