What's New
About BjTechNews (1061 Articles)
An IT guy trying to learn everything about technology and sharing it with you all. I'm a blogger and video blogger who highlights daily news in the tech industry, promoting tips and hacks for fellow techies.

31 Comments on Microsoft SQL Server Error 18456 Login Failed for User

  1. TITLE: Connect to Server

    Cannot connect to LAPTOP-P08KTN7B.


    Login failed for user ‘LAPTOP-P08KTN7B\shanndyyy’. (Microsoft SQL Server, Error: 18456)

    For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error



    Server Name: LAPTOP-P08KTN7B
    Error Number: 18456
    Severity: 14
    State: 1
    Line Number: 65536

    this is what mine says, what do i do?

  2. TITLE: Connect to Server

    Cannot connect to localhost.


    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476


    What does this error message mean How can I fix this so it will work? Thank you

  3. Apoorv Jain // May 7, 2016 at 1:34 am // Reply

    very helpful …

  4. Kishan Ranawat // March 4, 2016 at 5:06 am // Reply

    You are genius… I was struggling with this error quite a long time and your solution did it in no time….

  5. hi. everyone . im going to login from my software that i built… when i goto login form in my software. it gives me the message unable to login to ‘username-pc\username’ what is is the problem

  6. I m still facing the problem as i cannot login using windows authentication as well

  7. I also facing sa admin problem.But I also follow above these information.above information was not permanently.we can setting again and again.

    I hope that anyone my problem solved recently.


    Marut Kumar tiwari

  8. helped me a lot….THANKS big time

  9. I was locked out and got the SQL error 18456. Eventually I managed to reset my lost SA password using SQL Server Password Changer.

  10. Ellis White // May 17, 2014 at 7:09 am // Reply

    Read this article http://www.sqlrecoverysoftware.net/blog/sql-login-error-18546.html and resolve this SQL error 18456 with simplicity

  11. Ricardo silva from venezuela // March 6, 2014 at 9:06 pm // Reply

    gracias, estuve viendo mas de 8 videos y cada uno variaba en cierta cosas, pero eran semejante, pero con su información resolví, el problema, gracias

  12. Excellent, this helped a lot. Also, don’t forget to restart as the video says. I got stuck there for a couple of minutes. Thanks!

  13. very good, very useful , simple to understand
    Thanks a lot

  14. this was helpful

  15. i am not able to login using the SA account
    please help me

  16. i can not thank you enough 😀

  17. excellent article.. resolved my issue too..

  18. karthikeyan // March 29, 2013 at 2:24 pm // Reply

    Hi,I was working by using my login.I dont know what I did,not able to login to SSMS.All time throwing the error message that login failed for my account .what could be the problem?

  19. Thnaks… It helped me… Good.

  20. Hi,
    I am still facing the same problem, i need how to change the user (sa) settings on the system, cause the authentication to that particular user still windows session based.
    Thnks in advance.

    • 1.
      Start a command prompt as NT AUTHORITY\NETWORK SERVICE

      1. Open a command prompt.

      2. Type the following command to create a new service that launches Task Manager (note the spaces after the equals signs): sc create MyService binPath= %WINDIR%\system32\taskmgr.exe type= interact type= own

      3. Right click on Computer and go to Manage

      4. Open up services and find MyService, right click on it and start it. (If you are in server 2008 it will ask you to view an interactive service message, click show me the message)

      5. When Task Manager appears, select File->New Task (Run…) and type cmd. You now have a cmd promt running as NT Authority/Network Services

      Enable the SA Account (If not active)

      1. In the command prompt type:
      osql -S TheNameOfYourSQLServer -E

      2. Type this where it displays 1>

      3. type this where it displays 2>

      Reset the SA account’s password (if this is the first time it has been used, it may be blank already)

      1. In the command prompt, if you didn’t do this in the last step, type:
      osql -S TheNameOfYourSQLServer -E

      2. Type this where it displays 1>
      sp_password NULL,’NewPassword’,’sa’

      3. Type this where it displays 2>

      • Morse DeVane // October 31, 2013 at 12:07 pm //

        How do you open a command prompt using NT AUTHORITY\NETWORK SERVICE when the password is unknown?

  21. Thanks lot to give such a details explanation. U solved my Problem, good work!

  22. i am still facing that problem

  23. Holy shit, after HOURS of messing around this fixed my problem. The server was set to Windows Authentication only for some reason.

  24. Thank you so much! I googled a lot, and this was the ONLY post that really got deep into the issue. Clear and with screen shots, thanks!!!

  25. You are an absolute hero!
    i was struggling with this 18456 error for a couple hours and your post helped me to solve it about 30seconds. Thanks!

7 Trackbacks / Pingbacks

  1. microsoft sql server 2008 r2 error 18456 login failed
  2. How To Fix Microsoft Sql Server Error 18456 How To Fix in Windows
  3. How To Fix Microsoft Sql Server Error Code 18456 in Windows
  4. Login failed for user “domainnameusername” error in asp.net - PKT
  5. ➤ Iniciar Sesion Failed For User Sql Server 18456 【Iniciar Sesion】
  6. Sql Server 2012 Login Failed For User - logininfos.com
  7. Sql Management Studio Login Failed For User 18456 Portal - logininfos.com

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.