Connect to Server
Cannot connect to server-name.
Additional information:
Login failed for user 'user\Administrator'. (Microsoft SQL Server, Error: 18456)
Error 18456 Screenshot:
Product Name SQL Server
Event ID 18456
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name LOGON_FAILED
Message Text Login failed for user '%.*ls'.%.*ls
Reason:
The 18456 error occurs when the connection request to SQL Server has been rejected due to authentication failure
Fix:
Make sure to provide a valid database username and password!
Addition information will be provided with the 18456 error response that could be helpful to troubleshoot the root cause.
Msg 18456, Level 14, State 9, Server hostName, Line 1"
State Description
1 -> Error information is not available. This state usually means you do not have permission to receive the error details. Contact your SQL Server administrator for more information.
2 -> User ID is not valid.
5 -> User ID is not valid.
6 -> An attempt was made to use a Windows login name with SQL Server Authentication.
7 -> Login is disabled, and the password is incorrect.
8 ->The password is incorrect.
9 -> Password is not valid.
11 -> Login is valid, but server access failed. One possible cause of this error is when the Windows user has access to the SQL Server as a member of the local administrator's group, but Windows is not providing administrator credentials. To connect, start the connecting program using the Run as administrator option, and then add the Windows user to SQL Server as a specific login.
12 -> Login is a valid login, but server access failed.
18 -> Password must be changed.
38, 46 -> Could not find the database requested by the user.
58 -> When SQL Server is set to use Windows Authentication only, and a client attempts to log in using SQL authentication. Another cause is when SIDs do not match.
102 - 111 -> AAD failure.
122 - 124 -> Failure due to an empty username or password.
126 -> Database requested by the user does not exist.
132 - 133 -> AAD failure.
More Details reference: link
Facing issues? Have Questions? Post them here! I am happy to answer!
Author Info:
Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.
Follow him on: X
You can also reach out to him via e-mail: rakesh@code2care.org
More Posts related to Microsoft,
- How to add Business Users using Microsoft 365 Admin Center
- Microsoft Office Mac Ventura: System Settings must be changed before Microsoft AutoUpdate can run
- Save TextEdit file as Microsoft Word File .docx extension
- Fix - Microsoft Windows Error Code: 0xA00F4244 NoCamerasAreAttached
- How to Save a Notepad file as Microsoft Excel file
- Customize Praise badge for Microsoft Teams with own images, values, brand
- Microsoft Stream - This may not be for you, It looks like you don't have permission to watch this video
- Visual Studio Code available for Apple Mac ARM64 build for native M1 processor support
- Fix: Xbox Error Code: 0x80190190
- Fix Error Code: 80090030 in Microsoft Outlook/Teams
- Microsoft Edge Fix: ERR_TUNNEL_CONNECTION_FAILED
- AADSTS90033: A transient error has occurred. Please try again. [Microsoft 365]
- Fix- Microsoft Word Pages Appear Black
- Microsoft Excel Fuzzy Lookup Add-in
- Graph API error when querying BookingBusinesses - ErrorExceededFindCountLimit, The GetBookingMailboxes request returned too many results
- Keyboard shortcuts to format Source code in Microsoft Visual Studio Code IDE
- Lost your iPhone? Regenerate QR Code for Microsoft Authenticator App
- [Fix] Microsoft Remote Desktop Error Code: 0x204
- How to Sync Microsoft Teams Calendar with Mac Calendar
- How to know file encoding in Microsoft Windows Notepad?
- Fix: Microsoft OneDrive We are currently experiencing technical difficulties
- Fix Microsoft Windows Update Error 80072EFE
- [fix] Microsoft Error Code 0x80004005 - Unspecified error
- How to add Data Analysis Add-in in Excel on Mac
- How to save a file as csv in Windows Notepad?
More Posts:
- How to Open a File with Notepad on Windows 10/11 - Windows-11
- How to change user image icon macOS Big Sur - MacOS
- Resolve - zsh: command not found: code - zsh
- How to add Spring Repository to Maven pom.xml - Java
- Android : Duplicate registration for activity com.example.abc - Android
- PowerShell Concatenate String Examples - Powershell
- Responsive Web Design with CSS Media Queries: A Beginner's Tutorial [Updated for 2023] - CSS
- Send Email using SharePoint PowerShell command, SMTP server - SharePoint