Microsoft SQL Server Error 18456 Login Failed for User

Notes on SQL Server Error 18456

Hope you guys enjoyed. I really appreciate the feedback. Hit the like button & show support it doesn't hurt :)

Windows 8 App (BJTechNews):

Tech Blog:

Here's how I get free Amazon Gift Cards:

Tech Forum:

Facebook:

Twitter:

Instagram:

Google+:

Chat Room:

MySpace:

[manwithouteyes]

You just ended 5 hours of frustration. If we ever meet IRL, I owe you a beer.

[Myblueretro]

Ah yes, a video from 8years ago saved me with my upcoming exam. You've gained my immense respect, sir.

[eletricman]

Well I have the option that you mentioned ticked and still doesnt work?Any ideas

[davidchavez]

I have been looking in forums for a solution to this problem and nothing, and you with 2 minutes of video have solved my problem. Thanks a lot friend.

[freddycalderon]

hey there! I can't even use the domain account to log in. Any help/advice would be appreciated, thanks!

[sunilvishwakarma]

i have disabled the status (permission to connect to database engine and login) of admin login, how to enable the same?

[kimcuongpham]

I do as the same you show here but in the server authentication it's been chosen SQL server and windows authentication already. What should I do?

[sandeepranaa]

Thanks a lot, it worked, but I have a query, I'm not able to make fixed field file in SQL 2008, where as its easy in SQL2000, can you help me with it, thanks in advance

[surprizyumurtaikizleri]

I have different problem about 18456 Error. Connection establisining by user 'sa' and it's password. And I can view database and table structure, it's OK. But when I want to view data or run a query this 18456 Error pops up. How can I overcome this issue?

[ciscoinch]

2 sql server software -- which one to use this technique ?!!

1. sql server on your pc (i.e. trying to remote access the server from here)
2. should we do it on the SQL SERVER where the database is RESIDE-ING ?

[richardokafor]

I just can't see any reason why this very short and really helpful video should get even 1 dislike. I mean it's to straight forward and easy to follow. Thank you so much, it really helped

[guneetsingh]

and if somebody forgot its username..., is there is any chance to get it

[tshiamobaepi]

For me it gives error for both the accounts, windows authentication and sql authentication...please help

[prasantchakroborty]

its not working for me.I tried the windows login but got the error message"windows log in are not supported in this version of sql server".Can someone help?

[masjediaqtash]

hi sir mine dose not accept (ssms) in run window. it says the name is not correct .

[longtruong]

can this user and database be accessible from another computer, sir

[khahlisom]

I get a: "Windows logins are not supported in this version of SQL Server. (Microsoft SQL Server, Error: 40607)" error when I select Windows Authentication

[MnassriSami]

Just ended several days of wondering. Turned out I needed to restart the server and I thought restarting the SQL Server Management Studio will do the trick! :D
Thank you sir!

[proyeccionista]

What IF I'm still having the same error?

[tasfiqueahmed]

Dude you save the day!!! Happy Thanks Giving