Azure SQL error 18456: login failed means bad credentials or disabled login

Not specified by the original author.

[Microsoft SQL docs]: 'Login failed for user' (Error 18456) means the username or password is wrong, or the login is disabled: ask the service administrator for valid credentials. To check a disabled login, run SELECT name, isdisabled FROM sys.sqllogins in master; enable it with ALTER LOGIN [name] ENABLE. If the login does not exist, create it with CREATE LOGIN in master, then create the user in the target database and grant permissions. Save the tracing ID from the error message for support.

Context: 18456 is never a network error. Check the login itself.

Matched source

Source: Source: https://github.com/microsoftdocs/sql-docs/blob/HEAD/azure-sql/database/troubleshoot-common-errors-issues.md Original query: "Azure SQL error 18456: login failed means bad credentials or disabled login" Key terms: 18456, azure, credentials, disabled, error, failed, login, means

Source: 18456 is never a network error. Check the login itself.

Verified resolution: [Microsoft SQL docs]: 'Login failed for user' (Error 18456) means the username or password is wrong, or the login is disabled: ask the service administrator for valid credentials. To check a disabled login, run SELECT name, isdisabled FROM sys.sqllogins in master; enable it with ALTER LOGIN [name] ENABLE. If the login does not exist, create it with CREATE LOGIN in master, then create the user in the target database and grant permissions. Save the tracing ID from the error message for support.

Source URL: https://github.com/microsoftdocs/sql-docs/blob/HEAD/azure-sql/database/troubleshoot-common-errors-issues.md