Description:In this article I am going to explain about how to enable or configure SQL Server Authentication mode or Mixed mode Authentication in SQL Server.
Steps to Enable SQL Server and Windows Authentication mode via SQL Management Studio1. Open the SQL Server Management Studio with an elevated privilege(Run as administrator).
2. Select SQL Server instance or type the instance name (machine\sqlinstancename). then click the Connect button.
4. Navigate to the Security page, select SQL Server and Windows Authentication mode, and click OK
5. We need to Restart corresponding SQL Server service to take effect this change immediately.