September 16, 2010
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.
You may also like : Basic easy steps to install Apache, PHP, MySql and PhpMyAdmin in Ubuntu
Categories
Windows
Thank you. It worked well. Your answer is the perfect one.
Thank you. It worked perfectly
Thank you…….