27.2 C
Friday, July 19, 2024
HomeWindowsLogin failed for user sa error 18456

Login failed for user sa error 18456

While accessing Microsoft SQL Server through Management Studio I got stuck with this error

Login failed for user ‘sa’ Error: 18456

after an hour of r&d I could able to connect to server. let me tell you the steps how to change the authentication mode.

Connect to Microsoft SQL Server database Server through management studio by selecting Windows Authentication, then right click on Server, then Properties select Security and change it to mixed mode from windows authentication mode.

Go to run, type Services.msc and there restart Sql Server Service.

That’s it. You will be able to log in as “sa” as well as windows authentication mode.

Durga Charan Ojhahttps://lifeonnetwork.com/
I am a proud Indian, proud father, a blogger, Being in a profession as System administrator, my passion is troubleshooting computer issues, I do like sharing solutions through blogging making videos of solving issues.



Please enter your comment!
Please enter your name here

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

Most Popular