This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 41%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKZ%3C/text%3E%3C/svg%3E)
I’m trying to login to SQL Server (SSMS) with the server name that is listed under the database engine section on the login screen. It’s the same server I used previously to access SQL but it keeps giving me this error: “A connection was successfully established with the server, but then an error occurred during the login process.” So I checked in the configuration manager to make sure the server was running, which it is. In the options>connections properties tab I selected the “trust server certificate” box & I added within the additional connection parameters: “TrustServerCertificate=True” After I updated everything I tried to login the error message then changed to: “Login failed (Error:18456)”. I double checked to make sure I’m using the windows authentication drop down as well. Also I have never created a SQL username and password so I don’t know why it is saying my login is failed. I have tried everything and spent countless hours trying to fix the issue. Can someone please help?
@Ke’Ziah - Just checking in to see if the below answers helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
@Ke’Ziah - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
(Error:18456)
18456 is a generic logon failure, you can find more details about in SQL Server ErrorLog file.
Thank you! Do you have any video recommendations to troubleshoot the issue? The link you provided doesn’t give great detail as to how to fix the issue.
00000
So what Olaf said is that you should look in the SQL Server errorlog. When a login fails, the message displayed to the user is short on why login failed (since that information could be helpful for an attacker). But there is more information is in the SQL Server errorlog. If it says nothing to you, feel free to share it here.
Although; I need to add that I am not really sure that there is a message in this case, because the error message you get is not the normal for error 18456. Could you share the full message you see, maybe with a screenshot?
Hi @Ke’Ziah
the error message then changed to: “Login failed (Error:18456)”.
You get this error message when a connection attempt is rejected because of an authentication failure. User logins can fail for many reasons, such as invalid credentials, password expiration, and enabling the wrong authentication mode.
Please refer to this doc for more details: MSSQLSERVER_18456.
Best regards,
Cosmog Hong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thank you! Do you have any video recommendations to troubleshoot the issue? The link you provided is very hard to follow along & none of the options seemed to apply to me.
Hello
Make sure that ports 1433 and 1434 are open