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
-
Have Questions? Post them here!
More Posts related to Microsoft,
- Microsoft Office Excel - Couldnt Open the Workbook - The workbook cannot be opened.
- [Fix] Microsoft AADSTS900561: The endpoint only accepts POST requests. Received a GET request.
- Remove Possible Data Loss Message from Microsoft Excel
- [Fix] Cannot connect to Microsoft SQL Server, Error: 18456
- Microsoft Stream - This may not be for you, It looks like you don't have permission to watch this video
- How to fix Microsoft Windows 10 update error 80070020
- Outlook - The mailbox isn't available. This may have occurred because the license for the mailbox has expired.
- [Fix] Connect to Minecraft Remote Connect URL via https //aka.ms/remoteconnect
- AADSTS90033: A transient error has occurred. Please try again. [Microsoft 365]
- Fix Power Automate FLOW error - InvalidTemplate Unable to process template language expressions in action
- FCM Messages! Testing Notifcation from Microsoft to investigate this problem [Microsoft Teams]
- Remove mailto link from Microsoft 365 Word Document Email Text
- How to turn off Dark theme in Excel for Mac
- Microsoft Sign-in Error Code: 50058 (Request Id, Correlation Id and Timestamp)
- Fix 0x80070194 Error When Opening Microsoft OneDrive File
- [fix] Microsoft Error Code 0x80004005 - Unspecified error
- Fix - Microsoft Windows Error Code: 0xA00F4244 NoCamerasAreAttached
- Save a Notepad file as Microsoft Excel file
- MO229507 UK Europe users cannot access Microsoft 365 - SharePoint, OneDrive, Teams, Admin center, Planner, Yammer
- How to know file encoding in Microsoft Windows Notepad?
- How to save a file as csv in Windows Notepad?
- Microsoft Office Mac Ventura: System Settings must be changed before Microsoft AutoUpdate can run
- Fix Error CAA50021 - Number of retry attempts exceeds expectation - Microsoft 365 Apps
- Microsoft 365 Excel - PRO TIP Discover insights quickly with Power BI, which is already included in your Microsoft services, See it in action
- [Microsoft Teams 4c7] Modern authentication failed here, but you'll still be able to sign in. Your status code is 4c7 error
More Posts:
- Convert JSON to Gson with type as ArrayList - Java
- SharePoint Excel error - The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser - SharePoint
- How to see Storage Information on macOS Ventura - MacOS
- Git: Delete Branch Locally and Remotely at Origin - Git
- macOS - cannot calculate MAC address: Using fd 9 hv_vm_create HV_ERROR [PHP XAMPP] - PHP
- Read Text file from SD Card : Android Programming - Android
- fix macOS: The digital signature on the update is missing or invalid. Ventura - MacOS
- Installing JD Decompiler plugin in Eclipse IDE - Eclipse