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!
More Posts related to Microsoft,
- Lost your iPhone? Regenerate QR Code for Microsoft Authenticator App
- What is Microsoft 365 Message You are using more licenses on your trial than what you will purchase once the free trial ends.
- Power BI error Something went wrong, unable to read the application metadata
- How to save a file as csv in Windows Notepad?
- You're not on Teams yet, but you can set it up for your organization. [Microsoft Teams Login Error]
- Fix- Microsoft Word Pages Appear Black
- How To Remove Only Conditional Formatting in Excel
- How to record PowerPoint slide show presentation on Mac - narration, slide timings, ink gestures
- Fix 0x80070194 Error When Opening Microsoft OneDrive File
- 0xCAA20003: You ran into an authorization problem. [Microsoft]
- PowerShell git: The term git is not recognized as the name of a cmdlet
- Remove mailto link from Microsoft 365 Word Document Email Text
- How to take a screenshot on Microsoft Windows OS on PC or Laptop
- How to Force Quit Microsoft Excel Application on Mac
- [fix] Microsoft Error Code 0x80004005 - Unspecified error
- How to Delete a Sheet in Excel on Mac
- How to add Business Users using Microsoft 365 Admin Center
- [Microsoft Teams 4c7] Modern authentication failed here, but you'll still be able to sign in. Your status code is 4c7 error
- Fix Microsoft Store Error Code: 0x80072EFD
- How to add Data Analysis Add-in in Excel on Mac
- How to Select Two Separate Columns in Excel on Mac
- Internet Explorer browser auto redirect to Microsoft Edge for compatibility with modern web sites
- How to Create Absolute References in Microsoft Excel for Mac
- What is FCM Messages Test Notification! [Microsoft Teams] [Google Hangouts]
- How to Sync Microsoft Teams Calendar with Mac Calendar
More Posts:
- Command to display epoch time Terminal - Linux
- Calculate Volume of Sphere - C-Program
- Download interrupted: Unknown Host dl-ssl.google.com Error Android SDK Manager - Android
- [Microsoft Teams] You're not on Teams yet, but you can set it up for your organization. - Teams
- How to call a SQL StoredProcedure from Hibernate - Java
- How to Set Homepage on Chrome - Chrome
- Error 404 Tomcat homepage http://localhost:8080/ not displayed - Tomcat
- JSON Syntax : JSON Tutorial - Json-Tutorial