About these ads

Posted on March 20, 2012, in SQL and tagged , , , , , , , . Bookmark the permalink. 21 Comments.

  1. 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!

  2. 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!!!

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

  4. i am still facing that problem

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

  6. 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

      2.
      Enable the SA Account (If not active)

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

      2. Type this where it displays 1>
      ALTER LOGIN sa ENABLE

      3. type this where it displays 2>
      GO

      3.
      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>
      GO

  7. Thnaks… It helped me… Good.

  8. 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?

  9. excellent article.. resolved my issue too..

  10. i can not thank you enough :D

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

  12. this was helpful

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

  14. 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!

  15. Ricardo silva from venezuela

    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

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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 516 other followers