Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
sqlways:troubleshooting-guide:sql-server:export:login-failed-for-user [May 17, 2018, 09:46:28 AM] – created alexandr.kirpichny | sqlways:troubleshooting-guide:sql-server:export:login-failed-for-user [May 31, 2023, 05:28:12 PM] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
\\ | \\ | ||
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
- | + | ||
====== Login Failed For User ====== | ====== Login Failed For User ====== | ||
**Symptoms** | **Symptoms** | ||
- | After specifying ODBC Data Source and connection credentials to the source | + | After specifying ODBC Data Source and connection credentials to the source |
{{: | {{: | ||
Line 16: | Line 14: | ||
**Cause** | **Cause** | ||
- | Here might be two options: | + | Here might be two reasons: |
- | - Incorrect | + | - The indicated |
- The specified user doesn' | - The specified user doesn' | ||
Line 24: | Line 22: | ||
**Solution** | **Solution** | ||
- | So please follow the steps described: | + | In order to resolve the issue, |
- | 1. First of all please check the provided password. Please be sure that the password is correct. \\ | + | 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: | + | 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 this using the queries below: |
alter login test_pwd with default_database = itest; | alter login test_pwd with default_database = itest; | ||
Line 40: | Line 38: | ||
\\ | \\ | ||
\\ | \\ | ||
- | 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 tool, please, contact our support team: [[[email protected]]] |
- | \\ | ||
- | [[http:// | ||
- | [[http:// | ||
- | [[http:// |