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 Studio
1. Open the SQL Server Management Studio with an elevated privilege(Run as administrator).
2. Select SQL Server instance or type the instance name (machinesqlinstancename). then click the Connect button.
medianet_width=’728′; medianet_height= ’20’; medianet_crid=’812152226′;
3. Right-click on the connected server instance, and click Properties.
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.
Thanks,
Morgan
Software Developer
Advertisement