Enable Sql Server Authentication Mode And User Login

Error :Login failed for user sa. (Microsoft SQL Server, Error: 18456)

While installing the SQL server where you will find the two installation mode one is Windows Authentication mode and another one is Mixed Mode. If you choose Mixed mode Server Authentication Mode is auto activate but if you forget to do that you need to enable it manually and also need to set the password of sa to remember that sometimes we set the password of sa and also enable sa for login but we forget to enable Server Authentication mode. In this article, I show you how to enable and set the password for login sa and enable SQL Server Authentication Mode

1. Login using Windows Authentication Mode

2. Go to security tab and right click on sa and go to property of sa

3. Click on  general, set a password for sa

4. Go to status ( in default login is disabled click on enable ) and click on ok

Now again not enable for login ? yes now you have to Enable Sql Server and Windows Authentication Mode

To Enable SQL server and Windows Authentication Mode you need to follow following steps

1. Right click on server name which is in the top and go to the server property

 2. Clcik on Security and you will see there will be checked in Windows Authentication Mode. Now change it to SQL Server and Windows Authentication Modes. and click on Ok

After complete, all process go to windows services and restart the SQL server  services which is running