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.